Page 1 of 1

Cobol pgm accessing a db2 File

PostPosted: Thu Sep 23, 2010 11:07 pm
by vinodibm
HI,
There is a cobol pgm accessing a db2 file..that db2 file has undergone some changes & the same cobol pgm is unable to acces the db2 file after it has undergone the changes.
my question is why this cobol pgm is not able to acces the db2 file after it has undergone the change & what is the possible error?

Re: Cobol pgm accessing a db2 File

PostPosted: Thu Sep 23, 2010 11:16 pm
by Robert Sample
Terminology is critical in IT, where similar terms may mean very different things. There is no such thing as a "db2 file" for your program to access -- DB2 has tables, rows, columns, and so forth. Perhaps you can reformulate and clarify what you meant?

And if the DB2 table was changed, you DID recompile and re-bind your program AFTER the changes were done, right? If not that alone could be the source of your problem.

Re: Cobol pgm accessing a db2 File

PostPosted: Thu Sep 23, 2010 11:40 pm
by dick scherrer
Hello and welcome to the forum,

my question is why this cobol pgm is not able to acces the db2 file after it has undergone the change & what is the possible error?
Who knows. . . . Well, you know. Only you have this information. If you post the error(s) we can help resolve the problem(s).

Was there an unwanted sqlcode returned? An abend?

Posting "it didn't work" is just a waste of everyone's time.

Just curious - why does one believe that tables can be changed without doing anything with the cobol code that references these tables. . . :?

Re: Cobol pgm accessing a db2 File

PostPosted: Thu Oct 07, 2010 2:38 pm
by Atif
Try remaking the dclgen and bind pakage .