Posted Fri, 21 Dec 2012 17:05:00 GMT by Portal Admin

Is there a sequel system file which lists the reports and tables dependencies?
Is there a way to search the text from multiple scripts looking for report and view names?
I am wanting to do some cleanup but would like to know all of the dependencies 1st.
Thanks
Derek

Posted Thu, 16 Jun 2016 05:00:00 GMT by Portal Admin

1. I use the following command to create a file.

SEQUEL/DSPVIEWD VIEW(your_library/*ALL) ATTRIB(*ALL) TYPE(*SQL) OUTPUT(*OUTFILE) OUTFILE(your_library/afilename)                                       

 

2. Create a view over the new file you created.  The field called SQL is sequel statement for a view. 

Your Where clause would look something like this...

Where SQL contains 'file name your searching for"... etc.  

 

Originally Posted By [email protected]

You must be signed in to post in this forum.