ssis - Interpreting COMP-3 Packed Decimal Fields into numeric values -
I am creating an SSIS package to read in unpacked data from a series of copybook files. I am unsure of the correct interpretation and hoped that anyone would know:
FIELD-NAME-1 PIC S9 (15) V9 (3) COMP-3
FIELD-NAME-2 PIC S9 (3) V9 (8) Compute -3
field- NAME-3 photo S9 (3) V9 (6) vibrate -3
The data is stored in the fixed width. The data for the above areas is the following length:
FIELD-NAME-1: 19 FIELD-NAME-2: 11 FIELD-NAME-3: 9
How I'm Guaranteed Decimal Places To interpret and sign.
Any help would be appreciated.
Kind regards, ham
Comments
Post a Comment