Toad World® Forums

Toad TAS files and reporting

Hello,

Are their any options to riun areport against a tas file and have it provide the info
contained in that file to and excel report ?

I have over 50 Large Tas files and every time I need to make changes I have to
go into each and every section of the script to fin what I’m looking for as I cant recall exactly where the sections or sql that I need to modify is located.

I wanted to check to see if this functanilty existed befoe I create my own utlility.

Thanks
Paul

Hello,

Can quest please respond ?

Thanks
Paul

Sorry for the delay Paul.
Toad does not have a utility to report on the contents of your tas file.
To get a better understanding…
Are you embedding SQL in your automation scripts and then wanting to see what is in your automation scripts without needing to open those?
How are you including SQL in your automation scripts?
Thanks
Jeff

One thing that might assist, if you are not already aware of, is the concept of having your automation scripts 'Link' to a file. If that option is selected, when the automation script runs it will pick up and use the current contents of the script file.
That way, if you need to change your queries, you can do so without needing to modify the automation script. See image for the location of that option.
Hope this helps.
Jeff