SQL/MX Programming Manual for Java

Program and Module Management
HP NonStop SQL/MX Programming Manual for Java—523726-003
6-15
Effect of Module Management Naming
Effect of Module Management Naming
Table 6-1 lists the effects of combinations of group (MGSS), target or table set (MTSS),
and version (MVSS) attributes on the module file name.
Targeting
By using the target, or table set, attribute for module management, you can create
applications that target different sets of database objects (that is, tables, views and so
on) from a single SQLJ source file without changing the source code, the default
catalog or schema, or the MODULE directive. In the SQLJ source file, use class MAP
DEFINEs for database object names and apply compile-time name resolution to build
applications that target different sets of database objects without changing the source
code. For more information, see DEFINE Names for SQL/MP Objects on page 4-21
and Compile-Time Name Resolution for SQL/MP Objects on page 4-23.
The target attribute is necessary if you want two or more targeted applications (and
their module files) to coexist and run concurrently on the same NonStop system.
Without the target attribute, each build of the application writes an identically named
module in the /usr/tandem/sqlmx/USERMODULES directory, unless you change the
MODULE directive in the source code. The target attribute prevents a subsequently
built application from overwriting the module file of the previously built application.
Effect of the Target Attribute
The SQLJ customizer checks for the presence of a Module TableSet Specification
String (MTSS), which is a regular or delimited identifier that you specify as an SQLJ
option on the SQLJ command line. For information about how to specify an MTSS on
the command line, see Options for Module Management on page 5-28. For information
about identifiers, see the SQL/MX Reference Manual.
Table 6-1. Module Management Naming
Group
Specified?
TableSet
Specified?
Version
Specified? Module Management Qualified Name
Yes Yes Yes CAT.SCH.GRP^MOD^TABLESET^VER
Yes Yes No CAT.SCH.GRP^MOD^TABLESET^
Yes No Yes CAT.SCH.GRP^MOD^^VER
Yes No No CAT.SCH.GRP^MOD^^
No Yes Yes CAT.SCH.^MOD^TABLESET^VER
No Yes No CAT.SCH.^MOD^TABLESET^
No No Yes CAT.SCH.^MOD^^VER
No No No CAT.SCH.MOD
A bold circumflex (^) represents a module management attribute (group, table set, or version) that you did not
specify during customization.