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
 
DB2 Binding and Precompilation

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

New User


Joined: 23 Aug 2006
Posts: 3

PostPosted: Thu Aug 24, 2006 12:20 pm    Post subject: DB2 Binding and Precompilation
Reply with quote

Hi,

Can you please explain me the following:

1.How DB2 precompilation takes place?.

2.Whats the difference between this compilation and compiling JDBC programs.

3.Whats the diffrence between INCLUDE and COPY

Thank you for help in advance.
Back to top
View user's profile Send private message

venkatm99

New User


Joined: 01 Jun 2006
Posts: 23
Location: Sinagpore

PostPosted: Thu Aug 24, 2006 1:17 pm    Post subject: Re: DB2 Binding and Precompilation
Reply with quote

hi

Read the documnet. It will clear all ur doubts.

cheers

venkat
Back to top
View user's profile Send private message
neelesht

New User


Joined: 24 Jul 2006
Posts: 99
Location: Los Angeles

PostPosted: Thu Aug 24, 2006 3:07 pm    Post subject:
Reply with quote

Swetha,

The doc above is the best one for understanding Precompiler, Plan, Package and DBRM concept.
Thanks Venkat !

Diff between Include and Copy :
The one diff that i know is Include will be expanded at precompilation time itself.
So the variables in include can be used in the where caluse of SQL while the variable in COPY will say undefined host variable.

Please correct me if I am wrong.
If there are any other differences please let us know.

Thanks,
Neelesh
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 -419 SQL error when binding senthamizh DB2 2 Sun Jun 12, 2016 8:20 pm
No new posts Precompilation problem trushant.w DB2 19 Thu Oct 10, 2013 4:48 pm
No new posts difference between Static and Dynamic... dbzTHEdinosauer Mainframe Interview Questions 7 Tue Jun 28, 2011 7:46 pm
No new posts Question on binding after index creation GuyC DB2 4 Fri Apr 15, 2011 8:19 am
No new posts Problem during precompilation step GaganGarg All Other Mainframe Topics 7 Fri Feb 11, 2011 3:36 pm

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