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-21
Checking Module Dependencies with DISPLAY USE
OF
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
Display source SQL file name for a given module
>>DISPLAY USE OF SOURCE 'CAT.ALL.MODULE1';
Module: CAT.ALL.MODULE1
Source Name: /E/NODE11/usr/user2/constraint.sql
Display 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
Display all modules and their corresponding source SQL file
names associated with an object
>>DISPLAY USE OF ALL MODULES FOR ‘CAT.SCH.TABLE1;
Object: CAT.SCH.TABLE1
Module: CAT.SCH.MODTABLE1
Source Name: /E/NODE11/modulelist/module1.sql
Module: CAT.SCH.MODTABLE3
Source Name: /E/NODE11/modulelist/module3.sql
Display all the invalid modules and their corresponding
source SQL filenames associated with an object
>>DISPLAY USE OF INVALID MODULES FOR ‘CAT.SCH.TABLE1’;