602SQL Documentation Index  

Errors in the XML extension

Error information

XML errors in server functions can be processed using a handle. Error codes may be retrieved from the handle using the SQLSTATE system variable and the text description using the @@ERROR_MESSAGE system variable.

Most errors that occur while working with XML are generic errors. The error number (code) will only give you approximate information about the error type. Detailed information is stored in the text description (e.g. if an error occurs when validating an XML document, 602SQL will accept the error text from the XML parser).

Errors and transactions

Data import from an XML document to the database is done in a single transaction.

If an error occurs during the import, the entire transaction will be rolled back. Therefore, data cannot be partially imported. The transaction will also rollback when an error occurs outside the database operation (e.g. incorrect XML or DAD format).