SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Utilities
HP NonStop SQL/MX Reference Manual—540440-003
5-40
INFO Operation
INFO Operation
Considerations for INFO
Examples of INFO
INFO is an OSS command-line utility run from mxtool that displays information about
SQL/MX files. INFO displays the Guardian file name, the ANSI name, the ANSI
namespace, and the object schema version.
[node.]\$volume.subvol.filename
is the Guardian qualified file set list that specifies the set of Guardian files that is
being queried. It must be fully qualified with the volume and subvolume name. If
you specify \node, it must be the local node.
In this four-part name, node is the name of a node of a NonStop server, $volume
is the name of a disk volume, subvol is the name of a subvolume that begins with
the letters ZSD, and filename is the automatically generated name of a Guardian
table that ends with “00” or “01” (zero zero or zero one).
You can use the “*” Guardian wild card in the volume, subvolume, and file name.
Considerations for INFO
Security Considerations
Any user can perform the INFO command.
To perform INFO on files on other nodes, the remote system must be available.
If INFO tries to access objects that have a schema version that is greater than the
NonStop SQL/MX software version (MXV) of the local node, you receive a versioning
error.
Other Considerations
Use INFO to request specific SQL/MX information for a Guardian file name without
writing queries against metadata. Use INFO to obtain this information if metadata is
unavailable.
You can also use the SHOWLABEL command to get more information on a Guardian
file. See SHOWLABEL Command on page 4-78 for more information.
This information is displayed:
•
The ANSI name
•
The ANSI namespace, including table namespace (which includes views and
stored procedures), index namespace, and trigger namespace
INFO [\node.]\$volume.subvol.filename