SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

S-93

SYSTEM Command

SYSTEM is an SQLCI session command that selects a node to be the current default

node for the SQLCI session.

node

is the name of a node to be the current default.If you omit node, SQL uses the

node on which SQLCI is executing.

Considerations—SYSTEM



The default stays in effect only for the SQLCI session. When you return to TACL,

the TACL default is used.



These commands are not equivalent:

>> SYSTEM \local-node;

>> SYSTEM ;

The first command shown causes the network restrictions on file-name lengths to

take effect; the second command does not. For information on network file-name

lengths, see the Expand Network Management Guide.



SYSTEM sets the node name qualifier in the =_DEFAULTS DEFINE. (You can also

change to a different default node by using the ALTER DEFINE =_DEFAULTS

command and changing the node specified for the VOLUME attribute.)

Example—SYSTEM

This command makes \SYS1 the default node:

>> SYSTEM \SYS1;

SYSTEM [ \node ] ;