-20555 AN ARCHIVE-ENABLED TABLE IS NOT ALLOWED IN THE SPECIFIED CONTEXT. REASON CODE reason-code.

Explanation

The statement or query cannot reference an archive-enabled table for the indicated reason.

reason-code

A numeric value that identifies the reason for the error. reason-code can have one of the following values:

1

The SQL statement cannot reference both an archive-enabled table and a temporal table. (The temporal table can be either a system-period temporal table or an application-period temporal table.) For example, a query, a view definition, or an INSERT, UPDATE, or DELETE statement cannot reference both of these table types.

2

An INSERT, UPDATE, or MERGE statement cannot reference an archive-enabled table as the target of its operation when the value of the SYSIBMADM.MOVE_TO_ARCHIVE global variable is Y.

3

An SQL table function cannot reference an archive-enabled table when both of the following conditions are true:

• The value of the SYSIBMADM.GET_ARCHIVE global variable is Y.
• The value of the ARCHIVESENSITIVE bind option is YES.

4

The definition of a row permission or column mask that is activated by a data change statement or query cannot reference an archive-enabled table when both of the following conditions are true:

• The value of the SYSIBMADM.GET_ARCHIVE global variable is Y.
• The value of the ARCHIVESENSITIVE bind option is YES.