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

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-14
Examples of DISPLAY USE OF Source
You can search for similar values by specifying only part of the characters of
module-name combined with the “*” (asterisk) wild-card characters.
If you omit the module clause, DISPLAY USE OF will search for all modules.
All of these specifications are valid:
module 'CAT.SCH.M1'
module 'CAT.sch.*'
module 'CAT.*.*M'
Examples of DISPLAY USE OF Source
•
Display all modules and their corresponding source SQL files:
>>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
•
Display source SQL files for all modules matching wild card “c*M”:
>>display use of source 'CAT.*.c*M';
Module: CAT.SCH.constraintM
Source Name: /E/NODE11/usr/user2/constraint.sql
Module: CAT.SCH.cursomeM
Source Name: /E/NODE2/customer.sql
>>display use of module_dir '/usr/user1/all/modulestorage'
source 'CAT.ALL.MODULE1';
Module: CAT.ALL.MODULE1
Source Name: /E/NODE11/usr/user2/constraint.sql
Note. If you do not specify the module-name, the command displays the source SQL file
name for all the modules.