SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-59
Metadata Management
Metadata Management
This attribute enables NonStop SQL/MX to manage metadata:
Module Management
This attribute determines where globally placed modules are generated:
Attribute Setting
CREATE_DEFINITION_SCHEM
A_VERSION
Assigns a schema version to new schemas during
schema creation time. For SQL/MX 3.0, the valid
schema versions are SYSTEM, 1200, and 3000.
The default value is SYSTEM.
The following scenarios explain how the schema
version is assigned:

When CREATE_DEFINITION_SCHEMA_VERSION
is set to SYSTEM:

if no user schemas exist in the affected catalog,
the new schema will use the current schema
version

if user schemas exist in the affected catalog,
the new schema will use the version of the
existing schemas.

When CREATE_DEFINITION_SCHEMA_VERSION
is set to any other value:

if that value differs from the version of the
existing schemas in a catalog at the schema
creation time, error 25221 is raised.

If that value is not a valid schema version, error
25222 is raised at the schema creation time.
Attribute Setting
MXCMP_PLACES_LOCAL_
MODULES
Set to ON or OFF.
If OFF, NonStop SQL/MX generates global modules in
the USERMODULES directory.
If ON and you do not specify
mxcmp -g moduleLocal=OSS-dir
on the command line, compiled modules are placed in
the current OSS directory.
If ON and you specify
mxcmp -g moduleLocal=OSS-dir
on the command line, compiled modules are placed in
the OSS-dir directory.
The default is OFF.
For more information about module management, see
the SQL/MX Programming Manual for C and COBOL.