DSXchange

Posted: **Wed Mar 28, 2007 4:47 am**

Hi guys,

I am using DB2 9.0 with data stage which supports XMl data type.

when i try to import a Db2 table definition with a column having XML datatype,in datastge,
and as datastage doesnt support XML datatype, i am not able to load the XML file as data in the Database.

Can anyone please help me a way out of it.

Posted: **Wed Mar 28, 2007 7:00 am**

Upgrade to DataStage version 8.0, where there is better integration with the DB2 version 9 data types. The XML data type is new to version 9 of DB2, so was not known about when earlier versions of DataStage appeared. Whether the new functionality extends to server jobs I am unsure.

Posted: **Wed Mar 28, 2007 7:27 am**

Is this something you can read in as a Varchar or LongVarchar and then parse afterwards with one of the XML stages?

Posted: **Wed Mar 28, 2007 11:10 pm**

Hi

@ray .. thanks for ur suggestion , but currently we wont be able to get the upgraded version ... so..

@chullett... we tried working out using varchar, but then wen have to keep the datatype of column in table also as VArchar otherwise it doesnt work, coz wid XmL as datatype , job runs but no data goes in the table. it show "empty data source " in the data viewer..