REQL to show Cobol programs and copybooks that contain SQL INSERT and UPDATE
What REQL statements return all Cobol programs and Copybooks that contain a SQL INSERT or SQL UPDATE statement, on a given database tables?
The result to be ordered by program, not by sql_statement.
Save the attached script (.rqs) on the pc, for example c:\scripts
From the tools menu in Revolve choose shell. Compile the attached script and run the script in Revolve Shell.
To compile the script in the shell enter the following:
>>show compile ("c:\scripts\sqltable.rqs")
1 is returned if the compilation is successful and an executable will be created (.rqc)
To run the script: