BLOB text from SQL server

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
swathi.raoetr
Participant
Posts: 22
Joined: Tue May 09, 2017 8:46 am

BLOB text from SQL server

Post by swathi.raoetr »

Hello,

We are reading some text fields from SQL server. I have tried a direct replacement of char(10), char(13) in the read select query. This query works in sql server.
However while the datstage process runs successfully, the /n and tab replacements are not happening. The extract files have the record split into multiple lines. A filter applied on the query works, but not the char(10), char(13 ) replacements.
Post Reply