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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-73
Examples of CREATE SQLMP ALIAS
SQL/MP shorthand view and whose OBJECT_UID points to an entry in the
MP_PARTITIONS table in the same definition schema. (See MP_PARTITIONS Table
on page 10-19. The MPALIAS table which SQL/MX Release 1.8 and earlier versions
created in the SQL/MP catalog is no longer used. Instead, the alias information for
each schema is kept in the SQL/MX metadata for that schema.
Examples of CREATE SQLMP ALIAS
•
Suppose that you have created an SQL/MP table by using this SQL/MP CREATE
TABLE statement:
CREATE TABLE $myvol.mysubvol.mytable
( num NUMERIC (4) UNSIGNED NOT NULL
,name VARCHAR (20)
,PRIMARY KEY (num) );
This statement creates a mapping in the metadata table:
CREATE SQLMP ALIAS mycatalog.myschema.mytable
$myvol.mysubvol.mytable;