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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-78
SHOWLABEL Command
SHOWLABEL Command
Considerations for SHOWLABEL
Examples of SHOWLABEL
The SHOWLABEL command displays file-label information for SQL/MX objects. This
information includes the object version, physical location, and other characteristics.
Supported objects are tables, trigger temporary tables, views, and indexes.
SHOWLABEL is an SQL/MX extension.
namespace
specifies the namespace in which the object name is to be searched. If no
namespace is specified, the table namespace is used as the default namespace.
object-name
specifies the ANSI name of a table, worktable, or index. This must be an SQL/MX
object name because SQL/MP objects and SQL/MP aliases are not supported. If a
catalog name and schema are not specified when using an ANSI name,
SHOWLABEL uses the default catalog and schema.
location-name
specifies the Guardian physical location of an SQL/MX object. The location name
must be the data fork of an SQL/MX object (files that end in “00” and exist in
subvolumes beginning with the letters ZSD). SQL/MP objects are not supported.
\node is the name of a node on a NonStop system, $volume is the name of a
disk volume, subvol is the name of a subvolume, and filename is the name of a
Guardian disk file. If the physical name is not fully qualified, it is expanded by using
the current default node, volume, and subvolume.
DETAIL
specifies the display of additional information about:
•
Security
•
Key columns
•
Partitions
SHOWLABEL {[namespace ] object-name | location-name }
[, DETAIL ]
namespace is:
TABLE
| INDEX
object-name is: [catalog.][schema.]name
location-name is: [\node.]$volume.subvol.filename