• You cannot use copy to add data to a view, index, or system catalog.

• When copying data into a table, copy ignores any integrity constraints (defined using the define integrity statement) defined against the table.

• When copying data into a table, copy ignores ANSI/ISO Entry SQL-92 check and referential constraints, but does not ignore unique (and primary key) constraints. For details about ANSI/ISO table constraints, see the SQL Reference Guide.

• The copy statement does not fire any rules defined against the table.