NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
V-11
Considerations—VOLUME
Considerations—VOLUME
•
Defaults for omitted parameters
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.
•
Effect on prepared statements
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. (See CONTROL QUERY Directive
on page C-70 or
Name Resolution
on page N-2 for details.)
Examples—VOLUME
•
The following command changes the current default system to \SYS1:
>> VOLUME \SYS1;
•
The following command changes the default volume and subvolume to
$VOL1.INVENT:
>> VOLUME $VOL1.INVENT;
•
The following command resets the default node, volume, and subvolume to their
values at the start of the SQLCI session:
>> VOLUME;