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

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-74

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;