Page 1 of 1
Inserting into XML type columns on AIX DB2
Posted: Wed Feb 24, 2010 5:34 am
by 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.
Posted: Wed Feb 24, 2010 6:33 am
by 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
Posted: Wed Feb 24, 2010 6:45 am
by LaLex
Thank you Ernie, I'll try to find it there.
Re: Inserting into XML type columns on AIX DB2
Posted: Thu Feb 25, 2010 12:06 am
by MT
Hi,
LaLex wrote: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