SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

MXCI Commands
HP NonStop SQL/MX Reference Manual—523725-004
4-87
Examples of SHOWLABEL
•
Use the SHOWLABEL, DETAIL command with a physical location (Guardian)
name on a table with a SYSKEY:
>>showlabel $FL0115.ZSDJNQHX.Z91KC400,detail;
=============================================================
GuardianName: \BERT.$FL0115.ZSDJNQHX.Z91KC400
AnsiName: TESTCAT.TESTSCH.Y4
AnsiNameSpace: TA
ObjectSchemaVersion: 1200
ObjectFeatureVersion: 1200
Owner: QADEV.TEG
RedefTimestamp: 23 Nov, 2004 07:28:40 (
211967983720864326 )
CreationTimeStamp: 23 Nov, 2004 07:28:45 (
211967983725720055 )
LastModTimestamp: 23 Nov, 2004 07:28:45 (
211967983725720055 )
LastOpenTimeStamp: NEVER OPENED
SecurityTimestamp: 23 Nov, 2004 07:28:40 (
211967983720864326 )
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
IncompletePartBoundChg: F (If T, a Utility operation
is in progress or has failed)
RedoNeeded: F
RollfwdNeeded: F
UndoNeeded: F
UnreclaimedSpace: F (If T, a Utility operation is in
progress or has failed)
Primary Extent Size: 16 Pages
Secondary Extent Size: 64 Pages
Max Extents: 160
Extents Allocated: 0
EOF: 0