SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

SQL/MX Language Elements

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

6-105

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-91 and ALTER

SQLMP ALIAS Statement on page 2-10 for more information.

See SET SCHEMA Statement on page 2-282, Object Naming on page 10-60, and

Using NonStop SQL/MX to Access SQL/MP Databases on page 1-24.