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

Chapter 11 497
B-Tree Indices
External Commands and Utilities Affected
language of the database, if the key is an ASCII (X or U) data type.
When using the ALL option and there is no master data set, a warning is generated, but
the command is considered to be successful.
Other DBUTIL Commands
The following lists the impact of B-Tree indices on other DBUTIL commands:
• CREATE does an implicit ADDINDEX command for each data set marked by DBSCHEMA
as indexed.
• ERASE erases any associated B-Tree index (.idx) files, but will not delete them.
• MOVE does NOT allow a B-Tree index (.idx) file to be moved.
• PURGE purges any associated B-Tree index (.idx) files.
• SECURE and RELEASE apply to the associated B-Tree index (.idx) files.
• SET has a new option, BTREEMODE1.
• SHOW has a new option: INDEX, INDEXES, or INDICES.
New Syntax for SET
SET
database name [/ maintword ] BTREEMODE1={ ON
OFF} [,[WILDCARD=]
c ]
where
c is any printable ASCII character, and the default character is @.
The BTREEMODE1 option sets DBFIND mode 1 access ON or OFF for a B-Tree index
search for X and U types. The default is OFF, in which case DBFIND mode 1 with the
argument containing a wildcard character will continue to work the way it did in releases
prior to a release with the B-Tree index feature (C.07.00). When BTREEMODE1 is ON,
DBFIND mode 1 with the argument containing a wildcard character will be treated as a
B-Tree index search. Refer to the DBFIND section for more information on BTREEMODE1.
Examples
>>SET ORDERS/secret BTREEMODE1 = ON
>>SET ORDERS/secret BTREEMODE1 = ON,%
The DBUTIL SHOW ALL command shows if any B-Tree index files exist and the value of
BTREEMODE1. Example output:
>> show ORDERS all
For database ORDERS
...
Dynamic capacity expansion is not used.
Database has at least one indexed data set.
BTREEMODE1 is off, wildcard = "@"
Logid is not present.
...
Example if no B-Tree index files exist: