complex falt file (CFF)

donny · Post by **donny** » Wed Oct 04, 2006 10:14 am

Hi
iamtrying to use a Complex file in parallel job, when i try to view data in designer, i dont see the correct data in correct columns,some of the data is overlapped onto other columns,i mean when i have a filler i see data in filler coulmn also,even the first column doesnt show correct data

any help is appreciated

thanks
donny

meena · Post by **meena** » Wed Oct 04, 2006 10:21 am

Hi,
You need to set the length of the columns properly. You have to play with it till you are able to view the data in correct format.

Kirtikumar · Post by **Kirtikumar** » Thu Oct 05, 2006 12:22 am

If this complex flat file is created by some mainframe or AS400, then see whats the copy book format specified and see if there is any diff between what you are using and what is there in copy book.

Normally, when everything is matching from Copy book with the complex flat file definition, the decimal columns with scale need to be handled properly. Also sign bytes for the numeric cols create problems if not handled.

kumar_s · Post by **kumar_s** » Thu Oct 05, 2006 7:44 am

Just one byte shift in the layout will give you a ladder effect of the whole file with the fixed widthformat. You can start the check from the filler to check if the data in the column before to the filler column are populated corectly. If so you can add or remove one or two byes from filler as a trail and error approach.