Store XML in DB2 Stage in CLOBS?

[guidomarcel1]

Hi, does anybody know if (and how) Datastage can store data in DB2 CLOBS?.
We have an XML file and want to store the data "as received" in a DB2 CLOB.
We define the XML-string as SQLtype=Varchar or LongVarchar, or Char, but the only answer we get from the DB2 stage is "invalid conversion".

I would apreciate any help

REgards
Guido

[ogmios]

Guido.

Look at the following threads:

Code: Select all

http://www.dsxchange.com/viewtopic.php?t=85810
http://www.dsxchange.com/viewtopic.php?t=83754

Apparantly some people have managed to get it working (I never did ), but what would be the point in doing this via DataStage. I needed it once: then I stored the CLOBs seperately and created at the same time a file of per row the key and "CLOB identifier". Only the latter file was processed via DataStage.

Also on a DB2 level your database needs to have DB2 XML extender installed and have special CLOB tablespaces defined.

Ogmios