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

DCLGEN change
IBM Mainframe Forums -> DB2
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
deepakdnayak

New User


Joined: 13 Aug 2010
Posts: 3
Location: bangalore
PostPosted: Tue Dec 25, 2012 1:13 am
 Reply with quote
A existing DB2 table has been changed and a new column NEW_COLUMN is being added.Would this require recompiling all the programs using the DCL copybook even if the NEW_COLUMN is not used in any of the quiries .Would the program both online and batch run normally if the programs arent compiled and arent binded.
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1315
Location: Vilnius, Lithuania
PostPosted: Tue Dec 25, 2012 2:49 am
 Reply with quote
If none of the programs uses a
Code:
SELECT *
and the new column is defined as
Code:
NOT NULL WITH DEFAULT
there is no need to recompile any of he other programs.
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 Binary File format getting change whi... All Other Mainframe Topics 7
No new posts 3270 personal communications. Can't c... TSO/ISPF 2
No new posts SELECT from data change table DB2 5
No new posts Trying to change copybook in online c... CICS 4
No new posts Change Default Scroll Setting TSO/ISPF 1
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us