User`s guide

9030971 E17 Data Structure of SQL Tables
C-13
SPECTRUM Data Types
Statistics
List Attribute Format
Columns: ts The time stamp, a date field
lh The landscape handle, a 4-byte integer
mh The model handle, a 4-byte integer
attrid Attribute ID, a hex value
inst Instance ID, a varying length character field
attrval Attribute value, a varying length character field*
Indexed by: ts + lh + mh
* Maximum possible length is 1024 for Oracle, 255 for Sybase and Microsoft
SQL Server, and 512 for Ingres.
Table C-11. Format for Statistics (List Attribute Format)
Time Stamp
(ts)
Landscape
Handle
(lh)
Model
Handle
(mh)
Attribute
ID
(attrid)
Instance ID
(inst)
Attribute Value
(attrval)
15-April-1998
15:10:12
4194304 10485760 852498 01 17451 .... 7373
15-April-1998
15:10:12
4194304 10485761 852107 02 17610 .... 7518
15-April-1998
15:10:12
4194304 10485760 852134 03 17714 .... 7664
15-April-1998
15:10:12
4194304 10485762 852102 04 17864 .... 7814
date 4-byte
integer
4-byte integer hex value varying length
character Þeld*
varying length
character Þeld*
ÑÑÑÑÑÑ I N D E X ÑÑÐÑÑÑÑ
Table C-12. Attribute Types
Attribute Type Field Type
1 Integer Boolean (0=FALSE)
2 Short
3 Integer (signed and unsigned)
4 Integer