Fixed length

reddy12 · Post by **reddy12** » Fri May 11, 2007 7:17 am

Hi all
Thanks all of you guys and DSXchange.

I need to create fixed length flat file.I am getting this error.I selected record length is fixed.how can i resolve this problem Please give me suggestion.

Sequentialfile1: Error when checking operator: "record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "ST_NAME".

Thanks
Reddy.

DSguru2B · Post by **DSguru2B** » Fri May 11, 2007 7:21 am

Why dont you start by telling us how you set up your job?
Did you provide the correct lengths of each field under the column's tab in the sequential file stage?

reddy12 · Post by **reddy12** » Fri May 11, 2007 9:10 am

I am creating a flat file(Target).my data is like below.Like this the job is working.
"aaa","bbbb","2005-01-01 00:00:00"," ","2005-03-03 00:00:00"

But I need fixed length and without quotes and comma.
Ex:
aaa bbbb 2005-01-01 00:00:00 2005-03-03 00:00:00

I removed comma and quotes in properties of sequential file but my data is coming like below.i need spaces betwen the fields

aaabbbb2005-01-01 00:00:00 2005-03-03 00:00:00

DSguru2B wrote:Why dont you start by telling us how you set up your job?
Did you provide the correct lengths of each field under the column's tab in the sequential file stage?

reddy12 · Post by **reddy12** » Fri May 11, 2007 9:12 am

I am creating a flat file(Target).my data is like below.Like this the job is working.
"aaa","bbbb","2005-01-01 00:00:00"," ","2005-03-03 00:00:00"

But I need fixed length and without quotes and comma.
Ex:
aaa bbbb 2005-01-01 00:00:00 2005-03-03 00:00:00

I removed comma and quotes in properties of sequential file but my data is coming like below.i need spaces betwen the fields

aaabbbb2005-01-01 00:00:00 2005-03-03 00:00:00

DSguru2B wrote:Why dont you start by telling us how you set up your job?
Did you provide the correct lengths of each field under the column's tab in the sequential file stage?

[/quote]

pradeepleon · Post by **pradeepleon** » Fri May 11, 2007 9:26 am

You need to set a delimiter.....check on that part.

DSguru2B · Post by **DSguru2B** » Fri May 11, 2007 9:33 am

Read the sequential file as a delimited file and then load it to a fixed width file. This will be much better than manually going in and removing the delimiters.