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.
Fixed length
Moderators: chulett, rschirm, roy
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
"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?
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
"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
[/quote]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?
-
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL