Communicator e3000 MPE/iX Release 6.5 (Non-Platform Software Release C.65.00 (30216-90291)

Chapter 5 133
Internet and Interoperability
Transact/iX Expanded B-Tree and File Open Enhancement
The B-tree search can only be used for the following data retrieval verbs: DELETE, FIND,
GET, OUTPUT, REPLACE, and PATH. Only the CHAIN or RCHAIN modifiers can be used for the
data retrieval verbs. The key and argument register should be set prior to the data
retrieval. The STATUS count returned may not always be accurate. For example, DBFIND
modes 21 and 24 do not return the correct chain count or entry numbers.
The complete syntax for the FIND verb is shown below.
Syntax
FIND [(modifier)] file-name [ ,option-list ];
Parameters
Option-list One or more of the following options, separated by
commas. Only the additional option is listed here. See the
Transact/iX Reference Manual for all the other possible
options.
FINDMODE=mode Only available with the CHAIN or RCHAIN modifiers.
Performs optimized searching of an index by using
TurboIMAGE/XL's B-tree index functionality or Third
Party Indexing. The mode is the mode that is specified for
the DBFIND of this data retrieval verb.
If the FINDMODE option is not specified, DBFIND mode 1 is
used.
Here are some examples of B-tree Structured Arguments in Transact/iX. Assume
BTREEMODE1 is
ON and B-tree indices exist.
Example 1
system ex1,base=passks;
define(item) search-arg x(30):
search-type x(2)=search-arg(1):
search-version I(5,,2)=search-arg(3):
arg1-size I(5,,2)=search-arg(5):
arg2-size I(5,,2)=search-arg(7):
arg1 x(8)=search-arg(9):
arg2 x(8)=search-arg(17):
prod-no x(8):
ship-date x(6);
list search-arg,init:
prod-no:
ship-date;
<< Retrieve all product numbers beginning with PROD. >>
<< Uses DBFIND mode 1. >>
move (prod-no) = "PROD@";
set(key) list(prod-no);
output(chain) inventory, list=(prod-no:ship-date);
<< Retrieve all product numbers between PROD1 and PROD2. >>
<< Uses DBFIND mode 4. >>