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

Impact of adding a column in an existing table


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

New User


Joined: 25 Aug 2008
Posts: 14
Location: india

PostPosted: Tue Dec 23, 2008 8:22 pm
Reply with quote

Could anyone please tell me what will happen and what risk analysis we need to do if we want to add a column in an existing table in the database?
Back to top
View user's profile Send private message
ashimer

Active Member


Joined: 13 Feb 2004
Posts: 551
Location: Bangalore

PostPosted: Tue Dec 23, 2008 9:59 pm
Reply with quote

Check programs using the table for full select inserts , select * in cursors etc ...
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Dec 23, 2008 11:27 pm
Reply with quote

Hello,

Check any backup/restore/recovery processes.
Back to top
View user's profile Send private message
rajesh_mbt

New User


Joined: 27 Mar 2006
Posts: 97
Location: India

PostPosted: Wed Dec 24, 2008 10:42 am
Reply with quote

1) Generate new DCLGEN for the amended table if requires
2) Check for Bulk insert(From select statements)
3) Cursor declaration Fetch into variables need to be considered
Back to top
View user's profile Send private message
gauravd01

New User


Joined: 25 Aug 2008
Posts: 14
Location: india

PostPosted: Wed Dec 24, 2008 4:17 pm
Reply with quote

Thanks for replying my questions answer......but what else we need to do on DB2 front?
Back to top
View user's profile Send private message
gauravd01

New User


Joined: 25 Aug 2008
Posts: 14
Location: india

PostPosted: Wed Dec 24, 2008 4:19 pm
Reply with quote

rajesh_mbt wrote:
1) Generate new DCLGEN for the amended table if requires
2) Check for Bulk insert(From select statements)
3) Cursor declaration Fetch into variables need to be considered
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 How to load to DB2 with column level ... DB2 6
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
No new posts RC query -Time column CA Products 3
Search our Forums:

Back to Top