Page 1 of 1

Complex flat file

Posted: Sun Oct 18, 2009 4:52 pm
by 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"

Posted: Sun Oct 18, 2009 7:32 pm
by chulett
Why did you post this again? :?

viewtopic.php?p=343844

Posted: Mon Oct 19, 2009 7:26 am
by 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.

Posted: Mon Oct 19, 2009 7:27 am
by chulett
OK... please don't. Do your clearer explanations in your existing post.

Posted: Wed Oct 21, 2009 3:26 am
by chvenkat.v
And make this topic as resolved... Smile