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-24
Grouping Applications and Modules to Run Multiple
DISPLAY USE OF Operations
The INVENTORYAPP applications access the SQL/MX table
T01CAT.T01SCH.T01TBL. The SHIPMENTAPP applications access the SQL/MX table
T01CAT.T01SCH.T02TBL.
1. Precompile the applications to the group INVENTORYAPP:
/user/smith/tmp/tmp/DUO: mxsqlc t01.sql -g
moduleGroup=INVENTORYAPP
Hewlett-Packard NonStop(TM) SQL/MX C/C++ Preprocessor 2.1
(c) Copyright 2005 Hewlett-Packard Development Company, LP.
----- End of File Processing Checks -----
0 errors, 0 warnings in SQL C file
"/user/smith/tmp/tmp/DUO/t01.sql"
2. Repeat Step 1 for t02.sql and t03.sql:
% mxsqlc t02.sql -g moduleGroup=INVENTORYAPP
% mxsqlc t03.sql -g moduleGroup=INVENTORYAPP
3. Process the applications to generate annotated application executables, referring
to the SQL/MX Programming Manual for C and COBOL for details. The annotated
executables should look like this after the C preprocessor, compiler, and linker
have run:
t01.sql -> t01.exe
t02.sql -> t02.exe
t03.sql -> t03.exe
t11.sql -> t11.exe
t21.sql -> t21.exe
4. SQL compile the annotated applications using mxCompileUserModule. In this
example, SQL compiled modules are placed in the
/usr/tandem/sqlmx/USERMODULES directory. Also, the SQL compiled module
name contains the module string that was used.
/user/smith/tmp/tmp/DUO: mxCompileUserModule t01.exe
/G/system/system/mxcmp /tmp/aaaRGadYa66447AGJBBB
Hewlett-Packard NonStop(TM) SQL/MX Compiler 2.1
(c) Copyright 2005 Hewlett-Packard Development Company, LP.
/tmp/aaaRGadYa66447AGJBBB
(/usr/tandem/sqlmx/USERMODULES/T01CAT.T01SCH.INVENTORYAPP^T01
MOD^^)
0 errors, 0 warnings, 0 statements affected; 9 statements
total
1 modules found, 1 modules extracted.
1 mxcmp invocations: 1 succeeded, 0 failed.
5. Perform SQL compilation on the other executables:
% mxCompileUserModule t02.exe
% mxCompileUserModule t03.exe