Inserting into XML type columns on AIX DB2

[LaLex]

Hello,

I would like to know, how can I using datastage to insert value into XML type fields in DB2 on AIX? I don't see how to do it directly, but are there any workarounds?

Thank you in advance.

[eostic]

I haven't tried it directly myself, but do some searches on IBM Developer Works....there is an article there that talks about using XMLPack with DB2's XML capabilities. I don't have time to check right now, but I think I have a pointer to the site in my blog below, referencing a good article on xml....

Ernie

[LaLex]

Thank you Ernie, I'll try to find it there.

[MT]

Hi,

Hello,

I would like to know, how can I using datastage to insert value into XML type fields in DB2 on AIX? I don't see how to do it directly, but are there any workarounds?

Thank you in advance.

inserting works quite straight forward - even in DS 7.x - define the column as XML and set the data type (manually in DS 7) to XML.
In DS 7 the problem is to read it but inserting works so it should be the same in DS 8 while DS 8.x supports the XML datatype directly I think.

Michael