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

Chapter 10 147
Technical Articles
QUERY/iX Enhancements
Figure 10-1 FORM Example
>FORM
DATA BASE: TOYDB MON, MAY 30, 1997, 10:48 AM
DATA BASE LANGUAGE ATTRIBUTE: NATIVE-3000
DATA BASE HAS 2 INDEXED SETS WITH WILDCARD CHARACTER= "~" NEW
WARNING! DATA BASE BTREEMODE1 IS OFF. WILDCARD DISABLED. NEW
SET NAME:
CUSTOMERS,MANUAL/INDEXED NEW
ITEMS:
CUSTOMER-NO, X6 <<KEY,INDEX ITEM>> NEW
CUSTOMER-NAME, X30
CAPACITY: 50 ENTRIES: 8
SET NAME:
ORDER-MASTER,AUTOMATIC/INDEXED NEW
ITEMS:
ORDER-NO, X8 <<KEY,INDEX ITEM>> NEW
CAPACITY: 503 ENTRIES: 16
SET NAME:
INVOICES,DETAIL
ITEMS:
INVOICE-NO, X6
CUSTOMER-NO, X6 <<SEARCH,INDEX ITEM>> NEW
ORDER-NO, X8 <<SEARCH,INDEX ITEM>> NEW
AMOUNT, P12
CAPACITY: 5016 ENTRIES: 5000
MAXIMUM CAPACITY: 5016 INITIAL CAP.: 38 INCREMENT: 38 NEW
Dynamic Dataset Capacities
The last line above shows another enhancement to QUERY that reflects
the Dynamic Dataset Capacity Expansion capability. When a dataset
has utilized the Dynamic Expansion feature, QUERY will display the
CURRENT, MAXIMUM, and INITIAL capacities and the
INCREMENT amount. The FORM SETS output has been slightly
modified such that the heading reflects that the Current capacity is
being reported rather than the Maximum capacity.
Wildcard Retrievals
QUERY will automatically invoke the B-Tree retrieval feature for the
FIND, LIST, SUBSET, and MULTIFIND commands when a wildcard
character is used in the search value. As QUERY may have up to ten
databases open and each could have a different wildcard, the wildcard
for the DEFINED database will be used when specified, else the first
wildcard specified by an open database will be used. QUERY uses
modes 21 or 24 for B-Tree DBFIND for best performance.