IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Precompilation without table declaration


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
mainframeraja

New User


Joined: 09 Mar 2005
Posts: 6

PostPosted: Wed Apr 19, 2006 5:24 pm
Reply with quote

We can precompile the DB2 program succesfully without declaring the table.According to the theory precompile will check the syntax of the SQL statements refering the table declaration in the DECLGEN.But without that also it is precompiling successfully.Please let me explain what exactly the process of precompilation.
Back to top
View user's profile Send private message
DavidatK

Active Member


Joined: 22 Nov 2005
Posts: 700
Location: Troy, Michigan USA

PostPosted: Wed Apr 19, 2006 8:21 pm
Reply with quote

mainframeraja,

Yes, you can per compile a program without including the declgen if you do not use the cobol declgen copybook as host variables. The pre compiler will check syntax but cannot check valid columns. And the pre compiler will generate many warning messages for you for anything it cannot reconcile. Any un-reconcilable statements will cause an error in the bind.

Dave
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Multiple table unload using INZUTILB DB2 2
No new posts Check data with Exception Table DB2 0
No new posts Dynamically pass table name to a sele... DB2 2
Search our Forums:

Back to Top