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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-84
Examples of SHOWLABEL
Low Key: ( 20 )
Partition[2]: \CARNAG.$LORI.ZSDQHSJZ.HMNX9K00
Low Key: ( 40 )
IndexMap Array - 2 index[es]
Index[0]: \CARNAG.$BLANCA.ZSDQHSJZ.JH8TCM00
Index columns: 1 ASC , 0 ASC
Index[1]: \CARNAG.$BLANCA.ZSDQHSJZ.W7DJ2M00
Index columns: 0 ASC , 1 ASC , 0 ASC
Trigger Status Array - 2 trigger[s]
Trigger[0]: trigger created (ID): 211944875578177762
Status: ENABLED
Trigger[1]: trigger created (ID): 211944875658652063
Status: ENABLED
=============================================================
•
Use the SHOWLABEL command with a physical location (Guardian) name:
>>showlabel \CARNAG.$CHINA.ZSDQHSJZ.RGCX9K00;
=============================================================
GuardianName: \CARNAG.$CHINA.ZSDQHSJZ.RGCX9K00
AnsiName: MOD107.SCH.TAB1
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Owner: QADEV.TEG
RedefTimestamp: 29 Feb, 2004 20:34:18 ( 211944875658652063
)
CreationTimeStamp: 29 Feb, 2004 20:31:24 ( 211944875484237505
)
LastModTimestamp: 29 Feb, 2004 20:31:24 ( 211944875484237505
)
LastOpenTimeStamp: NEVER OPENED
SMDtable: F
File Organization: Key-sequenced
Block Length: 4096
File Code: 550
AuditCompress: T
Audited: T (If F, a Utility operation is in progress or has
failed)
Broken: F
Buffered: T
ClearOnPurge: F
Corrupt: F (If T, a Utility operation is in progress or has
failed)
CrashLabel: F
CrashOpen: F