IBM Mainframe Forum

I have a requirement where I need to extract all sql statements in cobol source code. I have 'n' no of cobol source libraries and I need to scan each member inside the libraries for sql statements and extract those statements into a newly created PDS under the same member name.

I'm not familiar with REXX and so I've started looking into REXX manuals to come up with the REXX code on my own. But considering the time available, I'm searching web hoping that the required REXX code might already be there somewhere. I came across this thread http://ibmmainframes.com/about28179.html and unfortunately could not see the code. Can anyone help me to get this code?

Thank you.

There is code posted in that link you provided. It's an attachment you'll have to download.

thats the syndrome of NOT downloadable attachments

anyway I just looked at it ...

IMO badly written, not documented,
the awkward variable names make difficult to follow the logic

not even thoroughly tested
( the main path falls straight don a called procedure )


too muck work for somebody who agrees on

I'm not familiar with REXX ...

Do you have the compile listings for the programs in question? The compiler has done all the complex stuff, and you strip out from there...?

why not try to extract them from SYSIBM.SYSSTMT ?
worth looking at as an alternative !

Hi Billyboyo,
Do you mean precompile o/p, the DBRMLIB? Those are not in readable format.. Is there a way to convert it?

No, I mean the listing from the final compile of the Cobol program.

BillyBoyo wrote:No, I mean the listing from the final compile of the Cobol program.

Would that not give heesh only the calls to the DB2 routines? Or am I mistaken in thinking that what heesh wants is the text between the EXEC-SQL and END-EXEC delimiters?

Akatsukami,
Your interpretation is correct.. I would need those line of code between EXEC SQL and END EXEC..
BillyBoyo,
As akatsukami said will it not contain the equivalent calls to DB2 routine? Curse my ignorance. how can I get the SQL statements from the compile listing?

Enrico,

why not try to extract them from SYSIBM.SYSSTMT ?
worth looking at as an alternative !

Thanks for your suggestion. I am considering it. But the unicode format bothers me. I have started looking into type casting stuff.. Hope I learn to convert it into readable format..