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

Chapter 8 451
Using the Database Utilities
>>SET
doing a B-Tree DBFIND, mode-1-style arguments are
scanned to find the first occurrence of the current wildcard
character in the argument text. If the wildcard is not
found, a non- B-Tree search is done (even if the DBFIND
mode was 21). If the wildcard is found, the rest of the
argument text is ignored.
NOTE This does not match the functionality of "@" in commands such as the MPE
LISTF, but does match the functionality of current TPI implementations.
If the wildcard character is found at character k+1
(1-based), then the qualified entries will consist of all keys
that match the argument in character positions 1..k.
When not doing a B-Tree find (even when mode=1 and
BTREEMODE1=ON; or mode=10), the entire argument,
including any wildcard characters, will be treated as the
actual argument for a DBFIND mode 1.
The length of the argument may not exceed the item
length.
Example 1
:RUN DBUTIL.PUB.SYS Initiate DBUTIL execution.
.
.
.
>>SET ORDERS MAINT Remove current maintenance word.
Maintenance word changed
>>
Example 2
:RUN DBUTIL.PUB.SYS Initiate DBUTIL execution.
.
.
.
>>SET ORDERS CIUPDATE=ON Indicates that processes can update the values of
detail data set search or sort items in the ORDERS
database without a need to do DBCONTROL mode 5.
CIUPDATE is ON. DBUTIL confirms the setting.