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-20
Checking Module Dependencies with DISPLAY USE
OF
For a description of SQL/MX DISPLAY USE OF command syntax, see SQL/MX
Reference Manual.
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).