SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-48
Nonaudited Tables
Nonaudited Tables
This attribute enables NonStop SQL/MX to handle inserts, updates, and deletes
against nonaudited SQL/MP tables:
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:
Caution. If the IUD_NONAUDITED_INDEX_MAINT is set to ON, NonStop SQL/MX allows
DML operations on nonaudited tables without error or warning. Before you set this attribute,
see the SQL/MX Comparison Guide for SQL/MP Users to understand index maintenance of
nonaudited tables.
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.