Complex flat file
Posted: Sun Oct 18, 2009 4:52 pm
Hi
We have moved all the jobs from 7.5 version to 8.1 version and when i am trying to view the data in CFF (Complex Flat File) stage it shows the following error
Error: -
<Complex_Flat_File_12> Formatted length of fields and record (0) less than declared length (164)
>##E IIS-DSEE-TOPK-00007 16:59:44(012) <PEEK_IDENT> Input dataset does not have field: "DISTRO_ORDER_NUMBER".
>##E IIS-DSEE-TOPK-00007 16:59:44(013) <PEEK_IDENT> Input dataset does not have field: "DISTRO_ENTRY_DATE".
>##E IIS-DSEE-TOPK-00007 16:59:44(014) <PEEK_IDENT> Input dataset does not have field: "DISTRO_INPUT_SOURCE".
>##E IIS-DSEE-TOPK-00007 16:59:44(015) <PEEK_IDENT> Input dataset does not have field: "DISTRO_CUSTOMER_STORE_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(016) <PEEK_IDENT> Input dataset does not have field: "DISTRO_LAWSON_CHAIN_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(017) <PEEK_IDENT> Input dataset does not have field: "DISTRO_LAWSON_STORE_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(018) <PEEK_IDENT> Input dataset does not have field: "DISTRO_CS_ITEM_CODE".
for all the fields
can any one please help me out to view the data in CFF stage coz the jobs in version 7.5 are running fine and they are in production now.
I got the production data for testing purpose so the actual data format and metadata are same.
I feel i need to change the record_length = 0 in layout now it is 164
{record_length=164, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, nofix_zero}
please can any one tell is there any way i can edit the layout of the file to change the "record_length=164 to record_length=0"
We have moved all the jobs from 7.5 version to 8.1 version and when i am trying to view the data in CFF (Complex Flat File) stage it shows the following error
Error: -
<Complex_Flat_File_12> Formatted length of fields and record (0) less than declared length (164)
>##E IIS-DSEE-TOPK-00007 16:59:44(012) <PEEK_IDENT> Input dataset does not have field: "DISTRO_ORDER_NUMBER".
>##E IIS-DSEE-TOPK-00007 16:59:44(013) <PEEK_IDENT> Input dataset does not have field: "DISTRO_ENTRY_DATE".
>##E IIS-DSEE-TOPK-00007 16:59:44(014) <PEEK_IDENT> Input dataset does not have field: "DISTRO_INPUT_SOURCE".
>##E IIS-DSEE-TOPK-00007 16:59:44(015) <PEEK_IDENT> Input dataset does not have field: "DISTRO_CUSTOMER_STORE_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(016) <PEEK_IDENT> Input dataset does not have field: "DISTRO_LAWSON_CHAIN_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(017) <PEEK_IDENT> Input dataset does not have field: "DISTRO_LAWSON_STORE_NUM".
>##E IIS-DSEE-TOPK-00007 16:59:44(018) <PEEK_IDENT> Input dataset does not have field: "DISTRO_CS_ITEM_CODE".
for all the fields
can any one please help me out to view the data in CFF stage coz the jobs in version 7.5 are running fine and they are in production now.
I got the production data for testing purpose so the actual data format and metadata are same.
I feel i need to change the record_length = 0 in layout now it is 164
{record_length=164, delim=none, quote=none, binary, ebcdic, native_endian, round=round_inf, nofix_zero}
please can any one tell is there any way i can edit the layout of the file to change the "record_length=164 to record_length=0"