Can you suggest me good Stuff on Net for DB2 XML Extender.
I am trying to use DB2XML.dxxEnableColumn thru ODBC and I am not able to execute. I am getting errors. I am not getting any kind of Help on this. Youre Help on this would be greatly appreciated.

Initially I tried thru ODBC and it was not working then I tried to execute
thru IBM Stored Procedure Builder (Right Click On SP name and giving Inputs)

the SP DB2XML.dxxEnableColumn has got the Following Signature


I am trying to execute the Stored Procedure dxxEnableColumn from the Stored Procedure Builder (I thought I can test this from VB thru ODBC Connection once this works thru SP Builder). I am not trying how to call DXXADM because this is not an SP and eventually I can not call this from VB thru ODBC.

In the Stored Procedure DB2XML.enableXMLColumn , The First 3 Arguments are mandatory,
which are

1. Table Name,
2. Column Name (the which we have created as an XML Column in the Table Items)
3. And DAD File Location.

I have given all these 3 and trying to execute bit it is giving Output Arguments 7 and 8 like below

DB2XML.DXXENABLECOLUMN - The value(s) of the output parameters:
var7 = -119
var8 =

No clear description I am getting in Var 8 so that I can trace the Problem.

Any help would be greatly appreciated.

E-Mail : sureshkumar_munnangi@onsite.satyam.com

Thanks
Suresh

AFAIk, there is very little information on XML extenders provided by IBM and even less on the wider web ...
If you have not searched before, you can try ..

http://www-306.ibm.com/software/data...t/library.html

http://www.redbooks.ibm.com/

www7b.boulder.ibm.com/dmdd

for info

Cheers
Sathyaram

Thanks Ihave seen these. But not really helpful.