Problem in Reading the fixed width files in Parallel jobs

kondeti · Post by **kondeti** » Tue Apr 25, 2006 5:41 am

Hi

Plz tell me how can we read the fixed width files in Parallel jobs. In server jobs fixed width option is available in sequential file. Is there any option available Parallel jobs. I am already done some R&D I didn't find that option plz help I am new to parallel jobs is there any alternative.

Regards
Shiva.Kondeti

ArndW · Post by **ArndW** » Tue Apr 25, 2006 5:45 am

Parallel job sequential file stages can handle fixed width files in much the same was as server jobs do. They are much more sensitive to data types and column defaults than server jobs but once you have a sequential file input set up correctly it does run very quickly.

What, specifically, is/are your problem(S) with reading fixed width files? Start off with a simple dummy file with just one CHAR(16) column and see if you can declare and read that correctly, and then you can work towards setting up your real sequential file read (which is doubtlessly muh more complicated).

bandish · Post by **bandish** » Tue Apr 25, 2006 5:55 am

Hi,

U can find the Fixed_Width option:

In Format tab, Right click Record Level --> Format as --> Fixed Width Record.

Thanks
Bandish

kondeti · Post by **kondeti** » Tue Apr 25, 2006 11:09 pm

I got result. Thank you

ray.wurlod · Post by **ray.wurlod** » Wed Apr 26, 2006 3:28 pm

There are five environment variables that can affect the efficiency with which fixed width records can be propagated between player processes; these are the so-called "transport block" variables. Read about them in the Parallel Job Advanced Developer's Guide, Chapter 6.