SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
V-11
VOLUME Command
VOLUME Command
VOLUME is an SQLCI command that changes the current node, volume, or subvolume
defaults for the SQLCI session. VOLUME also sets the VOLUME attribute of the
=_DEFAULTS DEFINE.
Defaults you set with VOLUME remain in effect until you exit SQLCI or until you enter a
SYSTEM, VOLUME, or ALTER DEFINE that changes the defaults.
\node
specifies the node to be the current default node.
volume
specifies the volume to be the current default volume.
subvol
specifies the subvolume to be the current default subvolume.
Considerations—VOLUME

If you enter VOLUME with no parameters, SQLCI resets the current default node,
volume, and subvolume to their values at the start of the SQLCI session. However,
if you specify at least one parameter but omit one or more, SQLCI changes only
what you specify and leaves other values unchanged.

Changing the current defaults for file name expansion does not affect names in
prepared statements unless a CONTROL QUERY BIND NAMES AT EXECUTION
directive was in effect at the time a PREPARE compiled the statement. If you want
new defaults to take effect in other prepared statements, you must use PREPARE
to recompile the statements. For information, see CONTROL QUERY Directive
on
page C-74 or Name Resolution
on page N-2.
Examples—VOLUME

This example changes the current default system to \SYS1:
>> VOLUME \SYS1;

This example changes the default volume and subvolume to $VOL1.INVENT:
>> VOLUME $VOL1.INVENT;
[ \node] ]
VOLUME [ [\node.][$volume] ] ;
[ [\node.][$volume.]subvol ]