VSAM to DB2 conversion - COBOL

1
votes

I'm trying to convert a vsam file to db2 table using load utility. However, one of my variables is pic s9(8)v99. When i try to load it into a column decimal(10,2) an error occurs - 02 invalid input numeric. Can you please help?

1
db2cobolvsam
What is the usage, i.e., COMP-3, DISPLAY, something else... - zarchasmpgmr
Full message including any codes. Full JCL and control cards. Values for record failing, especially this field. Probably bad data. - Bill Woodger
Usage is DISPLAY. - Ana S.
This is an example of the number in a dump of the file VSAM: 000004909รจ - Ana S.
In your LOAD statement, you may need to specify that field as DECIMAL ZONED (signed USAGE DISPLAY), as I see the presence of a sign in the last digit. If that works, please reply and I will create an answer for acceptance. - zarchasmpgmr

1 Answers

1
votes

s9(8)v99 represents a signed variable to me. You may have to use char or varchar to store exact value with sign or try to absolute value.