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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-9

ALTER SQLMP ALIAS Statement

Considerations for ALTER SQLMP ALIAS

Examples of ALTER SQLMP ALIAS

The ALTER SQLMP ALIAS statement changes the physical name of an SQL/MP table

to which an existing alias is mapped.

ALTER SQLMP ALIAS is an SQL/MX extension.

Syntax Description of ALTER SQLMP ALIAS

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 part of the name is an SQL/MX reserved word, you must delimit it by

enclosing it in double quotes. For example: mycat.”sql”.myview.

[\node.]$volume.subvol.filename

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

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 SQL/MP table or view. 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 system named in the

=_DEFAULTS define.

Considerations for ALTER SQLMP ALIAS

Usage Restrictions

If the specified alias does not exist or the specified Guardian file does not exist,

NonStop SQL/MX returns an error. If the ALTER SQLMP ALIAS statement specifies a

physical file name that is the same as the current alias mapping, NonStop SQL/MX

returns a warning.

Security of Alias

To alter an existing SQL/MP alias, you must own its schema or be the super ID.

ALTER SQLMP ALIAS catalog.schema.object

[\node.]$volume.subvol.filename