SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-17
Examples of ALL | INVALID MODULES
Examples of ALL | INVALID MODULES
•
Display invalid modules along with their corresponding source SQL files for a given
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
•
Display invalid modules along with their corresponding source SQL files for a given
object when the search directory (where the modules need to be searched) is
specified
>>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 along with their corresponding source SQL files for a given
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
Object: CAT.SCH.TABLE1
Module: CAT.SCH.MODTABLE3
Source Name: /E/NODE11/modulelist/module3.sql
•
Display all modules along with their corresponding source SQL files for a given
object when the search directory (module_dir) is specified:
>>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