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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-70

CREATE SQLMP ALIAS Statement

Considerations for CREATE SQLMP ALIAS

Examples of CREATE SQLMP ALIAS

The CREATE SQLMP ALIAS statement defines mappings from an ANSI name to the

physical names of an SQL/MP table or view.

CREATE SQLMP ALIAS is an SQL/MX extension.

catalog.schema.object

is the alias name of an SQL/MP table or view. catalog and schema denote

ANSI-defined catalog and schema, and object is a simple name for the table or

view. If any of the three parts of the name is an SQL/MX reserved word, you must

delimit it by enclosing it in double quotes. For example: mycat."sql".myview.

See Catalogs on page 6-2, Schemas on page 6-101, and Identifiers on page 6-52.

[\node.]$volume.subvol.filename

is the fully qualified Guardian physical name of a table, view, or partition.

In this four-part name, node is the name of a node of a NonStop server, $volume

is the name of a disk volume, subvol is the name of a subvolume, and filename

is the name of an existing SQL/MP table or view. node is not required to be the

local node. if any of the four parts of the name is an SQL/MX reserved word, you

must delimit it by enclosing it in double quotes. Such delimited parts are not case-

sensitive. For example: $myvol."join".mytab.

If you do not specify \node, the default is the Guardian node named in the

=_DEFAULTS define. The value for the physical name is upshifted when the row is

inserted into the SQLMX metadata table.

If the underlying file does not exist or is not an SQL/MP table or view, NonStop

SQL/MX returns an error.

The object part of the name cannot have the name of a UMD table as a prefix.

For example, it cannot be HISTOGRAMS_MYALIAS.

CREATE SQLMP ALIAS catalog.schema.object

[\node.]$volume.subvol.filename