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:

• Using the inner replica facility
  SQL statements that can be executed on RDAREAs using the inner replica facility are subject to certain restrictions.
  
• Using updatable online reorganization
  SQL statements that can be executed on online reorganization-hold RDAREAs are subject to certain 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

SQL		RDAREA status
		Not on online reorganization hold	On online reorganization hold
Definition SQL	ALTER TABLE	C1	N
	CREATE INDEX	C1	N
	CREATE TABLE	C1, 2	N
	DROP INDEX	C1	N
	DROP SCHEMA	C1	N
	DROP TABLE	C1	N
	GRANT	C1	C1
Data manipulation SQL	ASSIGN LIST statement	Y	C1
	CALL statement	Y	C1
	DELETE statement	Y	C1
	FETCH statement	Y	C1
	INSERT statement	Y	C1
	PURGE TABLE statement	Y	N
	Single-row SELECT statement	Y	C1
	Dynamic SELECT statement	Y	C1
	UPDATE statement	Y	C1
	Assignment statement	Y	C1
Control SQL	LOCK statement	Y	C1

Legend:

Y: Can be executed.

C: Can cause an error depending on certain conditions.

N: Cannot be executed.

¹ For details on the conditions, see the manual HiRDB Staticizer Option Version 7.

² Falsification prevented tables cannot be created in an RDAREA for which the inner replica facility is used.