If a new column is added to the table



IBM's flagship relational database management system

If a new column is added to the table

Postby pradeepgowda » Wed Jan 27, 2010 11:36 am

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
pradeepgowda
 
Posts: 40
Joined: Mon Jan 04, 2010 4:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: please help me out..

Postby dick scherrer » Wed Jan 27, 2010 12:04 pm

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.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post