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
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: 1306
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 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
No new posts Change history of vsam file. JCL & VSAM 3
Search our Forums:

Back to Top