TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)
Chapter 3 71
Defining a Database
Set Part
Set Part
The set part of the schema defines data sets. It indicates which data items listed in the
item part belong to which sets and links the master data sets to the detail data sets by
specifying key and search items. In addition, it defines security at the set level and at the
item level within each data set.
Master Data Sets
The set part syntax and parameters for master data sets are provided below.
Syntax
{NAME:
N: }
set name
,{M[ANUAL]
A[UTOMATIC]}[/INDEXED] [(
read class list/write class list
)]
[,
device class
];
{ENTRY:
E: }
item name
[(
path count
)],
.
.
.
item name
;
{CAPACITY:
C: }
maximum capacity
[(
blocking factor
)][,
initial capacity
[,
increment
]];
Parameters
set name is the data set name. It must be a valid TurboIMAGE/XL data name as
described earlier in "Data Sets" in chapter 2 and in the discussion of the
DBUTIL >>CREATE command in chapter 8. A maximum of 199 data sets,
including both masters and details, is allowed.
MANUAL (or M) denotes a manual master data set. Each entry within a manual master
must be created manually and can contain one or more data items.
AUTOMATIC (or A) denotes an automatic master data set. Each data entry within an
automatic master is created automatically by TurboIMAGE/XL and
contains only one data item.
/INDEXED denotes that a B-Tree index is desired for the master data set key item.
read class list is a group of user class numbers between 0 and 63, inclusive, separated by
commas. User class numbers are described in chapter 2.
write class list is a group of user class numbers between 0 and 63, inclusive, separated by
commas. User class numbers are described in chapter 2.
device class is the class name of the MPE/iX device on which the data set resides. The
device must be a member of the volume set on which the database resides.