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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-10
Examples of ALTER SQLMP ALIAS
Comparison With Previous Versions
In SQL/MX releases earlier than SQL/MX Release 2.x, the maximum length of the alias
name was 200 characters. Starting with these releases, the alias name is an ANSI
name.
The ALTER SQLMP ALIAS statement was not supported in product versions prior to
SQL/MX Release 2.x.
Late Bind
If you compile an application that uses an SQL/MP alias and later you change the
SQL/MP alias to map to a different SQL/MP table, the SQL/MP table definition is no
longer compatible with the definition used at compile time. As a result, you must
manually recompile applications that use the alias. If the late bind does not find the
SQL/MP table underlying the SQL/MP alias or if the SQL/MP table was moved,
NonStop SQL/MX returns an error.
For more information, see the SQL/MX Programming Manual for C and COBOL or the
SQL/MX Programming Manual for Java.
Examples of ALTER SQLMP ALIAS
•
This example changes the physical name of an SQL/MP table:
ALTER SQLMP ALIAS SAMDBCAT.PERSNL.EMPLOYEE
\MYSYS.$SAMDB.PERSNL.NEWEMP