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

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-4
Considerations for ADD DEFINE
If the Guardian physical name includes a reserved word, consider using the
CREATE SQLMP ALIAS statement, instead of the ADD DEFINE command, to
create a logical name mapping.
Considerations for ADD DEFINE
Scope of ADD DEFINE
A DEFINE stays in effect until you change or delete it or until you exit the current
session.
A user can delete a DEFINE within MXCI. A user can delete a DEFINE within MXCI
only that DEFINE was added using the MXCI ADD DEFINE or ALTER DEFINE
command previously in the session. See the DELETE DEFINE Command on page 4-8.
Examples of ADD DEFINE
•
Add a DEFINE that assigns the logical name =ORDERS to the table whose
Guardian physical name is $SAMDB.SALES.ORDERS:
ADD DEFINE =ORDERS, CLASS MAP, FILE $SAMDB.SALES.ORDERS;
While this DEFINE is in effect, you can refer to the table as =ORDERS. The
previous ADD DEFINE command is equivalent to:
ADD DEFINE =ORDERS, FILE $SAMDB.SALES.ORDERS;