DB2 queries from Program Load

gaurav.rajvanshi · Posted: Mon Jul 23, 2012 12:15 am

Hello All,

Can we get the SQL queries used in a COBOL-DB2 program if we just have its load module for reference.

Thank You...

Nic Clouston · Posted: Mon Jul 23, 2012 1:33 am

I am not sur if I understand what you mean! Do you mean eye-balling the load module to see the SQL queries in plain English. They are not even in plain English when they get to the compiler.

dbzTHEdinosauer · Posted: Mon Jul 23, 2012 2:28 am

you can find the SQL in the DBRM library (Database Request Module library) which is:

populated by the db2 pre-compiler in the pre-compiler step
or populated by the co-processer in the compiler step - e-cobol compiles

A read of the the general db2 overview in the db2 manuals would have provided you with this information.

gaurav.rajvanshi · Posted: Mon Jul 23, 2012 10:28 am

Thanks dbZ for your reply but I wasn't able to find the same in the manuals also.

Please let me try to make my question more understandable...

A third person has provided me with a load module only (Don't know where and when he compiled his program). I want to get the queries used in the program. I just have the load module for reference which I can also use in my JCL. Do we have any ways for finding the queries by looking into the DB2 catalogs or anything else after the job completes.

Any valuable reply would be appreciated...

GuyC · Posted: Mon Jul 23, 2012 12:19 pm

assuming this is static SQL : if you can run the program, you also have a package and thus a stmt in SYSIBM.SYSPACKSTMT

Craq Giegerich · Posted: Mon Jul 23, 2012 5:44 pm

Did you consider browsing a loadlib member to see what is there?

gaurav.rajvanshi · Posted: Mon Jul 23, 2012 6:07 pm

don.leahy · Posted: Mon Jul 23, 2012 9:39 pm

The load module won't tell you much about the SQL text that it is processing. If you look at a compile listing you will see that all of the embedded SQL statements are commented out by the precompiler. The Cobol compiler does not store comments in the object code that it generates, so there is no way that it will end up in the load module.

As others have stated, the only place, besides the original source code, that you can find the SQL text is in the DBRMLIB member and/or SYSPACKSTMT. That's assuming that the program contains only static SQL.

If it contains dynamic SQL, you might get lucky and see some literals in the load module that give a clue as to what it is doing.

dick scherrer · Posted: Mon Jul 23, 2012 11:18 pm

Hello,

Suggest you tell the "third person" that you need the source for the SQL . . .

dbzTHEdinosauer · Posted: Tue Jul 24, 2012 12:08 am

i thought that it was odd
that someone wanted some specific sql
but did not know what the sql was.

don.leahy · Posted: Tue Jul 24, 2012 3:26 am

Perhaps the TS is trying to install a module from outside his installation. That might explain the lack of source code.

dick scherrer · Posted: Tue Jul 24, 2012 7:46 am

gaurav.rajvanshi · Posted: Tue Jul 24, 2012 10:14 am

Thanks GuyC, Thanks Don for your valuable replies

and thanks dick/dbz for doing your best to keep the post interesting by putting in your funny comments. They really don't help...

Nic Clouston · Posted: Tue Jul 24, 2012 11:29 am

Your original post states

Marso · Posted: Tue Jul 24, 2012 6:13 pm

enrico-sorichetti · Posted: Tue Jul 24, 2012 6:29 pm

dick scherrer · Posted: Tue Jul 24, 2012 8:04 pm

Hello,

gaurav.rajvanshi · Posted: Tue Jul 24, 2012 8:16 pm

Thank You all...