explicit decimal point in CFF
Posted: Thu Oct 23, 2008 9:41 am
I am using a CFF stage to read a binary file taken from a mainframe platform.
The problem I have is that some fields contain numeric values with an explicit decimal point and I am unable to find a way to read the values correctly.
Using Fileaid to read the original mainframe dataset I can specify PIC +9(4).9(2). but if i try and import this to datastage it gives an error and seems to only accept PIC S9(4)V9(2) which means an implied decimal point.
Can someone please tell me if/how data in this format can be read directly or if I need to find a workaround to remove the decimal point or read the data in two parts.
Thanks
The problem I have is that some fields contain numeric values with an explicit decimal point and I am unable to find a way to read the values correctly.
Using Fileaid to read the original mainframe dataset I can specify PIC +9(4).9(2). but if i try and import this to datastage it gives an error and seems to only accept PIC S9(4)V9(2) which means an implied decimal point.
Can someone please tell me if/how data in this format can be read directly or if I need to find a workaround to remove the decimal point or read the data in two parts.
Thanks