|
Regards Vern
With due regards to Booth and Steve. I will tell you what I did.
6. There was a unique set of keys on the file with a set of 4 columns.I could use DSPPFD to see the key names. We now wanted to have unique on a set of 5 keys. 7. I renamed the old file and kept in the system. 8. I created a DB2 SQL table by same name and columns. But the program wont run with return code 39 .( the open stat. was unsuccessful because a conflict was detected between a fixed file attributes and the attributes specified for that file in the program ). I think I could have run my program if I had compiled the program source once. 9. Then I went to infocenter and read material and tried to create a DDS file for making PF. 10. I compiled the PF file, inserted records in it from old file using SQL. i then compiled the program which accessed that file and yes, it now works fine.
Regards Santosh.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.