Sequential File Import Warning

ds2000 · Post by **ds2000** » Thu Jul 31, 2008 3:58 pm

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

bcarlson · Post by **bcarlson** » Thu Jul 31, 2008 4:29 pm

How do you define the field itself?

ds2000 · Post by **ds2000** » Thu Jul 31, 2008 9:43 pm

Decimal 11,2

ds2000 · Post by **ds2000** » Tue Aug 05, 2008 2:05 pm

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

ds2000 · Post by **ds2000** » Wed Aug 06, 2008 11:50 am

Any help on this problem.

bcarlson · Post by **bcarlson** » Wed Aug 06, 2008 2:32 pm

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

Brad.