SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Managing Database Applications
HP NonStop SQL/MX Installation and Management Guide—523723-004
11-21
Checking Module Dependencies With DISPLAY
USE OF
Module: CAT.SCH.CURSOMEM
Object: \NODE1.DATA10.ORDERS.T01
Object: CAT.SCH.T02
Object: CAT.SCH.T03
Object: CAT.SCH.T04
Module: CAT.SCH.TESTMEM
Object: CAT.SCH.T15
Object: CAT.SCH.T16
Object: CAT.SCH.T17
Object: CAT.SCH.T18
Displaying Dependent Objects for One or More Specified
Modules
When you specify the module name and omit the object clause, DISPLAY USE OF
returns information about a specific module and all its dependent objects.
>>DISPLAY USE OF module 'CAT.SCH.CONSTRAINTM';
Module: CAT.SCH.CONSTRAINTM
Object: CAT.SCH.T24
Object: CAT.SCH.T25
Object: CAT.SCH.T26
Object: CAT.SCH.T27
Object: CAT.SCH.T28
Displaying All Modules Dependent on a Specific Object
DISPLAY USE OF returns information about all modules associated with a specific
object when you omit the module clause and specify the object name.
>>DISPLAY USE OF object 'CAT.SCH.T24';
Object:CAT.SCH.T24 Module:
CAT.SCH.CONSTRAINTM
Displaying the Modules in a Local Directory
DISPLAY USE OF returns information about the modules in a local OSS directory
when you specify the directory with the MODULE_DIR clause.
DISPLAY USE OF MODULE_DIR '/usr/myapp' MODULE 'cat.sch.t24';
You must specify the fully qualified OSS directory path of a locally placed module.
Otherwise, an error occurs. The local directory is searched for modules matching the
pattern you specified in the MODULE_DIR clause. If modules that match the pattern