Roy has tried to write the Fold() or Fmt() function, which already exist as intrinsic DataStage BASIC functions to do exactly what you ask.
Use this design.
Code: Select all
source -----> Transformer -----> SeqFile -----> (more)
Read one column from source.
In the Transformer stage apply the Fold() function, then convert field marks to column separator characters.
Convert(@FM, "|", Fold(InLink.SourceCol, 100))
or
Convert(@TM, "|", Fmt(InLink.SourceCol, "100L"))
Write one column to the Sequential File stage, with 000 as the delimiter character, and 000 as the quote character.
Read from the Sequential File stage using "|" as the delimiter character.