DSXchange

I have trying to define a fixed width (length 89) file (each line terminated by DOS line) with the following options :

Record delimiter string = DOS format
Record length = fixed
Final delimiter = end

Field delimiter = none
Field Quote = none

I am getting the following error while trying to view data in a Sequential file.

"record_length=fixed" (no length given) and record field format is variable-length. The first variable-length field is "BILL_TYPE".

Please let me know where to set the field format as fixed.

Thanks

I tried with the following :

Record delimiter string = \r\n
Record length = fixed
Final delimiter = none

Field delimiter = none

Then I get the following error :

Bad record delimiter after fixed-length record: expected "\r\n", got " \n"

Please advise.

Looks like a UNIX linefeed delimiter rather than DOS style CR/LF pairs.

What is the data type of "BILL_TYPE"?

Mike

You might need to redefine your fields as CHAR of fixed width.

You might need to redefine your fields as CHAR of fixed width.

All the fields are CHAR fields only.

Please tell me onething.I have my original Table definition (in the Table Definition\Sequential folder) different than this.Once I load the definition into the Sequential File stage I am making those modification.So, do I need to change the original Table definition with those.

I think you have not mentioned the field length along with the data type as CHAR. For fixed width file, you have to qoute the field length along with data type as CHAR.
I believe the warning is not because of the original table definition.

The field lengths are all there in the definition.BILL_TYPE is of CHAR(4).Similarly I have all other CHAR fields with some lengths.

You said you are trying to view the data in a sequential file. Can you please let us know whether the file was created by datastage or manually?

The file was created by some Legacy system and ftped to Datastage server.

Have you imported the metadata (table definition) for this file into DataStage so that you can specify the column widths and the fact that it is a fixed width file from the outset?

Please provide sample data.