on 01-29-2015 6:11 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.