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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-81
Examples of SHOWLABEL
SHOWLABEL, DETAIL Output
SHOWLABEL, DETAIL returns the SHOWLABEL output and some additional
information. This table describes the additional information that SHOWLABEL, DETAIL
provides. For actual output values, see the examples that follow:
Examples of SHOWLABEL
•
Use the SHOWLABEL command with an object (ANSI) name:
>>showlabel tab1;
=============================================================
GuardianName: \CARNAG.$CHINA.ZSDQHSJZ.RGCX9K00
AnsiName: MOD107.SCH.TAB1
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Max Extents Maximum number of extents.
EOF The relative byte address of the first byte of the next
available block.
Extents Allocated Number of extents currently allocated for the file.
Index Levels Number of index levels used for index blocks.
Record Expression Label
Length
Length of the Record Expression label.
Security Label Length Length of the Security label.
Key Columns Column number and order of key columns. If the primary
key and store by key are not the same,
NonStop SQL/MX displays the SYSKEY after the key
columns.
Partitioning Scheme Scheme used for partitioning (for example, RP).
Low Key Specifies the first partitioning key value that can be
stored in the associated partition. Specifies the lowest
value for the partition if the column for the value has an
ascending order. Specifies the highest value for the
partition if the column has a descending order. This
information is displayed only for objects that are range
partitioned.
ID ID of the trigger. The timestamp indicating when the
trigger was created.
status Indicates whether the trigger is enabled or disabled.