SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-61
Referential Action
Referential Action
This attribute determines how NonStop SQL/MX handles referential action in ALTER
TABLE and CREATE TABLE statements:
Row Maintenance
These attributes determine how NonStop SQL/MX maintains rows in tables:
Attribute Setting
REF_CONSTRAINT_NO_
ACTION_LIKE_RESTRICT
Controls how NO ACTION referential action is
treated. Set to OFF, SYSTEM, or ON.
OFF means that SQL issues error 1301
SYSTEM means that SQL issues warning 1302 saying that it
behaves like RESTRICT.
ON means that NO ACTION behaves like RESTRICT,
without warning or errors.
SYSTEM is the default value.
Attribute Setting
INSERT_VSBB Method of inserting rows into a table. Set to:
OFF
for simple inserts
SYSTEM for DAM to determine the method
USER to use VSBB
LOADNODUP
to insert with no check for duplicates
The default is SYSTEM.
READONLY_CURSOR Set to TRUE or FALSE.
If set to TRUE, you must declare cursors with the FOR UPDATE
clause for the named columns or all columns to be updatable. This
setting improves cursor performance.
If set to FALSE and the declarations omit FOR UPDATE or FOR
READ ONLY, all columns are updatable. In SQL/MX, DELETE
WHERE CURRENT OF does not work without the FOR UPDATE
clause if READONLY_CURSOR is set to true.
SQL/MP Consideration: DELETE WHERE CURRENT OF works
without the FOR UPDATE clause.
The default is TRUE.