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-26
Grouping Applications and Modules to Run Multiple
DISPLAY USE OF Operations
1 modules found, 1 modules extracted.
1 mxcmp invocations: 1 succeeded, 0 failed.
10. Perform Step 9 for the remainder of the applications:
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t02.exe
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t03.exe
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t11.exe
% /user/smith/tmp/tmp/DUO: mxCompileUserModule -g moduleLocal t12.exe
11. Verify how the local modules are generated:
/user/smith/tmp/tmp/DUO: ls -l *.*.INVENTORYAPP^*^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:00
T01CAT.T01SCH.INVENTORYAPP^T01MOD^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:00
T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:00
T01CAT.T01SCH.INVENTORYAPP^T03MOD^^
/user/smith/tmp/tmp/DUO: ls -l *.*.SHIPMENTAPP^*^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:02
T01CAT.T01SCH.SHIPMENTAPP^T11MOD^^
-rw-rw---- 1 JAVAQA.MODMAN JAVAQA 48293 Nov 29 14:02
T01CAT.T01SCH.SHIPMENTAPP^T12MOD^^
12. Use DISPLAY USE OF to search for the local modules:
>>display use of module_dir '/user/smith/tmp/tmp/DUO' 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
13. You can also display the modules in local directories that use the specified SQL
object:
>>display use of module_dir '/user/smith/tmp/tmp/DUO' object
'T01CAT.T01SCH.T01TBL';
Object: T01CAT.T01SCH.T01TBL
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T01MOD^^
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T02MOD^^
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T03MOD^^
14. You can further limit the modules that can be searched:
>>display use of module_dir '/user/ychang/tmp/tmp/DUO' module
'T01CAT.T01SCH.INVENTORYAPP^T02MOD^^' object 'T01CAT.T01SCH.T01TBL';
Object: T01CAT.T01SCH.T01TBL
Object: T01CAT.T01SCH.T01TBL Module: T01CAT.T01SCH.INVENTORYAPP^T02MOD^^