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

Managing Database Applications
HP NonStop SQL/MX Installation and Management Guide—544536-007
11-7
Moving a Program Without Compiled Modules
Steps for Moving to a Production System
These instructions explain how to move a program with its uncompiled module
definitions (either embedded module definitions or module definition files) from a
development system to a production system. After moving the program to the
production system, you must SQL compile the module definitions on the production
system.
Assumptions
For the purpose of the examples, suppose that:
•
Two NonStop server systems, \DEV and \PROD, are connected by an Expand
network. For more information, see the Introduction to Networking for HP NonStop
S-Series Servers.
•
The development node catalogs and schemas are not visible from the production
node and vice versa. To ensure this, do not use the REGISTER CATALOG
statement from either node to create an empty catalog reference on the other
node. For more information, see Using REGISTER CATALOG to Access Objects
on Remote Nodes on page 11-9.
•
The program is a single file named myprog.exe for a C, C++, or COBOL
program. For information about creating a single-file application for deployment,
see the SQL/MX Programming Manual for C and COBOL.
•
The program is in the OSS directory /usr/bin on the development system, and it
will be moved to a directory of the same name on the production system.
Instructions
To move a program without compiled modules to a production system:
1. Copy required program files and executables from a directory on the development
system to an OSS directory on the production system:
°
Issue this OSS command to copy the executable of an embedded SQL
program in C, C++, or COBOL to the production system:
cp /E/DEV/usr/bin/myprog.exe \
/E/PROD/usr/bin/
For a list of the program files required for execution, see the SQL/MX
Programming Manual for C and COBOL.
2. If the application refers to SQL/MP tables or views by using DEFINEs, use the
OSS add_define command or the TACL ADD DEFINE command to set up the
class MAP DEFINEs in the production environment. See Setting DEFINEs on
page 11-11.
Note. If you generated a module definition file (.m), make sure to copy that file to the
production system as well.