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

MXCI Commands
HP NonStop SQL/MX Reference Manual—540440-003
4-83
Examples of SHOWLABEL
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
SecurityTimestamp: 29 Feb, 2004 20:31:24 ( 211944875484152346
)
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
Index Levels: 0
Record Expression Label Length: 9168
Security Label Length: 120
Key Columns: 0 ASC
Partitioning Scheme: RP
Partition Array - 3 partition[s]
Partition[0]: \CARNAG.$CHINA.ZSDQHSJZ.RGCX9K00
Low Key: ( -2147483648 )
Partition[1]: \CARNAG.$KEMPO.ZSDQHSJZ.N9HX9K00