-20008 ATTEMPT TO USE AN UNSUPPORTED FEATURE ON OBJECT object-name. REASON CODE: reason-code
Explanation
The statement attempted to use a feature or format that is not supported.
- reason-code
- A numeric value that identifies the unsupported 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 table that is indicated by object-name is defined with a format that is no longer supported by EXPLAIN. Only one instance of this message is issued per package for EXPLAIN tables in supported formats during bind or rebind.
- 3
- TYPE 1 is a deprecated feature for indexes and is no longer supported. Only TYPE 2 can be specified.
- object-name
- When reason-code is 2, the name of the table. Otherwise, *N.
System action
The statement or EXPLAIN operation cannot be processed.
Programmer response
Change your SQL statement to avoid using the unsupported feature or format. 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.
- 3
- Update the SQL statement to remove references to the unsupported clause.
SQLSTATE
560A9
