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

MXCI Commands
HP NonStop SQL/MX Reference Manual—544517-008
4-13
DISPLAY USE OF SOURCE
DISPLAY USE OF SOURCE
Examples of DISPLAY USE OF Source
The DISPLAY USE OF SOURCE Command displays the source SQL file (from which
the module was created) for the given module.The syntax and utility of the new
enhancement is as follows
NOE
directs NonStop SQL/MX to scan modules only in the local node and not the nodes
on the Expand network.
module-directory-path
is the path name of a directory, enclosed in single quotes.
module-directory-path is case-sensitive.
If you omit the module_dir clause, DISPLAY USE OF SOURCE searches the
default path, /usr/tandem/sqlmx/USERMODULES.
You can search for similar values by specifying only part of the characters of
module-directory-path combined with “*” (asterisk) wild-card characters.
All these specifications are valid:
[module_dir 'd1']
[module_dir './d1']
[module_dir '../d1']
[module_dir '/usr/tandem/sqlmx/USERMODULES/../d1']
[module_dir '*']
[module_dir '/*']
[module_dir '*/d1']
[module_dir '/*/d1']
[module_dir 'd1/*']
[module_dir '/d1/*']
module-name
is the name of the module to search for, enclosed in single quotes. NonStop
SQL/MX searches all modules matching the pattern in
/usr/tandem/sqlmx/USERMODULES or in the directory specified with module_dir.
module-name is case-sensitive.
DISPLAY USE OF [NOE] [MODULE_DIR 'module-directory-path']
SOURCE ['module-name']
Note. The current DISPLAY USE OF command does not support module names to be
searched inside the guardian location (that is, path names starting with /G/). Similarly, this
command does not support the modules to be searched inside the guardian location.