Db2 pre-compiler

What is a db2 precompiler?

Questions by medamahendra   answers by medamahendra

Showing Answers 1 - 5 of 5 Answers

ragavprasanna

  • Aug 31st, 2008
 

When a Cobol program contains any embedded SQL statements the pre-compiler separates the non-Cobol statements and the Cobol statements separately, then the pre-compilation process begins. The non-cobol (SQL) statements are stored as a member of the pds called DBRM, then the bind process begins, which checks for any syntax errors in SQL statement and then creates the plan or packages as per the installation defines.
plan -> group of packages makes a plan.
It is nothing but the executables (load module) of the program, then the
Cobol statements load module is stored separately but before execution the two load modules are combined and then executed.

maya007

  • Dec 14th, 2008
 

Yes the previous answers are correct. I would to add one more point.

During the pre-compilation time, the timestamp will be created & this timestamp should get matched for both the plan & load module during the execution. Time stamp factor is also known as consistency parameter.


Cheers,

Vishwanath.

veluvpv

  • Apr 16th, 2009
 

I would like to add few points to it, during pre-compilation process it creates an consistency token (not time-stamp) between bind package and load module.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions