View previous topic :: View next topic
|
Author |
Message |
gauravd01
New User
Joined: 25 Aug 2008 Posts: 14 Location: india
|
|
|
|
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 |
|
|
ashimer
Active Member
Joined: 13 Feb 2004 Posts: 551 Location: Bangalore
|
|
|
|
Check programs using the table for full select inserts , select * in cursors etc ... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Check any backup/restore/recovery processes. |
|
Back to top |
|
|
rajesh_mbt
New User
Joined: 27 Mar 2006 Posts: 97 Location: India
|
|
|
|
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 |
|
|
gauravd01
New User
Joined: 25 Aug 2008 Posts: 14 Location: india
|
|
|
|
Thanks for replying my questions answer......but what else we need to do on DB2 front? |
|
Back to top |
|
|
gauravd01
New User
Joined: 25 Aug 2008 Posts: 14 Location: india
|
|
|
|
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 |
|
|
|