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
Warnings : 1

Senior Member


Joined: 07 Feb 2009
Posts: 1266
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 Adding a header when change data DFSORT/ICETOOL 6
No new posts A command to change LRECL of an exist... JCL & VSAM 7
No new posts How to add new LPARs and change exist... All Other Mainframe Topics 0
No new posts row change timestamp DB2 3
No new posts Cannot change DATACLAS on DFSMSdss re... JCL & VSAM 11
Search our Forums:

Back to Top