6. QUEL and EQUEL Statements : Copy Statement—Copy Data : Restrictions and Considerations
 
Share this page                  
Restrictions and Considerations
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.