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

182 Chapter5
TurboIMAGE/XL Library Procedures
DBFIND
— Item type is X or U (ASCII).
— DBFIND is for master and a B-Tree index exists on the key item or DBFIND is for
detail and B-Tree index exists on the key item of the master to which the search item
has a path.
— BTREEMDODE1 flag is set ON by DBUTIL or DBCONTROL mode 15.
— Argument contains a wildcard character.
• Status array reflects information based on set, mode, and search type. B-Tree searches
for modes 1 and 4 for details give super-chain (multiple detail chain) counts and record
numbers of the first entry in first detail chain and last entry in last detail chain. For
masters, modes 1 and 4 give a count of entries qualified in the master and zeroes for the
first and last qualified entries in the master.
NOTE A call to DBOPEN does not open individual data sets. Thus, a call to DBFIND (or
DBGET) that accesses a data set for the first time (or after the data set has
been closed), must open the data set, as well as the B-Tree index file (if
applicable). This causes extra overhead not incurred by subsequent calls to
the same data set by DBFIND or DBGET.
Consult appendix A for more information about the conditions for the DBFIND return
status values shown in Table 5-12.
Table 5-12. DBFIND Return Status Values
File System, Memory
Management, and
Transaction
Management Failures:
-1 FOPEN failure.
-3 FREADDIR failure.
-4 FREADLABEL failure.
-168 Cannot attach
n to MPE XL XM: file system error nn .
-169 Invalid mode for XM attach options.
-175 Cannot attach
n to MPE XL XM: XM error nn .
-176 Cannot detach
n from MPE XL XM: XM error nn .
-178 Cannot detach
n from MPE XL XM: file system error nn .
-209 Invalid mode for XM detach options.