SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
X-6
Example—=_SORT_DEFAULTS

An error occurs if you add =_SORT_DEFAULTS without specifying CLASS SORT
either explicitly or through the working attribute set.
For more information about =_SORT_DEFAULTS, see the TACL Reference Manual or
the FastSort Manual.
Example—=_SORT_DEFAULTS
This SQLCI example specifies scratch and swap volumes for FastSort operations:
>> ADD DEFINE =_SORT_DEFAULTS, CLASS SORT,
+> SCRATCH $DISKA, SWAP $DISKB;
The specified volumes are to be used for SQL queries or utility operations that call
FastSort as long as the DEFINE remains in effect.
=_SQL_CAT_HEAP_LIMIT DEFINE
=_SQL_CAT_HEAP_LIMIT is a system DEFINE that specifies the heap space size for
the SQLCAT process. Some SQL DDL or utility statements require a large memory
heap in the SQLCAT process. The catalog manager currently allocates 4 MB of heap
space that can expand to 16 MB. You can use this DEFINE to allocate a larger heap.
heap-space-size
is the amount of heap space for the SQLCAT process, in megabytes. This value
can range from 8 to 1119. SQL does not use the node, volume, and subvolume
portions of the file name if supplied.
Considerations—=_SQL_CAT_HEAP_LIMIT

If there is an error in heap-space-size, SQL returns a warning, and SQLCAT
runs with the default heap space size.

The =_SQL_CAT_HEAP_LIMIT DEFINE can be used from TACL, SQLCI, or a
user process (for embedded SQL).
Examples—=_SQL_CAT_HEAP_LIMIT

This TACL command specifies 32 MB of SQLCAT heap space:
32> ADD DEFINE =_SQL_CAT_HEAP_LIMIT, CLASS MAP, FILE M32

This TACL command directs SQL to use its default value for heap space size:
33> DELETE DEFINE =_SQL_CAT_HEAP_LIMIT
ADD DEFINE =_SQL_CAT_HEAP_LIMIT, [CLASS MAP, ]
FILE Mheap-space-size