Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

Chapter 10 163
Technical Articles
IMAGE/SQL with TurboIMAGE/XL Enhancements
• CREATE, ERASE, PURGE, SECURE, RELEASE, and SHOW commands
include B-Tree index files in their operation.
• The MOVE command does not allow moving the index file.
6. DBCONTROL has these modes pertaining to B-Tree indices:
13 is for B-Tree index file control. That is, to ADD, DROP,
REBUILD, ATTACH, or DETACH a B-Tree index file.
This mode requires PRIVILEGED mode, and hence,
must be used carefully as improper use may damage
your system.
14 is used to obtain and control database-wide B-Tree
information. This mode requires PRIVILEGED mode,
and hence, must be used carefully as improper use
may damage your system.
15 sets BTREEMODE1 ON, and optionally allows the
wildcard character to be set for the current DBOPEN.
16 sets BTREEMODE1 OFF for the current DBOPEN.
7. DBINFO has these modes pertaining to B-Tree indices:
209 informs whether or not a B-Tree index exists for a
master.
113 gives BTREEMODE1 setting and the wildcard
character for the database as well as current
DBOPEN.
8. DBFIND has these features pertaining to B-Tree indices:
• Can be used for details as well as masters to specify B-Tree index
searches.
• Introduces a new fixed-format structured argument.
• DBFIND modes with added functionality pertaining to B-Tree
indices:
1 can continue to work as it does in releases prior to
the release of B-Tree index feature (C.07.00), despite
the presence of a B-Tree index, or it can be used for a
B-Tree search if BTREEMODE1 is ON. Uses the classic
mode 1 argument format.
4 used for B-Tree index searches on numeric as well as
ASCII types and, for details, it returns accurate
chain (super-chain, that is, multiple qualified
chains) counts. Requires a new structured
argument.