Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

REQL to show Cobol programs and copybooks that contain SQL INSERT and UPDATE

REQL to show Cobol programs and copybooks that contain SQL INSERT and UPDATE

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

Old KB# 5103

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 17:22
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.