1.12 Restrictions on the use of the inner replica facility

The use of the inner replica facility through the installation of HiRDB Staticizer Option and the use of updatable online reorganization are subject to the following restrictions:

Table 1-35 shows SQL statements that can be executed in conjunction with the inner replica facility.

Table 1-35 SQL statements that can be executed in conjunction with the inner replica facility

SQLRDAREA status
Not on online reorganization holdOn online reorganization hold
Definition SQLALTER TABLEC1N
CREATE INDEXC1N
CREATE TABLEC1, 2N
DROP INDEXC1N
DROP SCHEMAC1N
DROP TABLEC1N
GRANTC1C1
Data manipulation SQLASSIGN LIST statementYC1
CALL statementYC1
DELETE statementYC1
FETCH statementYC1
INSERT statementYC1
PURGE TABLE statementYN
Single-row SELECT statementYC1
Dynamic SELECT statementYC1
UPDATE statementYC1
Assignment statementYC1
Control SQLLOCK statementYC1
Legend:
Y: Can be executed.
C: Can cause an error depending on certain conditions.
N: Cannot be executed.
1 For details on the conditions, see the manual HiRDB Staticizer Option Version 7.
2 Falsification prevented tables cannot be created in an RDAREA for which the inner replica facility is used.