Why two timestamp there and what is the use of both of them

soumyaranjan007 · New User Joined: 30 Aug 2006 Posts: 30 Location: mumbai

hi,

in db2 program load module have two timestamp. could any one explain why two timestamp there and what is the use of both of them and which one come first( dbrm time stamp or loadmodule)

Thanks
Soumya

kussu · New User Joined: 16 May 2007 Posts: 33 Location: India

While executing the COBOL_DB2 program, precompiler comments all the sql statements and assign that to DBRM, and only the cobol statements will be assigned to compiler

sql related issues wil be handeled by DBRM and the Cobol related issues will be handled by Cobol compiler. and finally these two will be combined to give a Cobol-Db2 program.

At this time precompiler assigns 2 timestamps
[One for DBRM and another for load module] , in order to identify the sql statements related to that particular cobol program.

Based on the time stamp matching only finally it will combine both SQL statements and Cobol statements.

Thanks
Kussu