fixed widht file problem

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

fixed widht file problem

Post by dsdev_123 »

Hello
I have a job reading the data from dataset and dumping it into a fixed widht sequential file (Dataset -----fixed width file). All columns in the dataset have been defined as VARCHAR and when i run the job and when i try to view the data out of fixed widht seq file. i was able to view the data of only the first column and some of the other columns data in the first column. I have given

Record level
final delimiter:end
field defaults
delimiter:none
quote:none

any help would be really appreciated.

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Insert a Copy, Modify or Transformer stage to convert the VarChar field(s) to Char for fixed-width. Include $APT_STRING_PADCHAR environment variable as a job parameter with its default value set to space if you need padding with space rather than 0x00.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply