View previous topic :: View next topic
|
Author |
Message |
brahmanandareddy
New User
Joined: 16 Dec 2004 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
Lkmi
New User
Joined: 04 Mar 2005 Posts: 53 Location: Newyork
|
|
|
|
you can run the program as it as aslong as you dont use the field in the program |
|
Back to top |
|
|
prabs2006
Active User
Joined: 12 Jan 2006 Posts: 103
|
|
|
|
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 |
|
|
brahmanandareddy
New User
Joined: 16 Dec 2004 Posts: 44 Location: Hyderabad
|
|
|
|
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 |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
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 |
|
|
|