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
fixed widht file problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.