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

Chapter 11 509
B-Tree Indices
External Commands and Utilities Affected
NOTE General use of privileged mode can seriously damage your system, if not used
wisely.
Mode 13
Mode 13 is used to perform functions related to B-Tree index files. The caller must be
privileged. Exclusive database access is required for adding, dropping, and rebuilding
B-Tree index, that is functions 1, 2, and 3. Qualifier has a structured record containing
data set information and directives. This is the qualifier layout (an element is 16-bits):
Element Contents
1 Function code:
0 mode 13 inquiry (returns "OK" in status indicating mode
13 is a valid mode for the TurboIMAGE/XL version on the
system. It also means that the B-Tree index feature is
available in the version of TurboIMAGE/XL. Ignores the
rest of the record).
1 add B-Tree index file.
2 drop B-Tree index file.
3 rebuild B-Tree index file.
4 attach XM to B-Tree index.
5 for internal use only.
6 release B-Tree index file (file system security)
7 secure B-Tree index file (file system security)
2 ignored when function code is 0 in element 1 data set number (1..199)
when function code is 1 through 7 in element 1
3-4 ignored on input, zeroed at entry to DBCONTROL mode 13, and used to
return a 32-bit status at exit if at least one of the internal B-Tree index file
routines was executed.
5 flags for internal use only: bit 15: 1 = report progress, if appropriate,
when function code is 1 through 7 in element 1
6-16 reserved; should be 0.
Mode 14
Mode 14 is used to set BTREEMODE1 option ON or OFF for the database and set the
wildcard character for the database. The changes will be made in the root file, unlike mode
15 and 16 of DBCONTROL. The caller must be privileged. The result is same as using the
SET command with BTREEMODE1 option of DBUTIL. This is the qualifier layout (16
halfwords):