Problem:

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.

Resolution:

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

1 is returned if the compilation is successful and an executable will be created (.rqc)

To run the script:

>>invoke ("c:\\scripts\\sqltable.rqc")

Attachments:

sqltable.rqs