GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Mainframe  >  DB2
Go To First  |  Previous Question  |  Next Question 
 DB2  |  Question 192 of 198    Print  
db2 pre-compiler
what is a db2 precompiler?


  
Total Answers and Comments: 5 Last Update: June 18, 2009     Asked by: medamahendra 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: ragavprasanna
 

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.



Above answer was rated as good by the following members:
lchao, davindersingh29
June 24, 2008 06:48:01   #1  
santoshvadlamani Member Since: June 2008   Contribution: 1    

RE: db2 pre-compiler
we can replace the sql statements from source module by using db2 interface languages like db2 precompiler

 
Is this answer useful? Yes | No
August 31, 2008 04:55:12   #2  
ragavprasanna Member Since: August 2008   Contribution: 3    

RE: db2 pre-compiler

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.


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
December 14, 2008 23:22:49   #3  
maya007 Member Since: April 2008   Contribution: 6    

RE: db2 pre-compiler
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.

 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 0Overall Rating: +2    
April 16, 2009 05:48:07   #4  
veluvpv Member Since: April 2009   Contribution: 3    

RE: db2 pre-compiler
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.
 
Is this answer useful? Yes | No
June 18, 2009 07:50:47   #5  
davindersingh29 Member Since: April 2009   Contribution: 5    

RE: db2 pre-compiler
Consistency token and time stamp are same thing.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape