Joined: 25 Jan 2004 Posts: 160 Location: Toronto, Canada
I have a exsisting DB2 table...
1. What do I need to do to the add new columns to the table
2. Do I need to compile the program which are already using this tables after I add new cloumns to the tables.
3. Is there a good document which explains step by step executing of DB2 code.
first step is to identify the list of programs where the impacted DB2 table
Second is to analyse what kind of DDL statements used in each of the
program and create a report of it.
If the new filed, is not going to be a part of Index, then Delete/Update
statements will not be affected.
Insert/Select will be impacted based on the usage of the filed
Take an image copy of the table.
Drop the table
Create a new table defination
Load the table from the previous image copy /* here the format differs
so you may use one time program to load this, otherwise you can chagne the syspunch and load*/
now you need to modify the impacted program.
Compile, link-edit and bind all the programs where the table is used.
let me know if you require any additional information.
1.What do I need to do to the add new columns to the table ?
u can use the ALTER command for the above query
2.Do I need to compile the program which are already using this tables after I add new cloumns to the tables?
Yes u had made some changes na then its a good thing to compile it such that if any thing goes error it may be catched previously.
3.Is there a good document which explains step by step executing of DB2 code?
there are plenty of documentation available for DB2 but i dont know what does the step by step executiion u are meaning here.