XML datatype

TasneemDhuliawala · Post by **TasneemDhuliawala** » 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.

ray.wurlod · Post by **ray.wurlod** » 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.

chulett · Post by **chulett** » 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?

TasneemDhuliawala · Post by **TasneemDhuliawala** » 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..