BLOB text from SQL server
Posted: Wed Jun 21, 2017 8:34 pm
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.
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.