Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Explain db2 precompiler process

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Explain db2 precompiler process
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    Post subject:
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    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
No new posts Can someone explain me this JCL line ... PeterHolland JCL & VSAM 9 Sat Dec 12, 2015 7:22 am
No new posts How to make REXX process different GDGs? venksiv CLIST & REXX 15 Thu Sep 24, 2015 5:35 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us