Split single row into multiple rows

[DSguru2B]

Do an ereplace of that character with char(010):char(013).

[ray.wurlod]

The text marks indicate that your column width may not be adequate, rather than separate lines (unless you are selecting from a multi-valued field, in which case you can use DataStage's "normalize on" capability).

You can override the default column width with a FMT keyword in your UniVerse query.

Before I go off exploring possibilities, what precisely are you trying to do?