DSXchange

Hello Everyone,

I have a text file being created using the DB2 export utility in which there is a description field where few records have Line Feed's in it. This file is to be loaded into TeraData Database.

Now the question is:

1. Can we read a text file into DataStage with Sequential file stage with Line Feeds (<LF>)? If not, do we have any alternative in DataStage?

Note: Requirement is to carry Line Feeds (<LF>) in those description fields. Converting the Line Feeds into spaces and load into the TeraData is not permissible.

Thanks

Presumably the export utility has quoted these strings. In the Columns grid (and I note that this is a server job, even though posted in the Enterprise Edition forum) you can mark the column(s) in question "contains line termintors" in the Sequential File stage and everything will be taken care of automatically.