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

Chapter 5 75

Application Development

QUERY/iX Enhancements Overview

by James Overman

SSG Group R&D

Overview

The following are the new enhancements for QUERY/iX:

• B-Tree Enhancement

• Dynamic Dataset Capacities

• Wildcard Retrievals

• Wildcard Character Limitations

• B-Tree Limitations

• "NO MATCH" Enhancement

With the HP32216D.03.11 and N.03.11 releases of QUERY, the new

B-Tree access capabilities will be supported within QUERY on systems

with the B-Tree software release. QUERY is fully backward compatible

with the prior releases of TurboIMAGE/XL and QUERY.

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 modiﬁed

such that the heading reﬂects that the Current capacity is being

reported rather than the Maximum capacity.

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.

Some wildcard characters are used by QUERY for syntax scanning and

are limited in their usage. These special characters may be utilized

when the data values are delimited by double quotes (for example, tilde,

carat, comma, and parenthesis).

QUERY will utilize the B-Tree functionality when possible for both

character and binary data types. The wildcard feature is only

implemented by TurboIMAGE/XL for character data types (X and U)

and not for binary data types. QUERY will continue to use the older

access methods (normally serial reads) for Not Equal retrievals. Note

that the LIST command always uses a serial read but will apply the

wildcard search character for relations.

When a database has the BTREEMODE1 ﬂag set to OFF, QUERY will not

attempt to use the B-Tree functionality for Wildcard retrievals. This

condition is reported by all forms of the FORM command.