SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—640322-001
10-56
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.