IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Explain db2 precompiler process


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
karthi_ind

Active User


Joined: 24 Feb 2004
Posts: 131
Location: Chennai

PostPosted: Sun Jun 06, 2004 3:37 pm
Reply with quote

hi


if my interviewer asks explain db2 precompiler process.
whatz the answer? Can anyone explain in detail,
explain each process (bind, package, collection)

bye

anbudan
karthi G.
Back to top
View user's profile Send private message
harikrishnanrajeev

EXPERT


Joined: 28 Jan 2004
Posts: 37
Location: Trivandrum

PostPosted: Mon Jun 07, 2004 2:17 pm
Reply with quote

Hello friend,

Here am trying to explain the DB2 - cobol process. The first stage is the precompilation step where the cobol program with the embedded SQL will be modified to form the modified source code and also the DBRM. The DBRM contains the sql statements. The timestamp is also alloted here, the information remains with both DBRM and the modified source code. In the modified source code the sql statemements will be replaced by call to DSNHLI statements with some 5 parameters. These are

1. The DBRM name.
2. SQL statement numbers.
3. The timestamp information.
4. Address info of SQLCA
5. Address info of host variables.

The DBRM undergoes the bind process and package is created. The package is not an executable so we make use of plan. The plan contains pointers to packages.

The modified source code is compiled , link edited to form load module. Then the timestamp is matched with the info in package. If mismatch is there we get timestamp mismatch error and rebind has to be done with proper DBRM.

here i have given just a rough idea abt the process. Pls do read some books for better clarity.

corrections are welcome

regards

Hari.
Back to top
View user's profile Send private message
nandini

New User


Joined: 27 Feb 2004
Posts: 18

PostPosted: Mon Jun 07, 2004 7:36 pm
Reply with quote

Hi Hari

If we are changing the modified source program and we are not binding it what will happen? And in a case i m not changing the progm and again binding what will happen? Here in which case the timestand mismach will occur?

Can pls explain?

Nandini
Back to top
View user's profile Send private message
anuradha

Active User


Joined: 06 Jan 2004
Posts: 247
Location: Hyderabad

PostPosted: Tue Jun 08, 2004 9:01 pm
Reply with quote

hello nandini,

if you are modifying the program and if you are not binding it, you will get a timestamp mismatch error.

Thanks,
Anu
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DB2 Statistics - Using EXPLAIN and qu... DB2 1
No new posts process statement for SUPREC, CMPCOLM... TSO/ISPF 4
No new posts How to process dependent file based o... JCL & VSAM 8
No new posts Bind process DB2 4
This topic is locked: you cannot edit posts or make replies. How to process gdg in rexx program wh... CLIST & REXX 12
Search our Forums:

Back to Top