SQL/MX Programming Manual for C and COBOL (H06.04+)
C/C++ Program Compilation
HP NonStop SQL/MX Programming Manual for C and COBOL—540434-001
15-30
Compiling Embedded Module Definitions
This example shows how to set MP_SYSTEM and MP_VOLUME as
mxCompileUserModule command-line options:
to get MP_SYSTEM=\KINGPIN --> use -d MP_SYSTEM=\\\\KINGPIN
to get MP_VOLUME=$TX012 --> use -d MP_VOLUME=\\\$TX012
application-file
is the OSS path name of an object file that contains embedded module definitions.
The OSS directory:
•
Must exist and be accessible. Otherwise, an error is returned, and no module
is created.
•
Must not specify a Guardian subvolume (/G/...) or a remote directory in an
Expand network (/E/...).
•
Must not exceed 1024 characters.
module-name
is the fully qualified name of an embedded module definition. This option names
the generated module that is written to the user-specified local application directory
or to the global /usr/tandem/sqlmx/USERMODULES directory. For more
information, see Module Management Naming on page 17-8.
Each module-name consists of:
[[catalog.]schema.]module[MODULEGROUP=group]
[MODULETABLESET=target][MODULEVERSION=version]
If catalog and schema are omitted, their default value settings can be supplied
with -d MODULECATALOG=catalog or -d MODULESCHEMA=schema. If
MODULEGROUP, MODULETABLESET, or MODULEVERSION is omitted, the default
setting can be supplied with -d MODULEGROUP=group, -d
MODULETABLESET=target, or -d MODULEVERSION=version.
If no module name is specified, mxCompileUserModule operates on all
embedded module definitions of application-file. Otherwise, each module-
name is the fully qualified three-part name of an embedded module definition in
application-file, and mxCompileUserModule operates only on the named
embedded module definitions.
In summary, modules can be named as:
•
A fully qualified delimited module name, such as
cat.sch.\"GRP^MODULE^TGT^VER\"
•
A qualified module name followed by module specification strings, such as
cat.sch.module MODULEGROUP=grp MODULETABLESET=tgt
MODULEVERSION=ver
•
A simple, unqualified module name (for example, mod), with the catalog,
schema, group, table set, or version specified as -d compiler attributes










