DB2 Binding and Precompilation

swetha_smile · New User Joined: 23 Aug 2006 Posts: 3

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.

venkatm99 · New User Joined: 01 Jun 2006 Posts: 23 Location: Sinagpore

hi

Read the documnet. It will clear all ur doubts.

cheers

venkat

neelesht · Posted: Thu Aug 24, 2006 3:07 pm

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