TurboIMAGE/XL Database Management System Reference Manual (30391-90012)

74 Chapter3
Defining a Database
Set Part
performance of TurboIMAGE/XL.
NOTE For existing databases, use DBChange Plus or a third-party utility to specify
the expansion parameters.
Detail Data Sets
The set part syntax and parameters for detail data sets are provided below.
Syntax
{NAME:
N: } set name , D[ETAIL]][( read class list/write class list )][, device class ];
{ENTRY:
E: } item name [([!] master set name [ (sort item name) ])],
.
.
.
item name [( master set name [( sort 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
defined in "Data Sets" in chapter 2 and in the discussion of the DBUTIL
>>CREATE command in chapter 8. A maximum of 240 data sets, including
both masters and details, is allowed.
DETAIL (or D) denotes a detail data set.
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.
item name is the name of a data item defined in the item part. Each item defined as a
search item must be a simple item. Up to 16 items can be search items.
(Refer to master set name for more information about search items.)
! (exclamation point) denotes a primary path. Only one path in each detail data set can be
designated as a primary path. If no path is designated as primary, the first
unsorted path is the primary path by default. If all of the paths are sorted,
the default primary path is the first sorted path.
master set name is the name of a previously defined master data set. When a master set
name follows an item name, the data item is a search item linking the
detail set to the named master. Up to 16 search items can be defined for a