+20520 ATTEMPT TO USE A DEPRECATED FEATURE ON OBJECT object-name. REASON CODE reason-code
Explanation
The statement attempted to use a deprecated feature.
- reason-code
- A numeric value that identifies the deprecated feature:
- 1
- The statement attempted use the XML schema decomposition feature.
Processing continues and the stored procedure was invoked. This situation
can occur when the following stored procedures are called:
- SYSPROC.XSR_COMPLETE with the issuedfordecomposition flag set to 1
- SYSPROC.XDBDECOMPXML
- SYSPROC.XDBDECOMPXML100MB
- 2
- The definition of table that is indicated by object-name is
created with a format that is no longer supported by EXPLAIN. Processing
continues and the EXPLAIN tables are populated as usual. Only one instance of this message is issued
per package for EXPLAIN tables in supported formats during bind or
rebind.
This condition is normal during conversion mode after migration from Version 8 if object-name is DSN_STATEMENT_CACHE_TABLE.
- object-name
- When reason-code is 2, the name of the table. Otherwise, *N.
System action
Processing continues as described in the explanation.
User response
No change is required at this time. However, you should update the statement to prepare for future releases, when an error will be returned for the same condition.
Programmer response
Change the statement for future releases. Take the action that corresponds to the reason-code value:
- 1
- Update your SQL statement to change any implicit or explicit reference to the XML schema decomposition feature so that they use the XMLTABLE function for the decomposition of an XML document.
- 2
- Either migrate the EXPLAIN tables to the current format or redefine
them by dropping and re-creating them in the required format.
This condition is normal during conversion mode after migration from Version 8 if object-name is DSN_STATEMENT_CACHE_TABLE. After DB2® enters new-function mode, use job DSNTIJXA to alter DSN_STATEMENT_CACHE_TABLE into Version 10 format.
SQLSTATE
01694
