Search found 2 matches

by ashish_moni86
Mon Jun 18, 2018 2:20 pm
Forum: General
Topic: Read xml datatype sql server, ODBC connector from datastage
Replies: 5
Views: 4797

If it does not what is the other way to achieve this? I want to read xml datatype column from sql server database table, parse it and load in netezza table. While reading as varchar or other similar datatypes I am getting error "ODBC_Connector_19,0: terminate called after throwing an instance o...
by ashish_moni86
Mon Jun 18, 2018 10:21 am
Forum: General
Topic: Read xml datatype sql server, ODBC connector from datastage
Replies: 5
Views: 4797

Read xml datatype sql server, ODBC connector from datastage

I am trying to read xml datatype in one column of Microsoft sql server using ODBC connector from datastage. Can anyone suggest me steps to do it like datatype, query, settings etc.