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-25
Grouping Applications and Modules to Run Multiple
DISPLAY USE OF Operations
% mxCompileUserModule t11.exe
% mxCompileUserModule t12.exe
6. Check the SQL compiled module files using INVENTORYAPP:
% ls /usr/tandem/sqlmx/USERMODULES/*INVENTORYAPP^*^^
/usr/tandem/sqlmx/USERMODULES/T01CAT.T01SCH.INVENTORYAPP^T01MOD^^
/usr/tandem/sqlmx/USERMODULES/T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
/usr/tandem/sqlmx/USERMODULES/T01CAT.T01SCH.INVENTORYAPP^T03MOD^^
7. Check the SQL compiled module files using SHIPMENTAPP:
% ls /usr/tandem/sqlmx/USERMODULES/*SHIPMENTAPP^*^^
/usr/tandem/sqlmx/USERMODULES/T01CAT.T01SCH.SHIPMENTAPP^T11MO
D^^
/usr/tandem/sqlmx/USERMODULES/T01CAT.T01SCH.SHIPMENTAPP^T12MO
D^^
8. Use DISPLAY USE OF to display the modules and SQL/MX objects used by the
inventory applications:
>>display use of module '*.*.INVENTORYAPP^*^^';
Module: T01CAT.T01SCH.INVENTORYAPP^T01MOD^^
Table: T01CAT.T01SCH.T01TBL
Module: T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
Table: T01CAT.T01SCH.T01TBL
Module: T01CAT.T01SCH.INVENTORYAPP^T03MOD^^
Table: T01CAT.T01SCH.T01TBL
9. Use DISPLAY USE OF to display the modules and SQL/MX objects used by the
shipment applications:
>>display use of module '*.*.SHIPMENTAPP^*^^';
Module: T01CAT.T01SCH.SHIPMENTAPP^T11MOD^^
Table: T01CAT.T01SCH.T02TBL
Module: T01CAT.T01SCH.SHIPMENTAPP^T12MOD^^
Table: T01CAT.T01SCH.T02TBL
If you used a local directory to store SQL compiled modules by using the
mxCompileUserModule option -g moduleLocal, the display would be:
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal
t01.exe
/G/system/system/mxcmp -g moduleLocal=.
/tmp/aaafGadUa66047AAEGDA
Hewlett-Packard NonStop(TM) SQL/MX Compiler 2.1
(c) Copyright 2005 Hewlett-Packard Development Company, LP.
/tmp/aaafGadUa66047AAEGDA
(./T01CAT.T01SCH.INVENTORYAPP^T01MOD^^)
0 errors, 0 warnings, 0 statements affected; 9 statements
total