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
 

 

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 Executing OO COBOL program invoking J... Virendra Shambharkar COBOL Programming 2 Tue Jan 10, 2017 6:37 pm
No new posts Need Suggestion on COBOL program vickey_dw COBOL Programming 5 Thu Jan 05, 2017 10:55 pm
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 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 I can not compile my program PL1 V3.R... Miguel Fernandez PL/I & Assembler 13 Tue Dec 06, 2016 8:30 pm


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