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

Chapter 11 507
B-Tree Indices
External Commands and Utilities Affected
DBINFO
DBINFO has new modes 113 and 209.
Mode 113
DBINFO mode 113 reports the wildcard character in use for the database, and the value of
BTREEMODE1. The qualifier is ignored.
The output buffer for mode 113 must be at least 32 bytes in size and is shown below
(elements are 16-bits wide and are counted starting with 1):
Element Contents
1 0 if BTREEMODE1 is off in the root file
1 if BTREEMODE1 is on in the root file
2 The first byte (8 bits) is always 0. The second byte (8 bits) represents
c
,
where
c
is the current wildcard character. For example, if the current
wildcard character is @, the element's hex value will be $0040, or decimal
64.
3 Highest B-Tree index argument version supported (currently 0)
4 Number of sets with B-Tree indices attached
5 0 if BTREEMODE1 is OFF for current DBOPEN
1 if BTREEMODE1 is ON for current DBOPEN
6 The first byte (8 bits) is always 0 for current DBOPEN. The second byte (8
bits) represents
c
, where
c
is the current wildcard character.
7-16 (reserved)
Mode 209
DBINFO mode 209 reports whether or not a data set has a B-Tree index attached. The
qualifier is a data set number or name. The output buffer is required to be 64 bytes (32
halfwords) or larger. The output buffer for mode 209 is shown below (elements are 16-bits
wide, and are counted starting with 1):
Element Contents
1 0 if no B-Tree index exists 1 if B-Tree index exists
2 1 if attached B-Tree is not damaged or index does not exist
3-32 For internal use