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

Embedded-Only SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

3-28

DECLARE MPLOC Declaration

Considerations for DECLARE MPLOC

C Examples of DECLARE MPLOC

COBOL Examples of DECLARE MPLOC

The DECLARE MPLOC declaration is a compiler directive that sets the default volume

and subvolume for unqualified Guardian physical object names in static SQL

statements that follow the declaration within a compilation unit.

DECLARE MPLOC is used by the preprocessor when the INVOKE directive is not fully

qualified. It is also used in embedded programs to access SQL/MP tables in static

SQL statements. Otherwise, you must use CREATE SQLMP ALIAS to map an

SQL/MP table to an ANSI name.

You must precede DECLARE MPLOC statements with the DECLARE NAMETYPE

‘NSK’ statement. Otherwise, the program defaults to ANSI type and DECLARE

MPLOC is ignored.

DECLARE MPLOC is an SQL/MX extension that you use only in embedded SQL

programs.

default-mploc

is a character string literal that specifies the Guardian physical name of a

subvolume. A string literal is enclosed in single quotation marks.

The form is: '[\node.]$volume.subvolume'

If you do not specify \node, the default is the Guardian system named in your

=_DEFAULTS define. By using the \node name, you can have multiple database

access over the network during processing.

DECLARE MPLOC default-mploc

C/COBOL