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:

The following table lists the SQL statements that can be executed in conjunction with the inner replica facility.

Table 1-36 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 TABLEC#1N
CREATE INDEXC#1N
CREATE TABLEC#1, #2N
DROP INDEXC#1N
DROP SCHEMAC#1N
DROP TABLEC#1N
GRANTC#1C#1
Data manipulation SQLASSIGN LIST statementYC#1
CALL statementYC#1
DELETE statementYC#1
FETCH statementYC#1
INSERT statementYC#1
PURGE TABLE statementYN
Single-row SELECT statementYC#1
Dynamic SELECT statementYC#1
UPDATE statementYC#1
Assignment statementYC#1
Control SQLLOCK statementYC#1
Legend:
Y: Can be executed.
C: Can cause an error depending on certain conditions.
N: Cannot be executed.
#1: For details about the conditions, see the manual HiRDB Version 9 Staticizer Option.
#2: Falsification prevented tables cannot be created in an RDAREA for which the inner replica facility is used.