|
|
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
modified such that the heading reflects 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 flag 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.
The FIND, MULTIFIND, and SUBSET commands have been
enhanced to accept a NO MATCH alternative such that all data records
NOT MATCHING the pattern provided are returned by the commands.
For more information, refer to "QUERY/iX Enhancements" in chapter 10,
"Technical Articles."
|