Db2 Sql Error Sqlcode=-16132
Contents |
AN INVALID DOCUMENT STRUCTURE" IF COMMENT FOLLOWS XML DECLARATION Subscribe You can track all active APARs for this component. db2 sql error sqlcode 204 sqlstate 42704 APAR status Closed as program error. Error description If you have
Db2 Sql Error Sqlcode 803
to insert an XML document into a database and a comment is included after the XML declaration
Db2 Sql Error Sqlcode 104 Sqlstate 42601
in the XML document, the execution of the SQL insert statement will fail with the following error message logged: sql-source(SQLDataSource): tid(1234567): Database reported query error: SQL16132N XML document contains http://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql16132n.html an invalid document structure. SQLSTATE=2200M Local fix Remove the comment after the XML declaration, or place the comment line anywhere within the document element. Problem summary Affected are customers that pass XML as an argument to a pepared statement using dp:sql-execute - if and only if the XML contains a processing instruction or comment before the document element. http://www.ibm.com/support/docview.wss?uid=swg1IC73923 The XML from the argument will not get serialized properly, resulting in a fragment (or no text at all). This has the potenial of causing an error at the database which gets returned back to the appliance and logged. The problem happened because of serializing issues for processing instructions and comments before the document element. Problem conclusion Fix is available in 3.8.1.10 and 3.8.2.2. Temporary fix Comments APAR Information APAR numberIC73923 Reported component nameDATAPOWER Reported component IDDP1234567 Reported release381 StatusCLOSED PER PENoPE HIPERNoHIPER Special AttentionNoSpecatt Submitted date2011-01-17 Closed date2011-02-17 Last modified date2011-03-10 APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Fix information Fixed component nameDATAPOWER Fixed component IDDP1234567 Applicable component levels R381 PSYUP R382 PSYUP Document information More support for: IBM DataPower Gateways General Software version: 3.8.1 Reference #: IC73923 Modified date: 2011-03-10 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Trigger If this is your first visit, be sure to check out the FAQ by http://www.dbforums.com/showthread.php?1620233-CALL-db2XUfunctions-XMLUPDATE-stored-procedure-from-A-Java-Application-or-Trigger clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 5 of 5 Thread: CALL db2XUfunctions.XMLUPDATE stored procedure from db2 sql A Java Application or Trigger Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-10-07,09:32 #1 emansour View Profile View Forum Posts Registered User Join Date Jul 2007 Posts 6 Unanswered: CALL db2 sql error db2XUfunctions.XMLUPDATE stored procedure from A Java Application or Trigger Hi everybody, I am using DB2 express-C ver9. I am using db2XUfunctions.XMLUPDATE stored procedure. the signature of XMLUPDATE stored procedure is XMLUPDATE(IN COMMANDSQL VARCHAR(32000), IN QUERYSQL VARCHAR(32000), IN UPDATESQL VARCHAR(32000), OUT errorCode INTEGER, OUT errorMsg VARCHAR(32000)) When I call the stored procedure from the SQl prombet or Command Editor, it is working. the call is ================================================== Call db2XUfunctions.XMLUPDATE ( '