SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-59
Referential Action
For a full discussion of query plan caching, see the SQL/MX Query Guide.
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:
QUERY_CACHE_STATEMENT_
PINNING
Set to ON, OFF, or CLEAR. Controls whether queries
are entered into the cache as pinned or unpinned. You
might have important, compile-time critical queries that
you want to ensure are in the cache when needed.
When a query is pinned in the cache, it usually cannot
be displaced from the cache unless the cache becomes
full of pinned queries. In this case, the least recently
used pinned entries also become displaceable.
The value CLEAR means that all subsequent query
cache entries are unpinned, and all pinned entries in
the cache are also unpinned.
The value ON means that all subsequent query cache
entries into the cache are pinned.
The default setting, OFF, means that all subsequent
query entries into the cache are unpinned.
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.
Attribute Setting