Changes in a Program when adding a new column in db2 table

cooolguyin · New User Joined: 12 May 2005 Posts: 10 Location: NY

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

priya · Posted: Thu Jun 30, 2005 12:29 am

You have to add a new host variable wherever you used SELECT *

himansu · New User Joined: 22 Mar 2005 Posts: 3 Location: bangalore

what is 04w error?

paru · New User Joined: 24 Jun 2005 Posts: 9 Location: INDIA

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.

Cheers

Paru

subhash gowda · New User Joined: 02 Jun 2005 Posts: 12

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

raji · New User Joined: 11 Aug 2005 Posts: 1 Location: trichy

can u please tell me the books for db2 for cobol

Karthikt · New User Joined: 15 Aug 2005 Posts: 51

DB2 Developer Guide by Creig S Mullins is a very good book for DB2