SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Managing Database Applications
HP NonStop SQL/MX Installation and Management Guide—523723-004
11-12
Setting SQL/MP Aliases
SET DEFMODE ON is set, and then use the DEFINE commands appropriate for that
environment.
In the OSS environment, use the OSS add_define command to add class MAP
DEFINEs for SQL/MP tables or views:
add_define =define-name class=map
file=\\node.\$volume.subvol.table
In the Guardian environment, use the TACL ADD DEFINE command to add class MAP
DEFINEs for SQL/MP tables or views:
ADD DEFINE =define-name, class=map
file \node.$volume.subvol.table
For more information about DEFINE commands for the OSS and Guardian
environments, see the Open System Services Shell and Utilities Reference Manual
and the TACL Reference Manual.
For more information about DEFINEs, see the SQL/MX Reference Manual. For
information on how to use DEFINE names in SQL programs, see the SQL/MX
Programming Manual for Java and the SQL/MX Programming Manual for C and
COBOL.
Setting SQL/MP Aliases
To use ANSI names for SQL/MP tables or views, create an SQL/MP alias that maps to
a Guardian physical name.
In a distributed environment, when you create an SQL/MP alias name for an SQL/MP
object on a remote node, use a fully qualified SQL/MP object name. The SQL/MP
aliases must be in SQL/MX user catalogs that are visible on the nodes where the
programs exist. For information about registering catalogs to make them visible in an
SQL/MX distributed database environment, see Using Catalog References in an
SQL/MX Distributed Database on page 13-8.
You can use OBEY command files or scripts to automate the process of creating large
numbers of SQL/MP aliases for applications that you will run in the SQL/MX production
environment. Create the SQL/MP aliases before you start processing or running
applications in the production environment.
For information about SQL/MP aliases, see the SQL/MX Reference Manual.
For information on how to code SQL/MP aliases in SQL programs, see the SQL/MX
Programming Manual for Java and the SQL/MX Programming Manual for C and
COBOL.
Note. Precede the backslash (\) in the node name and the dollar sign ($) in the volume name
with the OSS shell escape character (\).