SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Querying SQL/MX Metadata
HP NonStop SQL/MX Installation and Management Guide—523723-004
8-2
Commands for Displaying Information
NonStop SQL/MX stores information about object structures in file labels, resource
forks, and metadata, as follows:
Commands for Displaying Information
Topics in this subsection:
•
DISPLAY USE OF Command on page 8-2
•
mxtool INFO Command on page 8-3
•
SHOWLABEL Command on page 8-3
•
mxtool VERIFY command on page 8-3
•
SHOWDDL Command on page 8-4
DISPLAY USE OF Command
Use the MXCI DISPLAY USE OF command to display a list of modules and, for each
module, to display a list of dependent objects (tables and indexes) that are used by the
module. This command is especially useful for assessing the impact of DDL changes
on module files before the changes are performed.
By using the wild-card character (*), you can obtain information for a single module file
or for a set of module files.
This command has no impact during the execution of SQL queries.
File labels Contain file structure information and security settings. Use the
MXCI SHOWLABEL command to obtain file-label information.
Most of the information in file labels is the same as the metadata.
Resource forks Are label extensions that contain SQL/MX information that is not
available in the label or is too large to fit into a standard file label.
The resource fork name is derived from the SQL/MX object's
Guardian file name. Use the MXCI SHOWLABEL command to
obtain the Guardian file name. Most of the information in resource
forks is the same as the metadata.
Metadata Contain a description of all objects in a database. This information
includes the object type (for example, table or view) and object
attributes (for example, partitioning scheme and redefinition time),
and ownership information. To obtain metadata information, use
one or both of these methods:
•
Use the MXCI SHOWDDL command.
•
Use SELECT statements, as described in this section, to query the
metadata.
Note. Because this command uses Explain output, set the control query default
GENERATE_EXPLAIN to ON before using the DISPLAY USE OF command.