View previous topic :: View next topic
|
Author |
Message |
chennai
New User
Joined: 12 Jun 2008 Posts: 26 Location: chennai
|
|
|
|
it is mentioned in the soultions as
"It not necessary to have DECLARE TABLE statement in DCLGEN. This is used by the pre-compiler to validate the table-name, view-name, column name etc., during pre-compile"
My question is
if we remove declare table statement in the dclgen and remain only host variables then how does the precompiler validate the table-name,view name...etc....
Thanks
ajay |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Precompile is a verification step before the DBRM goes for BIND.
It doesn't validate if you remove the declare table statement. |
|
Back to top |
|
|
chennai
New User
Joined: 12 Jun 2008 Posts: 26 Location: chennai
|
|
|
|
"so you mean to say if the declare is used it will validate at the time of precompilation else if we remove it will not validate...at the same time it is not mandatory to specify that...." hope my understanding is correct |
|
Back to top |
|
|
Bharath Bhat
Active User
Joined: 20 Mar 2008 Posts: 283 Location: chennai
|
|
|
|
Thats correct. |
|
Back to top |
|
|
|