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.
  

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

SQL		RDAREA status
		Not on online reorganization hold	On online reorganization hold
Definition SQL	ALTER TABLE	C#1	N
	CREATE INDEX	C#1	N
	CREATE TABLE	C#1, #2	N
	DROP INDEX	C#1	N
	DROP SCHEMA	C#1	N
	DROP TABLE	C#1	N
	GRANT	C#1	C#1
Data manipulation SQL	ASSIGN LIST statement	Y	C#1
	CALL statement	Y	C#1
	DELETE statement	Y	C#1
	FETCH statement	Y	C#1
	INSERT statement	Y	C#1
	PURGE TABLE statement	Y	N
	Single-row SELECT statement	Y	C#1
	Dynamic SELECT statement	Y	C#1
	UPDATE statement	Y	C#1
	Assignment statement	Y	C#1
Control SQL	LOCK statement	Y	C#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.