How do a call to sql look like in cobol prog after precompil

vinayakaa · New User Joined: 20 Mar 2005 Posts: 8 Location: Bangalore

Hi,
we all know that in a cobol db2 program during the precompilation process the sql statements are seperated from cobol program and put as DBRM, these statements are replaced in cobol program as cobol call statements, can anyone tell how this call looks like.

Thanks in advance,
raju

i413678 · Posted: Tue May 10, 2005 12:31 pm

Hi ,

I think if you go for compiler listing you will find CALL <name> type of statements for each and every sql statement in the program.

Any information more please let me know.

Cheers........

pavankumar

vinayakaa · New User Joined: 20 Mar 2005 Posts: 8 Location: Bangalore

Thank you,
That is a way, but I dont have a DB2 access to compile a cobol db2 program. Please let me know how it looks like.

thanks,
Raju

ajay_dheepak · New User Joined: 12 May 2005 Posts: 32 Location: Chennai

U dont need to have DB2 access to compile a DB2 COBOL pgm. Just use the normal Compile JCL for DB2 to compile.

Or do one thig...use a DB2 precompiler and compile ur program the output will have all the DB2 statements translated to CALLs.

seegovind · New User Joined: 02 Apr 2005 Posts: 3

when we precompile the DB2 COBOL program, the compiler DSNHRC will split program into two parts,one is Cobol prog another one is Sql