Page 1 of 1

Increasing Data Field from Past File Layout Database File

PostPosted: Wed Dec 16, 2009 4:41 am
by crazycobol
Hi again guys. I have an issue that maybe you can help me with.

I have a program that was written a few years ago. In that program, the varible has been declared to be PIC 99v99. The file layout in the File Section that creates the database is PIC 99v99. I need to increase one of the data field from PIC 99V99 to PIC 99V999. When I changed it to PIC 99V999, I got a program error 39 which is file is not compatible because of the increase field, the file layout has been changed.

Obvisouly I have to change the database file to reflect the increase in that field. How do I go about doing that? any suggestion is greatly appreciated.

Re: Increasing Data Field from Past File Layout Database File

PostPosted: Wed Dec 16, 2009 8:58 am
by dick scherrer
Hello,

Suggest you talk with the dba - they are most often the ones who make database definition changes.

The 39 does not sound like a database problem. . . This sounds like a problem due to the file definition and the actual file being different. . .

Re: Increasing Data Field from Past File Layout Database File

PostPosted: Wed Dec 16, 2009 11:23 pm
by crazycobol
dba? database administrator?

i don't have a database administrator in-house.

Re: Increasing Data Field from Past File Layout Database File

PostPosted: Thu Dec 17, 2009 1:09 am
by dick scherrer
Hello,

If the database changed, Someone changed the database structure. . . Who was it?

Possibly you are simply mis-using terms. . .
The file layout in the File Section that creates the database is PIC 99v99.
Which database are you using that has entries in the File Section?

If you changed a non-database file, why did you change it? If you changed this one place, why did you not change it everywhere?

Until you more clearly describe what is going on, it will be difficult to offer suggestions.