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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-79
Considerations for SHOWLABEL
•
Indexes
•
Triggers
Considerations for SHOWLABEL
Every SQL object includes a logical file label to store the object’s file attributes and
information about its dependent objects. The resource fork is a new file that contains
structural descriptions of a table. When an SQL/MX object is created, two physical files
are instantiated: the data fork and the resource fork. The data fork is where the user
data resides. The resource fork contains structural information, such as the partition
map.
•
You can use SHOWLABEL only within an MXCI session.
•
SHOWLABEL does not support stored procedures, SQL/MP objects, or SQL/MP
aliases.
•
SHOWLABEL displays all output in the English (ISO88591) character set only.
•
SHOWLABEL requires that TMF, NonStop SQL/MX, and MXCI be available and
running on the system.
SHOWLABEL Output
This table describes SHOWLABEL output. For actual output values, see the examples
that follow.
AnsiName ANSI name of the object.
AnsiNameSpace Namespace in which the object exists (TA, IX, and so
on).
GuardianName Physical location name of the object
Version The high level SQL version that was running when the
object was created.
ObjectSchemaVersion The schema version of the object’s schema. It is
assigned when the object is created and changes when
the schema is upgraded or downgraded.
ObjectFeatureVersion The feature version that describes features used by the
database object. Can change as features are added or
removed from an object as the result of DDL or utility
operations.
Owner The name of the object’s owner.
RedefTimestamp Date, time, and Julian timestamp indicating when the
object’s definition was last modified.
CreationTimeStamp Date, time, and Julian timestamp indicating when the
object was created.