HP System Dictionary/XL General Reference Manual Vol 1 (32256-90004)
7- 108
lock-mode.
For each table there should be a RECORD entity occurrence that defines the record layout of that table.
The record layout consists of the columns (elements) of that table, which is defined with the RECORD
contains ELEMENT relationship type. You should specify a byte offset for the relative position of that
element within that record. The record should be related to the HPSQL-TABLE entity occurrence that it
describes. This relationship is established with the HPSQL-TABLE contains RECORD relationship type.
Typically, only one record is related to a table to define a table record layout. However, you have the
flexibility of defining more than one record layout for a table entity. Each table can have one primary
record layout which is indicated with the hpsql-table contains record relationship type attribute primary-
record. The NOT NULL specification for a column is defined in the attribute not-null of the record
contains element relationship type, where the record is the primary record of the table.
The HPDBE-FILESET contains HPSQL-TABLE relationship type defines where the rows of the table are
stored.
View
A view is an HPSQL-VIEW entity. The variable length attribute hpsql-select-command defines the select
command from which the view is derived.
For each view there should be a RECORD entity occurrence that defines the record layout of that view. The record
layout consists of the columns (elements) of that view, which is defined with the RECORD contains ELEMENT
relationship type. You should specify a byte offset for the relative position of that element within that record. The
record should be related to the hpsql-view entity occurrence that it describes. This relationship is established with
the HPSQL-VIEW contains RECORD relationship type. Typically, only one record is related to a view to define
a view record layout. However, you have the flexibility of defining more than one record layout for a view entity.
Each view can have one primary record layout which is indicated with the HPSQL-VIEW contains RECORD re-
lationship attribute primary-record.
Index
An index is an HPSQL-INDEX entity. To define the columns of the index, use the HPSQL-INDEX contains
ELEMENT relationship type. That is, relate each element (column), in the order they appear in the index,
to the index entity occurrence. Relate the index occurrence to the table that it is an index of with the
HPSQL-TABLE key HPSQL-INDEX relationship type. Attributes of the hpsql-table key hpsql-index
relationship type include hpsql-clustering to indicate whether clustering is specified for the index and
unique to specify if index values must be unique.
DBEfileset and DBEfile
A DBEFileSet is an HPDBE-FILESET entity. A DBEFile is an HPDBE-FILE entity with attributes
hpdbe-file-type to define the DBEFile type and hpdbe-pages to define the number of pages in the DBEFile.
The relationship type HPDBE-FILESET contains HPDBE-FILE defines the DBEFiles that belong to a
DBEFileSet. The relationship type HPDBE-FILE contains FILE defines the system file name by which
the DBEFile is known to MPE.
Module
A module is a module entity.
Authorization Groups and Users
An Authorization Group and an HP SQL user are an HPSQL-AUTH-NAME entity with the attribute