Got a new project working to receive a XML from a vendor that needed to parse into 2 databases. I tried using the new feature (Annotation Decomposition) available in DB2 V7.1 but ran into a problem. Here's the detail:
1. I modified the XSD from our vendor by adding the required annotation with db2 namespace and the necessary rowset and column definitions.
2. Registered the XSD sucessfully (with XSR_REGISTER and XSR_COMPLETE) in an interactive SQL session.
3. When trying to decompose a test file using [CALL SYSPROC/XDBDECOMPXML ('TESTF', 'BOODRREQ',GET_XML_FILE('/Vendor/In/OrderFulFillmentRequest.xml'), null)] in the interactive session, I ran into an error.
The error says: Trigger program or external routine detected an error.
The log says:
>> strsql
JVM properties were loaded from a properties file.
Java Virtual Machine is IBM Technology for Java. PID(51296)
JVM properties were loaded from a properties file.
SQLDA or descriptor area not valid.
Error occurred during decomposition of XML document *N.
The nested transaction operation failed. Reason code 1.
Trigger program or external routine detected an error.
Can somebody help me to find out what is causing this problem?
Thanks!
1. I modified the XSD from our vendor by adding the required annotation with db2 namespace and the necessary rowset and column definitions.
2. Registered the XSD sucessfully (with XSR_REGISTER and XSR_COMPLETE) in an interactive SQL session.
3. When trying to decompose a test file using [CALL SYSPROC/XDBDECOMPXML ('TESTF', 'BOODRREQ',GET_XML_FILE('/Vendor/In/OrderFulFillmentRequest.xml'), null)] in the interactive session, I ran into an error.
The error says: Trigger program or external routine detected an error.
The log says:
>> strsql
JVM properties were loaded from a properties file.
Java Virtual Machine is IBM Technology for Java. PID(51296)
JVM properties were loaded from a properties file.
SQLDA or descriptor area not valid.
Error occurred during decomposition of XML document *N.
The nested transaction operation failed. Reason code 1.
Trigger program or external routine detected an error.
Can somebody help me to find out what is causing this problem?
Thanks!
Comment