HP System Dictionary/XL General Reference Manual Vol 1 (32256-90004)

7- 107
Mapping HP SQL Into System Dictionary
The System Dictionary core set supports the HP SQL objects listed below in Figure 7-7. This subsection
provides a description of each of these objects, to show how to define them in the dictionary.
| column |
| table |
| view |
| index |
| DBEFileSet |
| DBEFile |
| module |
| authorization group |
| user |
| owner |
| grants |
| DBEnvironment |
Figure 7-7. HP SQL Objects
Column
A column is an ELEMENT entity. The data type of a column is stored in the element attributes element-
type, byte-length, display-length, and decimal. The HP SQL data types map into System Dictionary core
set data types as follows:
*note1: Pascal string byte length
*note2:
if p is odd: byte-length = (p+1)/2
if p is even: byte-length = (p+2)/2
Table
A table is an HPSQL-TABLE entity. The lock mode of a table is defined in the hpsql-table attribute hpsql-
HP SQL System Dictionary
element-type
element-
type
display-
length
byte-length decimal
CHAR(n) X n n -
VARCHAR(n) S n *note1 -
INTEGER I 10 4 -
SHORTINT I 5 2 -
FLOAT E 27 8 -
DECIMAL(p[,s]) p p *note2 s