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-22
Checking Module Dependencies with DISPLAY USE
OF
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
Display source SQL file for a given module in a given OSS
directory
>>DISPLAY USE OF MODULE_DIR '/usr/user1/all/modulestorage'
SOURCE 'CAT.ALL.MODULE1';
Module: CAT.ALL.MODULE1
Source Name: /E/NODE11/usr/user2/constraint1.sql
Display all modules and their corresponding source SQL
files in a given OSS directory
>>DISPLAY USE OF MODULE_DIR '/usr/user1/all/modulestorage'
SOURCE;
Module: CAT.ALL.MODULE1
Source Name: /E/NODE11/usr/user2/constraint1.sql
Module: CAT.ALL.MODULE2
Source Name: /E/NODE11/usr/user2/constraint2.sql
Display invalid modules from a given directory (along with
their corresponding source SQL files) for a given object
>>DISPLAY USE OF MODULE_DIR ‘/usr/user1/module_storage’ INVALID
MODULES FOR ‘CAT.SCH.TABLE2’;
Object: CAT.SCH.TABLE2
Module: CAT.SCH.MOD1
Source Name: /E/NODE11/modules/mod1.sql
Display all modules from a given directory (along with their
corresponding source SQL files) for a given object
>>DISPLAY USE OF MODULE_DIR ‘/usr/user1/module_storage’ ALL
MODULES FOR ‘CAT.SCH.TABLE2’;
Object: CAT.SCH.TABLE2
Module: CAT.SCH.MOD123
Source Name: /E/NODE11/modules/mod123.sql