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
WHAT IS THE USE OF CONTAINS TERMINATORS IN SEQUENTIAL STAGE
Moderators: chulett, rschirm, roy
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
Re: WHAT IS THE USE OF CONTAINS TERMINATORS IN SEQUENTIAL ST
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.parvathi wrote: what is role of the contains terminators in the sequential file
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.
Re: WHAT IS THE USE OF CONTAINS TERMINATORS IN SEQUENTIAL ST
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
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
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
A delimiter cannot be the same as the terminator.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)
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am