SQL/MX Programming Manual for Java

Processing SQLJ Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
5-31
Options for Object Name Qualification
-mploc value. By default the -nametype option is ANSI. To use the -mploc option,
set -nametype to NSK. See -nametype on page 5-31.
The customizer applies this setting to an unqualified object name only when another
setting does not override this option. If you specify a three-part name, such as
\node1.$vol1.subvol1, the customizer interprets the first part as the node, the
second part as the volume, and the third part as the subvolume. If any parts of the
three-part name are missing, the customizer uses the current default settings for those
parts (for example, the MP_SYSTEM, MP_VOLUME, or MP_SUBVOLUME default
attributes). For more information, see Precedence of Object Name Qualification on
page 4-22.
For example, this command directs the customizer to use $vol1.subvol1 as the
volume and subvolume for unqualified SQL/MP object names:
java sqlj.tools.Sqlj -nametype=nsk -mploc=$vol1.subvol1
MyProg.sqlj
-nametype
The -nametype option specifies the name type for the customizer to use when
interpreting and qualifying object names in a program. The -nametype option accepts
either ansi for ANSI logical names of SQL/MX objects or nsk for Guardian physical
names of SQL/MP objects. By default the -nametype option is ANSI. To use the
-mploc option, set -nametype to NSK. For more information, see -mploc on
page 5-30.
For example, this command directs the customizer to set the nametype to NSK (that is,
to interpret and qualify object names as Guardian physical names) and to use
$vol1.subvol1 as the volume and subvolume for unqualified SQL/MP object names:
java sqlj.tools.Sqlj -nametype=nsk -mploc=$vol1.subvol1
MyProg.sqlj
-schema
The -schema option specifies the schema name or the catalog and schema names for
the customizer to use as a prefix for unqualified SQL/MX object names, SQL/MP
aliases, and modules in a program. The customizer applies this setting only when
-nametype=ansi. By default the -nametype option is ANSI. See -nametype on
page 5-31.
The customizer applies this setting to an unqualified object or module name only when
another setting does not override this option. For example, the -moduleSchema
option takes precedence over the -schema option for module names. For module
name qualification, see Catalog and Schema of the Module Name on page 4-13. For
object name qualification, see Precedence of Object Name Qualification on page 4-22.
If you specify a two-part name, such as cat.sch, the customizer interprets the first
part as the catalog and the second part as the schema. The -catalog option
overrides the catalog value set in the -schema option.