Release Notes

Data Movement Utilities Guide and Reference

12.1 Pending States After a Load Operation

The first two sentences in the last paragraph in this section have been changed to the following:

   The fourth possible state associated with the load process (check pending state)
   pertains to referential and check constraints, DATALINKS constraints,
   AST constraints, or generated column constraints. For example, if an existing table
   is a parent table containing a primary key referenced by a foreign key
   in a dependent table, replacing data in the parent table places both tables (not the
   table space) in check pending state.

12.2 Load Restrictions and Limitations

The following restrictions apply to generated columns and the load utility:

• It is not possible to load a table having a generated column in a unique index unless the generated column is an "include column" of the index or the generatedoverride file type modifier is used. If this modifier is used, it is expected that all values for the column will be supplied in the input data file.
• It is not possible to load a table having a generated column in the partitioning key unless the generatedoverride file type modifier is used. If this modifier is used, it is expected that all values for the column will be supplied in the input data file.