SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-11
Examples of DISPLAY USE OF
Module: CAT.SCH.CURSOMEM
Object: \NODE1.$DATA08.ORDERS.T071CH
Object: \NODE1.$DATA08.ORDERS.T071M
Object: \NODE1.$DATA08.ORDERS.T071S
Object: \NODE1.$DATA08.ORDERS.T071T
Object: \NODE1.$DATA08.ORDERS.T071U
Module: CAT.SCH.TESTE001M
Table: \NODE1.$DATA08.ORDERS.RSWORKS
...
(and so on for all modules).
•
Display objects for all modules matching wild card “c*M”:
>>display use of module 'CAT.*.c*M';
Module: CAT.SCH.constraintM
Index: \NODE1.$DATA08.ORDERS.TI(CAT.SCH.T)
Table: CAT.SCH.T
Module: CAT.SCH.cursomeM
Table: \NODE1.$DATA08.ORDERS.T071CH
Table: \NODE1.$DATA08.ORDERS.T071M
Table: \NODE1.$DATA08.ORDERS.T071S
Table: \NODE1.$DATA08.ORDERS.T071T
Table: \NODE1.$DATA08.ORDERS.T071U
•
Display use of a specified Guardian object in all modules:
>>display use of object '\NODE1.$DATA08.ORDERS.T1';
Object: \NODE1.$DATA08.ORDERS.T1
Object: \NODE1.$DATA08.ORDERS.T1 Module:
TANDEM_SYSTEM_NSK.SCH.INS1M
Object: \NODE1.$DATA08.ORDERS.T1 Module:
TANDEM_SYSTEM_NSK.SCH.MULTCURM
Object: \NODE1.$DATA08.ORDERS.T1 Module:
TANDEM_SYSTEM_NSK.SCH.MULTIM
Object: \NODE1.$DATA08.ORDERS.T1 Module:
TANDEM_SYSTEM_NSK.SCH.STRUCTM Table: \NODE1.$DATA08.ORDERS.T1
Module: TANDEM_SYSTEM_NSK.SCH.T1INDM
Object: \NODE1.$DATA08.ORDERS.T1 Module:
TANDEM_SYSTEM_NSK.SCH.T1ROWSM
•
Display use of a specified SQL/MP alias objects in specified modules:
>>display use of module 'CAT.SCH.*' object 'CAT.SCH.T';
Object: CAT.SCH.T
Table: CAT.SCH.T Module: CAT.SCH.CONSTRAINTM
•
Display modules that could not be loaded:
>>display use of object '\NODE1.$DATA08.ORDERS.T1';
Object: \NODE1.$DATA08.ORDERS.T11