Skip to Content
0
Former Member
Aug 19, 2013 at 06:55 PM

Data Integrator & SYBASE IQ Issue - Lading row with column having column de-limiter as data

28 Views

How to load row in Sybase IQ using Data Integrator with column having column de-limiter as data as default escaping character “\” doesn’t work

For example I am replacing column data using “replace_substr” in transformation like following ways replace_substr(ColumnOriginalValue,’`’,’``’)

replace_substr(ColumnOriginalValue,’`’,’\`’)

But in both case I am getting following error

SQL submitted to ODBC data source <id00> resulted in error <[Sybase][ODBC Driver][Sybase IQ]Missing row delimiter detected