SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

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
% 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 Embedded Module Compile Utility 3.0
(c) Copyright 2003, 2004-2010 Hewlett-Packard Development Company, LP.
/tmp/aaafGadUa66047AAEGDA
(./T01CAT.T01SCH.INVENTORYAPP^T01MOD^^)
0 errors, 0 warnings, 0 statements affected; 9 statements
total
1 modules found, 1 modules extracted.
1 mxcmp invocations: 1 succeeded, 0 failed.
10. Perform Step 9 for the remainder of the applications:
230 Managing Database Applications