SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Language Elements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
6-107
Schemas
•
Every row returned by the outermost SELECT statement of an
INSERT...SELECT statement. In this case, the NEXTVAL reference must be
from the VALUES clause.
•
Every row projected by the outermost SELECT statement.
•
Every row updated with an UPDATE statement. In this case, sequence can be
acccessed only from the SET clause.
•
The sequence generator is updated by an internal transaction. Sequence
generator updates are independent of the current DML transaction.
Schemas
The ANSI SQL:1999 schema name is an SQL identifier that is unique for a given ANSI
catalog name. NonStop SQL/MX automatically qualifies a schema name with the
current default catalog name unless you explicitly specify a catalog name with the
schema name:
catalog.schema
The three-part logical name of the form catalog.schema.object is an ANSI name.
The parts catalog and schema denote the ANSI-defined catalog and schema.
To be compliant with ANSI SQL:1999, NonStop SQL/MX provides support for ANSI
three-part object names. By using these names, you can develop ANSI-compliant
applications that access all SQL/MX and SQL/MP objects. You can access SQL/MX
objects with the three-part name of the actual object, but you must create an alias for
SQL/MP objects. See CREATE SQLMP ALIAS Statement on page 2-104 and ALTER
SEQUENCE Statement on page 2-13 for more information.
See SET SCHEMA Statement on page 2-370, Object Naming on page 10-60, and
Using NonStop SQL/MX to Access SQL/MP Databases
on page 1-25.