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-21
Checking Module Dependencies with 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
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’;
Object: CAT.SCH.TABLE1
Module: CAT.SCH.MODTABLE1
Source Name: /E/NODE11/modulelist/module1.sql
Module: CAT.SCH.MODTABLE2
Source Name: /E/NODE11/modulelist/module2.sql