Specifies whether attempts to update or insert values in a field with automatically incrementing values generate errors.

Note
A cursor inherits the current setting of SET AUTOINCERROR when opened. Changing the value of SET AUTOINCERROR during a session does not change the setting for any cursors already opened. To change the setting of an open cursor, use the CURSORSETPROP( ) function.

SET AUTOINCERROR ON | OFF

Parameters

ON

Generates an error when updating or inserting a value in a field that uses automatically incrementing field values. The ON setting is the default for a global or private data sessions.

OFF

Does not generate an error when updating or inserting a value in a field that uses automatically incrementing field values and disregards the value specified for the field, which uses the appropriate incremented value.

Remarks

See Also