Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How DB2 binding works in real time

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
bhageeradhi

New User


Joined: 23 Apr 2005
Posts: 2

PostPosted: Tue Dec 19, 2006 1:16 pm    Post subject: How DB2 binding works in real time
Reply with quote

Hi,
Any one of you tell me, how the code is excuted means precompilation, binding, preparation of plan, package etc...in realtime in DB2?
Thanks & regards,
Sunitha.G
Back to top
View user's profile Send private message

vicky10001
Warnings : 1

Active User


Joined: 13 Jul 2005
Posts: 136

PostPosted: Tue Dec 19, 2006 3:32 pm    Post subject:
Reply with quote

DB2- SQL statements will have to be embedded with any of HLL such as COBOL for it to be executed other than by making use of SPUFI, such kind of Tools.
In this case, COBOL-DB2, normal cobol compiler didn't understand SQL statements. So a precompilation has to be done in which SQL statements would be converted to COBOL equivalent MOVE and CALL statements these resides in DBRMLIB, the other output of this step being the normal Cobol statements segregated from SQL statements, so called as Modified Source program. In this step the following activities occur,
1. Source program gets segregated to DBRM and Modified Source program.
2. The precompiler fixes the TIMESTAMP in both DBRM and Modified Source program.
3. Checks for SQL syntax.
Then this DBRM will come in to play only during BIND operation. Meanwhile the Modified Source program undergoes Normal Compilation, link-editing resulting in a load module.
Now during BIND, it does the following,
1. Checks for authorization.
2. Timestamp check.
3. DBRM are bound to packages which is inturn bound to plan ( executable form ).
Now this plan is executed to get the desired outcome.
Back to top
View user's profile Send private message
bhageeradhi

New User


Joined: 23 Apr 2005
Posts: 2

PostPosted: Tue Dec 19, 2006 3:44 pm    Post subject:
Reply with quote

Hi vicky,
Thanks for ur reply....
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 Comparision with current time arunsoods DFSORT/ICETOOL 5 Thu Nov 09, 2017 10:37 am
This topic is locked: you cannot edit posts or make replies. Comparing current time with the time ... arunsoods SYNCSORT 1 Mon Oct 30, 2017 4:07 pm
This topic is locked: you cannot edit posts or make replies. Incrementing current time field by 30... arunsoods DFSORT/ICETOOL 11 Thu Oct 26, 2017 3:22 pm
This topic is locked: you cannot edit posts or make replies. 00D3003B - time outs in DB2 when invo... chavinash2004 DB2 2 Mon Oct 09, 2017 4:39 pm
No new posts VSAM RLS Wait time blayek JCL & VSAM 2 Mon Oct 02, 2017 9:05 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us