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

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-68
Trigger Management
Trigger Management
This attribute enables NonStop SQL/MX to manage trigger temporary tables:
If the 3-part ANSI name exceeds the maximum OSS file name
length of 248, it is truncated to 248 characters.
Despite similarities in the resulting file names because of
character replacement or file name truncation, the files are
always distinguishable by the trailing timestamp portion of the
name and the contents of the file, which always indicates the
full ANSI name of the table.
NonStop SQL/MX does not remove saved DDL files. You must
remove unwanted files from this location. If you do not
periodically remove these files, the OSS directory will become
full and DROP TABLE will not longer succeed. Database
administrators should monitor the saved DDL location
/usr/tandem/sqlmx/ddl for the accumulation of unneeded files.
Here is an example of a script that will delete DDL files every
seven days:
find /usr/tandem/sqlmx/ddl -mtime +7
-print | grep "/ddl/" | sed "s/./rm &/"
| sh
In development and testing environments where tables are
frequently created and dropped it is recommended that this
value be set to OFF.
The default is ON.
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 4096.
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';
Attribute Setting