reading xml datatype from sqlserver

reddy12 · Post by **reddy12** » Wed Aug 13, 2008 7:41 am

Dear Experts,

i have xml tags in a table( sqlserver).
the datatype is XML. when i imported the table definition it imports as longNvarchar in datastage and when i click viewdata, i get a error message saying datatype not supported..

how can i read xml datatype from datastage??
once i read i can parse it using xml input stage.

Appreciate any help

chulett · Post by **chulett** » Wed Aug 13, 2008 7:50 am

What happens if you change the metadata to LongVarchar?

reddy12 · Post by **reddy12** » Wed Aug 13, 2008 8:10 am

chulett,
thanks for the reply.

just rested it.
shows the same thing.

Regards

kjanes · Post by **kjanes** » Wed Aug 13, 2008 10:39 am

I have not found any references to data type "XML" in any of the database connectors. I thought the SQL Server Enterprise Connector might support the XML datatype through an OLEDB connection but it echos the same error of "datatype not supported".

I have tried most of the character data types in the ODBC and SQL Server connectors and all get the same result. I kind of expected this because I did not find any XML data type translations to DataStage data types in the docs.

Anyone have any undocumented info on this?

kjanes · Post by **kjanes** » Wed Aug 13, 2008 10:40 am

I have not found any references to data type "XML" in any of the database connectors. I thought the SQL Server Enterprise Connector might support the XML datatype through an OLEDB connection but it echos the same error of "datatype not supported".

I have tried most of the character data types in the ODBC and SQL Server connectors and all get the same result. I kind of expected this because I did not find any XML data type translations to DataStage data types in the docs.

Anyone have any undocumented info on this?