SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—544517-008
10-51
Object Naming
For more information about the differences between NonStop SQL/MP and
NonStop SQL/MX relating to DML operations against nonaudited tables, see the
SQL/MX Comparison Guide for SQL/MP Users.
Object Naming
These attributes determine how NonStop SQL/MX assigns object names:
Attribute Setting
IUD_NONAUDITED_
INDEX_MAINT
Set to ON, OFF, or WARN. Specifies whether NonStop SQL/MX
allows insert/update/delete operations on nonaudited SQL/MP tables
that require index maintenance. If OFF, DML operations on
nonaudited tables are not allowed when the tables require index
maintenance. Any effort to prepare or compile such a statement
results in an error. If WARN, NonStop SQL/MX allows the DML
operation when the tables require index maintenance; however, a
warning is given. If ON, NonStop SQL/MX allows the operations
without error or warning.
The default is OFF.
SQL/MX tables must be audited.
Attribute Setting
NAMETYPE Set to ANSI or NSK to indicate whether the system uses three-part
logical names (ANSI) or four-part physical Guardian names (NSK) to
refer to database objects in statements. The NSK setting applies to
the resolution of unqualified SQL/MP object names.
The default is ANSI.
CATALOG Default catalog name, used if no first part is specified in a three-part
logical name. If not set, the group name of the current user becomes
the default first part of the logical name.
In SQL/MX Release 2.0, the three-part name is an ANSI name. The
parts catalog and schema denote the ANSI-defined catalog and
schema.
SCHEMA Default schema (without catalog) name, used if no second part
is specified in a three-part logical name. The schema name can
be qualified by a catalog name, in which case this catalog name
supersedes any settings for the CATALOG attribute. If not set,
the user name of the current user becomes the default second
part of the logical name.
In SQL/MX Release 2.0, the three-part name is an ANSI name.
The parts catalog and schema denote the ANSI-defined catalog
and schema.
MP_SUBVOLUME Default physical subvolume, used if no subvolume is specified
in the Guardian name. If not set, the default subvolume is
specified by the =_DEFAULTS define.
MP_SYSTEM Default system name, used if no system is specified in the NSK
name. If not set, the default system is specified by the
=_DEFAULTS define.