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

SQL/MX Language Elements

HP NonStop SQL/MX Reference Manual—544517-008

6-102

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

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

See SET SCHEMA Statement on page 2-234, Object Naming on page 10-51, and

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