SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—523725-004
10-47
Nonaudited Tables
Nonaudited Tables
This attribute enables NonStop SQL/MX to handle inserts, updates, and deletes
against nonaudited SQL/MP tables:
For 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.