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

510 Chapter11
B-Tree Indices
External Commands and Utilities Affected
Element Contents
1 Function code:
0 mode support inquiry (returns "OK" in status, and ignores
the rest of the record). That is, to validate if mode 14 is
supported in the TurboIMAGE software on the system.
1-6 reserved for internal use.
7 set wildcard (in root file, not DBU). Wildcard is in lower 8
bits of the second element of qualifier. An error is returned
if the value is less than ASCII 33, or greater than ASCII
126.
8 set BTREEMODE1 option ON (in root file, not DBU).
9 set BTREEMODE1 option OFF (in root file, not DBU).
2 ignored for function codes 0-6, 8, or 9. wildcard in lower 8 bits for function
code 7.
3-4 ignored on input, zeroed at entry to DBCONTROL mode 14, and used to
return a 32-bit status at exit ONLY IF the B-Tree index routines are
executed. (This is useful for debugging purposes only.)
5-16 reserved; should be 0.
Mode 15
Mode 15 sets BTREEMODE1 ON for the current database. It examines the first byte of the
qualifier. If it is null or blank, then the current wildcard character is not changed. If it is in
the ASCII range (33..126), then the wildcard character is changed to that value for the
current database open. If the qualifier byte is any other value, DBCONTROL returns an error.
Mode 15 affects just the current database open, not the root file. The caller need not be
privileged. The setting remains in effect until the database is closed or the application
terminates.
Mode 16
For mode 16, the qualifier is ignored, and BTREEMODE1 is set to OFF for the current
database open. Mode 16 affects just the current database open, not the root file. The caller
need not be privileged. The setting remains in effect until the database is closed or the
application terminates.
DBFIND
Prior to a release with the B-Tree index feature, DBFIND required the caller to specify
detail data set on the qualifier and a search item in the item parameter. It used that pair of
data to determine the master set to search for the exact value in the item parameter. The
B-Tree index feature extends DBFIND to allow a master data set as well as the key item in
that data set. Also, it allows for searches other than just equality. This is useful for
obtaining sorted access by key value to entries in a master data set as well as detail data
set.