SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-10
Considerations for DISPLAY USE OF
You can look 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.
These are all valid specifications:
module 'CAT.SCH.M1'
module 'CAT.sch.*'
module 'CAT.*.*M'
object-name
is the fully qualified name of an object, such as a table or index name in SQL/MP
alias name or Guardian format, enclosed in single quotes. object-name can be
an SQL/MX object (tables, indexes, and SQL/MP aliases) or an SQL/MP object
(tables and indexes.) The node is required for SQL/MP objects.
object-name is case-sensitive. Wild-card characters are not allowed.
These are valid specifications:
object 'TPCC.OE.CUSTOMER'
object '\SAMDBCAT.$PERSNL.EMPLOYEE.SALARY'
If you omit the 'object object-name' clause, DISPLAY USE OF searches all
objects (tables and indexes) in the matching modules.
Considerations for DISPLAY USE OF
DISPLAY USE OF tracks dependencies between these types of objects when they are
used in conjunction with a static embedded SQL application written in either C, C++,
COBOL or Java:
•
Compiled modules produced by the SQL/MX compiler
•
SQL/MX objects: tables, indexes, and SQL/MP aliases
•
SQL/MP objects: tables, and indexes
Information about the dependencies between these object types is derived from the
Explain section of the compiled module.
If the module could not be loaded because the module name is not valid or the module
name is valid but has been corrupted, NonStop SQL/MX displays an error. If the
module could not be loaded because the name is valid but the module cannot be
found, NonStop SQL/MX displays a warning.
Examples of DISPLAY USE OF
•
Display all modules and dependent objects:
>>display use of;
Module: CAT.SCH.CONSTRAINTM
Index: \NODE1.$DATA08.ORDERS.TI(CAT.SCH.T)
Object: CAT.SCH.T