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

Adding a column in the table


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

New User


Joined: 16 Dec 2004
Posts: 44
Location: Hyderabad

PostPosted: Fri Jan 20, 2006 2:30 am
Reply with quote

Hi,

I have a table which contains three columns as below.

EMPID, EMPNAME, SAL. I made use of these columns in COBOL-DB2 program.

Now I added one more column to this table called EMPAGE.

I am not going to use this particular column in the COBOL-DB2 program. Do I require to make any changes to the existing COBOL-DB2 program or can I directly run the program as it is?

Thank you,
Brahma
Back to top
View user's profile Send private message
Lkmi

New User


Joined: 04 Mar 2005
Posts: 53
Location: Newyork

PostPosted: Fri Jan 20, 2006 3:28 am
Reply with quote

you can run the program as it as aslong as you dont use the field in the program
Back to top
View user's profile Send private message
prabs2006

Active User


Joined: 12 Jan 2006
Posts: 103

PostPosted: Fri Jan 20, 2006 10:58 am
Reply with quote

Hi,
No changes need to be done in the program, if u r not going to use that column, but DCLGEN has to be regenerated and the program needs to be compiled and bound.

Thanks & Regards
Prabs
Back to top
View user's profile Send private message
brahmanandareddy

New User


Joined: 16 Dec 2004
Posts: 44
Location: Hyderabad

PostPosted: Fri Jan 27, 2006 11:23 pm
Reply with quote

Hi,

Thanx everybody for your replies.

I was asked this question by a tech guy and I answered the same thing as we need not to change the program, but he said 'when I am trying to run the same program without any changes I am getting it abended. Why?'

Can anybody please explain me.

Thank you,
Brahma
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Sun Jan 29, 2006 4:40 pm
Reply with quote

Hi bramha,
Here I need some info ..how did you added new column to the table? through ALTER statement or through DROP and recreate?

Because if its properties are NOT NULL WITH DEFAULT then you won't get any problems while running. But you have to rebind the package/plan because it will go into invalid state.

If its properties are not NOT NULL WITH DEFAULT and the program is trying insert a row in that table,then rebind will fail and program also fails.


Hope you understand..

Thanks,
Rags
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