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

Chapter 5 179
TurboIMAGE/XL Library Procedures
DBFIND
on the key item of the master to which the search item
has a path.
• BTREEMODE1 flag is set ON by DBUTIL or DBCONTROL
mode 15.
• Argument contains a wildcard character.
The chain count is accurate in halfword 5-6, and status
halfwords 7-8 and 9-10 record the last entry in the last
chain, and the first entry in the first chain of the
super-chain for detail data sets. For master data sets, the
status halfwords 5-6 (chain-count for detail) reflect the
total number of entries qualified in the master data set.
All other fields of the status array return zeroes.
4 For B-Tree searches on numeric as well as ASCII types.
For detail data sets, returns accurate chain (super-chain)
counts and record numbers of last entry in last chain and
first entry in first chain. For masters, returns the total
number of qualified entries in status halfword 5-6. Other
fields return zeroes. Requires a structured argument
format described under
argument .
10 Allows you to simulate the current DBFIND mode 1, as in
versions prior to B-Trees, as if there were no B-Tree index,
even when the item has B-Tree index, BTREEMODE1 is on,
and the argument contains a wildcard character. It
returns accurate chain count. This is the same as TPI
mode 10. Requires a simple argument.
21 Same as mode 1, except it is a faster version and does not
return accurate chain count or record numbers of first
entry and last entries. Requires a simple argument.
For details, the chain count and status halfwords 7-8 and
9-10 will have 2
31
−1. For master data sets, the status
halfwords 5-6 (chain-count for detail) reflect the total
number of entries qualified in the master data set. All
other fields of the status array return zeroes. A DBFIND
mode 21 on a non-ASCII key returns an error.
24 Same as mode 4, except it is a faster version and does not
return accurate chain counts and record numbers of last
entry and first entry in super-chain. For detail data set,
the halfwords 5-6, 7-8, and 9-10 will have 2
31
−1. For
master data set, the halfword 5-6 will have 2
31
−1 and 7-8
and 9-10 will have zeroes. The argument is in structured
format described under
argument .
The third-party indexing (TPI) modes of DBFIND which are NOT supported
for B-Trees are: 11, 12, and various TPI DBFIND modes 1nn, 2nn, 3nn, 4nn,
and 5nn. If your database is enabled for TPI, refer to your vendor