Complex flat file

[naidu]

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"

[chulett]

Why did you post this again?

viewtopic.php?p=343844

[naidu]

Hi Craig Hulett
I still didn't get any solution for my error and i want to explain my error clearly and more over i am new to this forum so posted it again.

[chulett]

OK... please don't. Do your clearer explanations in your existing post.

[chvenkat.v]

And make this topic as resolved... Smile