SQL/MX Programming Manual for Java

Program and Module Management
HP NonStop SQL/MX Programming Manual for Java—523726-003
6-18
Versioning
Effect of the Version Attribute
The SQLJ customizer checks for the presence of a Module Version Specification String
(MVSS), which is a regular or delimited identifier that you specify on the SQLJ
command line. For information about how to specify an MVSS on the command line,
see Options for Module Management on page 5-28. For information about identifiers,
see the SQL/MX Reference Manual.
If you specify an MVSS on the SQLJ command line, the customizer appends a leading
circumflex (^) character and the MVSS to the processed, three-part module name. For
example:
CAT.SCH.GRP^MOD^TABLESET^VER
If you do not specify an MVSS on the command line but do specify either a Module
TableSet Specification String (MTSS) or a Module Group Specification String (MGSS),
the customizer appends a trailing ^ to the table-set or module name to represent the
unspecified MVSS. For example:
CAT.SCH.GRP^MOD^TABLESET^
For other combinations of group, table set, and version attributes in module names,
see Table 6-1 on page 6-15.
How to Apply Versioning
These instructions explain how to create multiple versions of an application by using
the same SQLJ source file.
Assumptions
For the purpose of the examples, suppose that:
•
The SQLJ source file is named MyProg.sqlj.
•
The MODULE directives for each connection context in the SQLJ source file are:
#sql [ctx1] {MODULE cat.sch.MyProgCtx1 NAMES ARE ISO88591};
#sql [ctx2] {MODULE cat.sch.MyProgCtx2 NAMES ARE ISO88591};