DSXchange

I have used CFF in a server job to extract multiformat (copybook) data and loaded in sequential files with FIELD DELIMETER as COMMA.
and its defined as in copybook:
10 ACT-ANNUALAMT PIC S9(9)V99 COMP-3.

When i edit column properties its PACKED property is set to YES.

following Import warning is comming:
Field "ACT_ANNUALAMT" delimiter not seen, at offset: 86

How do you define the field itself?

Decimal 11,2

I have used CFF in a server job to extract multiformat (copybook) data and loaded in sequential files with FIELD DELIMETER as COMMA.

Its defined as follows in copybook:
10 ACT-ANNUALAMT PIC S9(9)V99 COMP-3.

in sequential file its defined as:
Decimal 11,2

I can see the data is loaded properly in server sequential file. Now i have to use this sequential file in PX job and when i extract the same server file in Px job. i get the following error on import.

following Import warning is comming:
Field "ACT_ANNUALAMT" delimiter not seen, at offset: 86

Any help on this problem.

Since your source datatype is signed, you may need to specify that in your column definition. It is a suboption under packed.

Brad.