TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

Chapter 11 495
B-Tree Indices
External Commands and Utilities Affected
the master data set key value. No pointer information is present in the B-Tree index
records.
d. The KSAM file has the Native Language Support language specified to match the
language of the database, if the key is a text (X or U) data type.
• Record zero of the root file contains "C4" for the root file version if at least one B-Tree
index file exists for the database. When all B-Tree indices are dropped, it reverts to the
appropriate version: "C3" if at least one jumbo set exists, "C2" otherwise.
• A new bit map is added in the root file for B-Tree indices.
• Third-party indices can coexist with B-Tree indices, that is, on the same item of the
data set.
External Commands and Utilities Affected
The root file, utilities, and intrinsics affected by the implementation of B-Tree index files
include the following:
• Root file
• DBSCHEMA
• DBUTIL
• DBCONTROL
• DBFIND
• DBGET
• DBINFO
• DBPUT
• DBDELETE
• DBUPDATE
Root File
The root file version level will be "C4" if at least one master data set has a B-Tree index. If
there are no B-Tree indices, the root file version will be "C3" if any jumbo data sets exist,
and "C2" otherwise. In other words, a value greater than "C2" indicates that at least one
POSIX named file exists as part of the database.
DBSCHEMA
DBSCHEMA has an INDEXED option added to the data set NAME specification.
New Syntax for DBSCHEMA
NAME: setname , { M[ANUAL]
A[UTOMATIC]} [/INDEXED] [( read class list )/( write class list )]
[,
device class ];