SQL/MX Programming Manual for Java

Processing SQLJ Programs
HP NonStop SQL/MX Programming Manual for Java—523726-003
5-35
Command-Line Syntax
-g moduleGlobal
specifies that the module be placed globally in the /usr/tandem/sqlmx/
USERMODULES
directory. Use this option to generate modules for an SQLJ
program when the MXCMP_PLACES_LOCAL_MODULES attribute is ON in the
SYSTEM_DEFAULTS table. If you do not specify this option when
MXCMP_PLACES_LOCAL_MODULES is ON, mxCompileUserModule
generates modules in the same directory where you invoke it.
For more information about MXCMP_PLACES_LOCAL_MODULES, see the
SQL/MX Reference Manual.
-d compiler-attribute-name=compiler-attribute-value
specifies default attribute settings for compilation and existing settings for the
module name. The module name settings are:
modulecatalog=cat
moduleschema=sch
modulegroup=grp
moduletableset=tgt
moduleversion=ver
The module name settings must match the module management options you
specified during customization. See Options for Module Management on
page 5-28.
The default attribute settings for compilation override settings in the
SYSTEM_DEFAULTS table but do not override the object name qualification or the
settings of embedded CONTROL QUERY DEFAULT, DECLARE, or SET
statements, which are applied during customization. For more information about
default attributes, see the SYSTEM_DEFAULTS table in the SQL/MX Reference
Manual.
extended-profile
is the OSS path name of an extended profile (.ser 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
Note. Currently, SQL/MX does not support locally placed modules for SQLJ applications.
The modules of an SQLJ application must be stored in the /usr/tandem/sqlmx/
USERMODULES directory. Otherwise, the program will either run dynamically or return an
SQL exception indicating that the module is missing or corrupted. For more information,
see SQL/MX Compiler Errors on page 4-5.