SQL/MX 3.1 Installation and Management Guide (H06.23+, J06.12+)

Managing Database Applications
HP NonStop SQL/MX Release 3.1 Installation and Management Guide—663852-001
11-20
Checking Module Dependencies with DISPLAY USE
OF
Displaying All Modules and Dependent Objects
When you omit the module clause and the object clause, DISPLAY USE OF returns
information about all modules and dependent objects.
>>DISPLAY USE OF;
Module: CAT.SCH.CONSTRAINTM
Object: CAT.SCH.T24
Object: CAT.SCH.T25
Object: CAT.SCH.T26
Object: CAT.SCH.T27
Object: CAT.SCH.T28
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
Display all modules and their corresponding source SQL file
names
>>DISPLAY USE OF SOURCE;
Module: CAT.SCH.CONSTRAINTM
Source Name: /E/NODE1/usr/user1/file1.sql
Module: CAT.SCH.CURSOMEM
Source Name: /E/NODE2/usr/user1/file2.sql
Module: CAT.SCH.TESTE001M
Source Name: /E/NODE1/usr/user2/file3.sql
(And so on for all modules).
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';