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
 
Changes in a Program when adding a new column in db2 table

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
cooolguyin
Warnings : 1

New User


Joined: 12 May 2005
Posts: 10
Location: NY

PostPosted: Wed Jun 22, 2005 11:31 pm    Post subject: Changes in a Program when adding a new column in db2 table
Reply with quote

hi ,

here is the question i got in interview..

what the changes that has to be taken care in the pgm. and jcl while adding a new column in db2 table..


thanks
Back to top
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Thu Jun 30, 2005 12:29 am    Post subject:
Reply with quote

You have to add a new host variable wherever you used SELECT *
Back to top
View user's profile Send private message
himansu

New User


Joined: 22 Mar 2005
Posts: 3
Location: bangalore

PostPosted: Wed Jul 13, 2005 9:58 pm    Post subject:
Reply with quote

what is 04w error?
Back to top
View user's profile Send private message
paru

New User


Joined: 24 Jun 2005
Posts: 9
Location: INDIA

PostPosted: Tue Aug 09, 2005 3:50 pm    Post subject:
Reply with quote

i would like to add some obvious changes that has to be made in the application program.

Need to ALTER the existing TABLE to add the new colomn

ALTER TABLE <table_name> ADD COLOMN <colomn name>

and need to once again generate the DCL GEN host variables.This is the change for the program.As for JCL, no change i think is required.Once you compile the program and resubmit the JCL it shud work fine.



Regarding the JCL changes do not consider the answer i gave as the final one. icon_rolleyes.gif



Cheers

Paru icon_smile.gif
Back to top
View user's profile Send private message
subhash gowda
Warnings : 1

New User


Joined: 02 Jun 2005
Posts: 12

PostPosted: Tue Aug 09, 2005 4:36 pm    Post subject:
Reply with quote

if ur going to add new colum and ur using that colum in ur progarm, then u must create a new copy of dclgen member then you are using that member in ur program, in jcl you must precompile compile, link, bind a new plan and then run the program
Back to top
View user's profile Send private message
raji
Warnings : 1

New User


Joined: 11 Aug 2005
Posts: 1
Location: trichy

PostPosted: Sat Aug 13, 2005 7:39 pm    Post subject: db2 for cobol
Reply with quote

can u please tell me the books for db2 for cobol
Back to top
View user's profile Send private message
Karthikt

New User


Joined: 15 Aug 2005
Posts: 51

PostPosted: Thu Aug 18, 2005 6:03 pm    Post subject:
Reply with quote

DB2 Developer Guide by Creig S Mullins is a very good book for DB2
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 write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
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 Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm

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