Basic DB2 question from a novice 1

[widowweeds]

Dear Members,

Can anybody detail for me the whole pre-compile, compile, link and bind process?

Thanks in advance for any assistance given.

 

[MarcLodge]

Hi again WW,

Pre-compile: trails thru source code adding calls to the actual DB2 elements. Produces updated source code and DBRM

Compile: trails thru updated source code and creates object module with timestamp

Link: takes object module and creates a callable load module.

Bind: Takes statements from DBRM, validates them (usually) and writes the output to SYSIBM tables under a PLAN or PACKAGE.

When running program under DB2, load module and PLAN or PACKAGE are specified and these must match up.

Hth

Marc

 

[widowweeds]

Dear Marc,

Thanks once again for the assistance.

 

[MarcLodge]

You're welcome. Thanks for the feedback and star :->