cancel
Showing results for 
Search instead for 
Did you mean: 

Conversion error in reading data from Cobol EBCDIC file

Former Member
0 Kudos

We are getting below error when reading EBCDIC file using COBOL copybook

"Cannot convert data <--4> into type <Decimal>. Context: Column <>."

BODS version: BODS 4.2 SP3 P2

We have verified that there is no data issue.  Upon searching on this error, I found that this is a known issue in this version of BODS, however when reading from SAP Extractor. I am not sure if they are related error.

If anyone has insights, please share.

Thanks

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Akbar,

This is the same error, I got while working with cobol file. Actually, applying Binary search, I found that there was some data which was defined as 'decimal data type' but "-" was being entered into it. I changed the data type of that specific column to varchar in my cobol copybook to accommodate the "-" present in the data file.

Else you can raise it as data file issue to your client. If they cannot change the data file then you have to do the modification in your layout file as mentioned above.

Thanks,

Jaskaran

Former Member
0 Kudos

As far as i know you can extract the packed fields.

Use the formats tab under the cobol copybook to map it to flat file fields.