Writing Fixed width File

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
iwin
Premium Member
Premium Member
Posts: 99
Joined: Mon Apr 11, 2005 9:20 pm

Writing Fixed width File

Post by iwin »

Hi,
I am writing 2 columns(length 40 each) which are defined as varchar in source to a fixed width sequential file. In the transformer i have set the datatype for the target columns to be char and in the sequential file stage format properties i have set record length to fixed and column extended properties i have set the pad char is space and field width to 40.
But still i get the following error:
Sequential_File_53: Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "cust_name".
Any suggestion plz.
Thanks.
Every person you meet knows something you don't, Learn from them.
-- H. Jackson Brown
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Change the Display Width as well as the Char precision to 40.
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