Hi there
I get the folowing message when reading a Complex File
cff_BLUSOCD,0: Field "SERSID" has import error and no default value; data: {f0 f0 f9 f3 f0 f7 f0 f1 f4 f9 @}, at offset: 9
The field (SERSID) is a numeric field (Decimal) and it doesn't have a default value ...not sure what default value I can specify...
Thanks for your assistance
Error when reading data from a Complex File
Moderators: chulett, rschirm, roy
How is SERSID defined in the input stage?
Based on the data shown, either:
- the length is incorrect (SERSID is 11 bytes, data is 10)
- the offset is incorrect (maybe an earlier field is defined incorrectly)
- you have SERSID defined incorrectly (maybe should be a trailing sign)
- the data is just fubar in this record (this 11 byte field ends with an EBCDIC space character - x'40' - instead of a digit)
Your default value would be based on your column's datatype and, most importantly, the business rules. As SERSID is a decimal, the default value will need to be some sort of number. The actual value to use will depend upon the business rules defined by your customer. If that's not specified then you should inquire.
Regards,
Based on the data shown, either:
- the length is incorrect (SERSID is 11 bytes, data is 10)
- the offset is incorrect (maybe an earlier field is defined incorrectly)
- you have SERSID defined incorrectly (maybe should be a trailing sign)
- the data is just fubar in this record (this 11 byte field ends with an EBCDIC space character - x'40' - instead of a digit)
Your default value would be based on your column's datatype and, most importantly, the business rules. As SERSID is a decimal, the default value will need to be some sort of number. The actual value to use will depend upon the business rules defined by your customer. If that's not specified then you should inquire.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
If I remember correctly, you can set that default by editing the extended metadata for that column. To do that you select the column (like in the input definition) and hit Ctrl-E.
-However- you should really address WHY the column metadata isn't matching what is in the file so you don't need the default.
-However- you should really address WHY the column metadata isn't matching what is in the file so you don't need the default.