-20008 ATTEMPT TO USE UNSUPPORTED FEATURE msg-token. REASON CODE: reason-code
Explanation
The statement attempted to use a feature or format that is not supported.
- msg-token
- Text that identifies the unsupported feature.
- reason-code
- A numeric value that identifies the unsupported feature:
- 1
- The statement attempted to call the SYSPROC.XSR_COMPLETE stored procedure and specified 1 for fourth argument value, which indicates use of the XML schema decomposition feature. The only supported value for this argument is 0. The XMLTABLE function replaces use of XSR_COMPLETE for XML schema decomposition, which is not supported beginning in DB2® 10.
- 2
- The table that is indicated by msg-token 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 indexes are no longer supported. Only TYPE 2 can be specified, beginning in DB2 version 6.
- 4
- The SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure is no longer supported beginning with Db2 12 V12R1M503.
- 5
- FL 504 Synonyms are deprecated and cannot be created with application compatibility V12R1M504 or higher.
- 6
- FL 504 Hash-organized tables are deprecated and cannot be created with application compatibility V12R1M504 or higher.
- 7
- FL 504 Partitioned (non-UTS) table spaces are deprecated and cannot be created with application compatibility V12R1M504 or higher.
- 8
- FL 504 New tables cannot be created in non-UTS table spaces with application compatibility V12R1M504 or higher.
System action
The statement or EXPLAIN operation cannot be processed.
Programmer response
Take appropriate action based on the reason-code value. In most cases, remove references to the unsupported clause or keyword from the SQL statement, to avoid using the unsupported feature.
For reason-code 2, either migrate the EXPLAIN tables to the current format or redefine them by dropping and re-creating them in the required format. For more information, see Migration step 25: Convert EXPLAIN tables to the current format.
For reason code 4, update your application to use the SYSIBMADM.REPLICATION_OVERRIDE built-in global variable instead of the SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure.
SQLSTATE
560A9