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,
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
No clear description I am getting in Var 8 so that I can trace the Problem.