Start of change

-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.

Start of changemsg-tokenEnd of change
Start of changeText that identifies the unsupported feature.End of change
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.
Start of change4End of change
Start of changeStart of changeThe SYSPROC.SET_MAINT_MODE_RECORD_NO_TEMPORALHISTORY stored procedure is no longer supported beginning with Db2 12 V12R1M503.End of changeEnd of change
Start of change 5End of change
Start of changeFL 504 Synonyms are deprecated and cannot be created with application compatibility V12R1M504 or higher.End of change
Start of change 6End of change
Start of changeFL 504 Hash-organized tables are deprecated and cannot be created with application compatibility V12R1M504 or higher.End of change
Start of change 7End of change
Start of changeFL 504 Partitioned (non-UTS) table spaces are deprecated and cannot be created with application compatibility V12R1M504 or higher.End of change
Start of change 8End of change
Start of changeFL 504 New tables cannot be created in non-UTS table spaces with application compatibility V12R1M504 or higher.End of change

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

End of change