MVSFORUMS.com

[luckystarlak]

Hi,

Other than writing some kind of tool in rexx etc., is there any way that we can get a list of SQL query used in a particular cobol program.

Thanks
laks.

[dbzTHEdinosauer]

Parse the DBRM
_________________
Dick Brenholtz
American living in Varel, Germany

[haatvedt]

I've written a small program that i use as a poor man's db2 precompiler on my pc...

i download source code, run it through a program which comments out all the DB2 statements and then i can compile the output on my pc cobol compiler (just for syntax checking). then i have another program that uncomments all of the statements commented out by the "precompiler" program.

the "precompiler" program could be modified pretty easily to only write out the lines which contain SQL...

let me know via email if you're interested, I could send you the source code.
_________________
Chuck Haatvedt

email --> clastnameatcharterdotnet

(replace lastname, at, dot with appropriate
characters)

[CZerfas]

You could, of course, access the DB2 catalog (if the DBRM has already been bound) and look into SYSIBM.SYSSTMT for that particular package.

If you have access to BMC catalog manager, you can use the DESCRIBE command for that package and get all informations about that package, including the SQL statements (and their access paths).

regards
Christian