DSXchange

Hi all,
In the output sequential stage is there any method to remove the delimiters for certain rows....

The sequential stage delimiter definitions are for the whole file. If you need to do this you are best served by creating the file without any delimiters at all and using a transform stage to put them in manually for those rows where you need them.

You might want to explain your question a little better, possilby even post an example. Which 'delimiters' are you asking about?

I have a similar pbm

The i/p looks like
BEGIN HEADER CharacterSet "CP1252"
ExportingTool "Ascential DataStage Export"
ToolVersion "4"
MDISVersion "1.0"
Date "2006-09-01"
Time "11.51.45"
ServerVersion "7.5.1"
END HEADER

i have " as my delimiter.now the o/p looks like
BEGIN HEADER""
CharacterSet "CP1252"
ExportingTool "Ascential DataStage Export"
ToolVersion "4"
MDISVersion "1.0"
Date "2006-09-01"
Time "11.51.45"
ServerVersion "7.5.1"
END HEADER""

i have to remove the delimiter that appears after the begin header and end header.

How can i change so...

Thankx

Why not declare your output to have no delimiters, then in a transform check if the line begins with "BEGIN HEADER" or "END HEADER" and perform the appropriate string function. Or keep it as 2 column, but in a transform change the text BEGIN HEADER CharacterSet "CP1252" to BEGIN HEADER "CharacterSet CP1252"

DataStage is an ETL tool. It is NOT a metadata manipulation tool. Get MetaStage if you want to play with metadata.