SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-79
Trigger Management
Trigger Management
This attribute enables NonStop SQL/MX to manage trigger temporary tables:
Examples of SYSTEM_DEFAULTS Table
•
Insert a row into the SYSTEM_DEFAULTS table to set the current default setting
for the transaction isolation level:
INSERT INTO SYSTEM_DEFAULTS
(ATTRIBUTE, ATTR_VALUE)
VALUES ('ISOLATION_LEVEL', 'SERIALIZABLE');
VARCHAR_PARAM_
DEFAULT_SIZE
Depending on context, untyped parameters might be converted
to the VARCHAR type during compilation of a query. The
default length for this type is 255 characters. This CQD allows
you to change the default length.
Allowable values: 1 to 32768.
The default is 255 characters.
Attribute Setting
TEMPORARY_TABLE_
HASH_PARTITIONS
Describes the partitioning scheme for trigger temporary tables
by listing volumes across which the temporary tables can be
hash partitioned, specified as [\node.]$volume, enclosed in
single quotes. You can specify multiple locations separated by
commas or colons. These examples are all valid:
Control query default
TEMPORARY_TABLE_HASH_PARTITIONS
'$data01,$data02,$data03';
Control query default
TEMPORARY_TABLE_HASH_PARTITIONS
'$data01:$data02:$data03';
Control query default
TEMPORARY_TABLE_HASH_PARTITIONS
'$data01,$data02:$data03';
If you specify more than one volume, the temporary table is
hash partitioned over all those partitions. Range partitioning is
not supported.
If no system default is specified, NonStop SQL/MX uses the
default location of the creator of the first trigger. If the default is
changed, the change affects temporary tables created after the
change. Previously created temporary tables will retain the
previous setting. The partitioning scheme of the trigger subject
table is unrelated to the temporary table.
Attribute Setting