How to extract a SQL from a Input Data Tool

[Gihans]

Hi,

I'm having trouble extracting a SQL from one of my workflows as the database has been decommissioned.

I was wondering, if there is an alternative way to extract a SQL from a Input Data Tool.

Regards,

Gihan

[alexnajm]

Can you click on the three dots by Option #3 and open up the SQL Editor? There you should be able to view your code (if it works).

[dho111 · Accepted solution]

The three dots button probably won't work without an active SQL connection. You can update the Input Data tool to current active Server. 

If that's not an option, you should still be able to view the full SQL string in the XML View. 

 

[Gihans]

Hi Alex, Thanks for your reply. Unfortunately, regular method (three dots by Option #4 ) doesn't work when you do not have connection to the database.

[Gihans]

Thanks. It worked !