We execute changes to our application (schema and data) using scripts executed in Toad Editor. These scripts often have multiple SQL statements obviously. We need the ability to keep a record of the whole execution for audit/bug fixing/training reasons etc.
We can look at the Messages tab and perform a Cntl+A on that and paste that, but the statement output in the Results Sets cannot be selected all together to be copied anywhere. I have to click on each row in the result set and manually export it (x 48 times)!
Solution 1 Provide ability to log ALL output from a script to a file, if result set contains data then export each SELECT output as a separate sheet in ONE Excel file.
Solution 2 Provide ability to log ALL output from a script to a file, if result set contains data then export each SELECT output to a separate Excel file.
Solution 3 Provide ability to log ALL output from a script to a file or clipboard, so user can paste it where they choose.
If solution 3 is the fastest (probably is) then go for that please!
Enhancement request CR 98,354 has been submitted to Development for consideration in a future release of Toad for DB2.