SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-214
SET MPLOC Statement
SET MPLOC Statement
Considerations for SET MPLOC
Examples of SET MPLOC
The SET MPLOC statement sets the default NonStop operating system volume and
subvolume for physical object names for the current SQL session.
The SET MPLOC statement sets the default volume and subvolume for physical object
names in all dynamic statements within the control flow scope of an embedded SQL
program for the current SQL session.
SET MPLOC is an SQL/MX extension.
[\node.]$volume.subvolume
is the fully qualified Guardian physical name of a subvolume. If you do not specify
\node, the default is the Guardian system named in the =_DEFAULTS define.
Considerations for SET MPLOC
Scope of SET MPLOC
The default volume and subvolume you specify with SET MPLOC remains in effect
until the end of the session or until you execute another SET MPLOC statement.
If no SET MPLOC statement is in effect, NonStop SQL/MX determines the default
physical location. For more information, see Object Naming on page 10-47.
Use SET MPLOC to set the default volume and subvolume for dynamic SQL
statements. Use DECLARE MPLOC to set the default volume and subvolume for static
SQL statements. See DECLARE MPLOC Declaration on page 3-28. For more
information, see the SQL/MX Programming Manual for C and COBOL or the SQL/MX
Programming Manual for Java.
Examples of SET MPLOC
•
Set the default volume and subvolume without setting the system:
SET MPLOC $myvol.mysubvol;
•
Set the default system, volume, and subvolume:
SET MPLOC \aztec.$data06.part;
If you then set the default volume and subvolume:
SET MPLOC $data08.sales;
the system will default to the system you previously set.
SET MPLOC [\node.]$volume.subvolume
Embed
Embed