Page 1 of 1

If a new column is added to the table

PostPosted: Wed Jan 27, 2010 11:36 am
by pradeepgowda
hi,

1)if a new column is added to the table which is being referenced in cobol-db2 program . what should be done?
ie
a) whether we have to recomplile and rebind the application plan
b) whether binding an application package is enough

or anything else we should make in order to successfully run a cobol-db2 program

2) if cobol changes are done in cobol-db2 program. what is the compilation procedure.

ie a) whther the precompilation,compilation,appliction bind are required..

anything else we should make in order to successfully run a cobol-db2 program

Re: please help me out..

PostPosted: Wed Jan 27, 2010 12:04 pm
by dick scherrer
Hello,

Next time use something meaningful for the subject. . . :(

Unless these are interview questions (in which case this will be moved to the Interview Questions part of the forum), developers should ask their system and/or database support people for the proper jcl for compiling any program (whether it has db2 or not).

Compile procedures are standard for a system and only the standard procedures should be used. Developers should not create their own.

As these are entirely site-specific, only someone familiar with your environment will know the answers.