Writing Fixed width File
Posted: Tue Aug 05, 2008 10:40 am
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:
Thanks.
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:
Any suggestion plz.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".
Thanks.