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
 
Adding a column in the table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Adding a column in the table
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    Post subject:
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    Post subject:
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    Post subject:
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    Post subject:
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    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 Create procedure issues -628 when add... chandraBE DB2 1 Mon Sep 18, 2017 12:16 pm
No new posts column with count of rows within dist... ronald wouterson DB2 4 Sun Sep 17, 2017 9:48 pm

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