User`s guide

9030971 E17 Data Structure of SQL Tables
C-3
SPECTRUM Data Types
Attributes
Attributes
Description: List of attribute descriptions for all attributes
Columns: lh The landscape handle, a 4-byte integer
attrid The attribute ID, a 4-byte integer
attrname The attribute name, a 31-byte string
attrtype The attribute type, a 2-byte integer
groupid The group ID, a 4-byte integer
flags The flags describing the attribute, a 4-byte
integer. The bit flags have the following
values:
01 = EXTERNAL 02 = READABLE
04 = WRITABLE 08 = SHARED
16 = LIST 32 = GUARANTEED
256 = RESERVED 128 = GLOBAL
8192 = PRESERVE_LEGACY_VALUE
Indexed by: lh + attrid+ attrname
Table C-2. Format for Attributes
Landscape
Handle (lh)
Attribute ID
(attrid)
Attribute Name
(attrname)
Attribute
Type
(attrtype)
Group ID
(groupid)
Flags
(flags)
4194304 65562 Packet_Rate 3 0 70
4194304 65563 Soft_Error_Rate 3 0 70
4194304 65564 Hard_Error_Count 3 0 70
… … … … … …
4-byte integer 4-byte integer 31-byte string 2-byte Integer 4-byte
integer
4-byte
integer
ÑÑÑÑÑÑÑÑÑ INDEX ÑÑÑÑÑÑÑÑÑ