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
 

 

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 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
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 Sun Nov 06, 2016 8:11 pm


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