G06.29 Release Version Update Compendium

G06.29 Release Version Update Compendium—542946-001

4-1

Database and Transaction

Processing Products

The G06.29 RVU contains new features for this database and transaction processing

product:

•

SQL/MP

•

You can use the DEFERRED option in the CREATE CONSTRAINT statement to

delay the validation of the constraints against the existing rows in the table.

SQL/MP applies the constraints to the table immediately to validate the new inserts

or updates. After the constraints are applied, the locks on the table are released,

and a browse-mode validation of the existing rows is performed. This

enhancement enables concurrent data manipulation language (DML) operations

on the table to complete without waiting for the locks to release.

To use the DEFERRED option, you must specify it explicitly in the CREATE

CONSTRAINT statement. For more information, see the CREATE CONSTRAINT

statement in the SQL/MP Reference Manual.

•

SQL/MP is enhanced to detect an inconsistency between the rows of the base

table and the index. It returns error 1186 when the index has rows that are not

present in the tables, resulting in the inconsistency.

To correct the inconsistency, cancel the operation that caused the inconsistency or

re-create the index if the table contains the correct data.

For more information, see the SQL 1186 error in the SQL/MP Messages Manual.