Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 Loading data to table gives wrong for... Raghu navaikulam DB2 18 Thu Jul 13, 2017 2:11 pm
No new posts unload data from table with lob columns farhad_evan DB2 1 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us