Complex Flat File Stage(DS 7.5) - Decimal data types
Posted: Fri Jan 13, 2006 10:36 am
Hi,
I'm getting a some error while reading decimal data in CFF stage. Here is an example:
Column=Salary Decimal (5,2) Sign on Trailing
Currently this column is configured as
Cobol layout= PIC S9(3)V9(2) Sign is trailing
Record type= Variable
Data format= text
Character Set= ASCII
1)
Input data= 9875}
Expected output= -987.50
2)
Input data= 1234I
Expected output= 123.49
Issue: CFF stage is unable convert the last character. FYI, I'm able to read the same data using Seqiential file stage. Why not CFF?
Error: Field "Salary" has import error and no default value;
data: {9 8 7 5 7d}
Am I missing anything?
I would appreciate your help.
Thanks..!
I'm getting a some error while reading decimal data in CFF stage. Here is an example:
Column=Salary Decimal (5,2) Sign on Trailing
Currently this column is configured as
Cobol layout= PIC S9(3)V9(2) Sign is trailing
Record type= Variable
Data format= text
Character Set= ASCII
1)
Input data= 9875}
Expected output= -987.50
2)
Input data= 1234I
Expected output= 123.49
Issue: CFF stage is unable convert the last character. FYI, I'm able to read the same data using Seqiential file stage. Why not CFF?
Error: Field "Salary" has import error and no default value;
data: {9 8 7 5 7d}
Am I missing anything?
I would appreciate your help.
Thanks..!