13.14.1 Specification

Specify the CREATE TABLE definition SQL with the INSERT ONLY operand (falsification prevention option) specified. Alternatively, you can change the definition of an existing table to a falsification prevented table by specifying the INSERT ONLY option in ALTER TABLE.

When you are defining a table or changing a table's definition, you can define the following types of columns:

Because there are limitations* on the operations that can be performed on RDAREAs by the database reorganization utility or the pdrels command, it is recommended that you store each falsification prevented table in a single RDAREA.

* You must execute a command shutdown on the RDAREA in order to use the database reorganization utility to reorganize a falsification prevented table. If the database reorganization utility terminates abnormally, then if there are any other tables or indexes defined in the RDAREA they will become unavailable, because you cannot release the shutdown until the reorganization has been completed. For details, see 13.14.2 Restrictions.