DSXchange

Hi all ,
I use a sequential stage between to active transformer stage and i was asked to change the contains terminators of all columns to yesin the input stage and in the output stage also all the columns contain terminators are changed to yes but fr the last column.And if i keep the last column contains terminators as yes i get the following error
"COLUMN CANNOT CONTAIN A NON QUOTED CHARACTER BECAUSE IT IS THE LAST COULMN OF A DELIMITED SEQUENTIAL FILE"

what is role of the contains terminators in the sequential file

DataStage uses the terminator to find the end of the line/record. If a terminator is found in any but the last column it will know that it is part of the data. But the last column cannot contain a terminator in addition to the "real" terminator because DataStage has no way of determing what type it is - the first one it comes across while parsing the last column must be the line terminator.

parvathi wrote: what is role of the contains terminators in the sequential file

By checking on the "contains terminator", you direct datastage to ignore any terminator which comes in a record. So you can ignore a termination character in a varchar 200 field.

otherwise, datastage will read that terminator and will try to put the data after the terminator in a new row.

As ArndW said, you cannot tell datastage that my last column may contain a terminator because it is supposed to contain one. if you have that varchar 200 as your last field, there are other ways to eliminate it.

As ArndW said, you cannot tell datastage that my last column may contain a terminator because it is supposed to contain one. if you have that varchar 200 as your last field, there are other ways to eliminate it.[/quote]

yes in this case my last column contains terminators and how should i proceed in this way because if my last column contains terminators then the vlaue will be put in the new record. and i don't want that to happen

What is the terminating character used in the file

Regards
Sreeni

if I am correct the delimiter and terminator are one and the same

the delimiter that I have specified is 001(start of heading)

parvathi wrote:if I am correct the delimiter and terminator are one and the same

the delimiter that I have specified is 001(start of heading)

A delimiter cannot be the same as the terminator.

HI

I also could not understand that the terminator is same as delimited.
Its 001. Can you send a sample data.

Regards
Sreeni