DB2 BIND process

[marath]

Hi All
I have a doubt regarding DBRM and Bind Process.
Suppose I have a cobol program which contains embedded sql statements. If i am making any chnages to sql statements I have to Create a new DBRM and again Bind it. I want to know that if I am not making any changes to the sql statemets and making some changes to some cobol statemetns and compiling it , whether it is required to Create DBRM and again Bind it?

Please give me the full functionality of DBRM and BIND

with Regards,

Marath

 

[MarcLodge]

Marath,
There are 4 steps to a DB2 Cobol compile
1) DB2 pre-compile. Creates the DBRMLIB entry
2) Compile. Compiles the code output from the pre-compile and creates an object module
3) Link edit. Takes the object module and creates an executable load module
4) Bind. Uses the DBRMLIB to bind to the SYSIBM tables

At run time, the load module timestamp must match up with the DBRM timestamp or you will get an SQL error. It is usual therefore to run the full 4 steps when compiling a Cobol program, even if you have not changed the SQL

Hope this helps

Marc

 

[marath]

Hi Marc

Many many thanks for this information.

With Regards,

Marath