Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
What do I need to do to the add new columns to the table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
amitraja

New User


Joined: 13 Jan 2004
Posts: 11

PostPosted: Sat Oct 30, 2004 2:40 am    Post subject: What do I need to do to the add new columns to the table
Reply with quote

HI,

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.

Thanx
Ami
Back to top
View user's profile Send private message

jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Sat Nov 13, 2004 1:02 am    Post subject: Re: DCLGEN
Reply with quote

amitraja wrote:
HI,

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.

Thanx
Ami


==============================
Hi,

first step is to identify the list of programs where the impacted DB2 table
is used.

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.
Back to top
View user's profile Send private message
khamarutheen

Active Member


Joined: 23 Aug 2005
Posts: 680
Location: NJ

PostPosted: Tue Nov 15, 2005 2:49 pm    Post subject: adding new column
Reply with quote

hi frnd,
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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm
No new posts how to see when the last read access ... Mike 1304 DB2 1 Tue Sep 12, 2017 7:52 pm
No new posts PC (UTF-8) -> z/OS (EBCDIC) -> ... prino All Other Mainframe Topics 4 Fri Sep 01, 2017 1:47 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us