Reading Xml style segment ...but not XML

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post by ArndW »

If you always have all 3 elements, just add a tr command to the sequential stage to filter out all <lf> characters, then define your source file as having no line terminators. If the "<" character doesn't show up in the data I would use that as the column delimiter, declare 4 varchar columns (the first is always empty) and remove the header text from each string.
Post Reply