NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
T-3
TEDIT Command
TEDIT Command
TEDIT is an SQLCI command that invokes the PS Text Edit editor.
tedit-command-line
is one or more TEDIT commands, as described in the PS Text Edit Reference
Manual.
If you specify more than one command, you must use a semicolon between
commands and enclose tedit-command-line in quotation marks, as shown:
TEDIT "QUERY6; LASTPAGE";
Examples—TEDIT
•
The following command invokes TEDIT from SQLCI:
>> TEDIT;
Temporary Tables
SQL creates temporary tables as needed according to the following rules:
•
If a query involves a join operation, SQL creates a temporary table on the volume on
which the outermost table in the join resides. If the table is partitioned, SQL creates
a temporary table on the volume on which the specified partition resides.
•
If a query involves a hash join or a hash grouping, SQL creates temporary files on
the program swap volume.
•
If a query requires a sort operation but does not use FastSort, SQL creates any
temporary tables used for the sort on the volume on which the table being sorted
resides. If the table is partitioned, SQL creates any temporary table on the same
partition as the partition being sorted.
•
If SQL uses FastSort to sort a table, FastSort’s SORTPROG process creates a
temporary file on the SORTPROG scratch volume.
To redirect temporary tables created by SQL, use the =_SQL_TM_node_vol DEFINE.
To redirect temporary tables created by SORTPROG, use the =_SORT_DEFAULTS
DEFINE.
If ServerWare SMF is installed on your node, temporary table placement for serial plans
is unchanged. For example, if the outermost table in a join resides on a virtual volume,
SQL creates a temporary table on the same virtual volume. However, for parallel plans
SQL places temporary tables only on physical volumes. Virtual volumes are never
candidates for temporary tables SQL creates during a parallel operation.
TEDIT [tedit-command-line] ;