SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-210

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 node 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-48.

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.

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