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.
I am not sure may be this will work.
If the field is not packed try to import as char(add decimal separator and sign bit to the length).That should work.Just use a transformer and remove the decimal point.from there it will be easy i guess.