QUERY/iX Enhancements Respond to User Requests
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| Index |
Enterprise Support Services Organization R&D The newest release of QUERY/iX HP32216D.03.17 (and later) contains enhancements that were requested by customers through the SIGIMAGE User's Group. These are the support of the Expanded TurboIMAGE Limits and the Find-by-Record-Number option. In addition, QUERY/iX has been changed to allow the runtime PARM=%777 option that invokes Business Basic Floating Decimal datatype on the Native Mode version of QUERY.
TurboIMAGE Expanded Limits
The support of the TurboIMAGE Limit Expansion allows for the increased number of datasets from 199 to 240, the increased number of data items from 1023 to 1200, and the increase in paths into a master dataset from 16 to 64. QUERY/iX will utilize the new limits on systems with the TurboIMAGE version HP30391C.09.00 and later. If the new DBUTIL option flag of OLDINFOLIMITS is enabled for a database, QUERY/iX will function normally as it uses the new DBCONTROL Mode 20 to inform TurboIMAGE that QUERY code supports the new expanded limits.
FIND by Record Number
The long requested Find-by-Record-Number enhancement has been implemented. This new format of the FIND command permits the retrieval of a specific record in a dataset. The form of the new feature is:
FIND [DATA BASE NAME:] DATA SET NAME.#RECORD NUMBERThe record number is preceded by a "#" and is the record offset into the dataset that is to be retrieved. The record number may be a decimal number (the default) or an octal value indicated by a "%" after the "#", or a hexadecimal value indicated by a "$". For example, to read the fifteenth record in the dataset INVOICES, one could use any of the following commands:
FIND INVOICES.#15 FIND INVOICES.#%17 FIND INVOICES.#$fAfter a record is retrieved, all of the usual QUERY commands may be used on the record. If the record number requested does not exist, QUERY will return a "NO ENTRY" or "DIRECTED END OF FILE" followed by "0 ENTRIES QUALIFIED."
Floating Decimal Option with Native Mode QUERY
The PARM=%777 option is now available with the Native Mode version of QUERY. It was previously only available with the Compatibility Mode version of QUERY. The availability of this feature on Native Mode QUERY will allow the Compatibility Mode version of QUERY to be discontinued in a future release. With this change, Native Mode Query (QUERY.PUB.SYS and QUERYNM.PUB.SYS) now provides a superset of the Compatibility Mode QUERY. All use of QUERYCM should now be transferable to QUERY.PUB.SYS. Thus, QUERYCM.PUB.SYS may no longer be updated and will be replaced on a future release with a SYMLINK to QUERY.PUB.SYS.
Service Request Fixes
Two Service Requests were fixed in this release of QUERY/iX. SR 1653-268235 Superdex Indexes were being reported twice on FORM commands. SR 8606-108307 Find on Z-type items sometimes gave a Scratch File Read Error 0.
|
Chapter 3 Technical Articles |
Using the AS Clause in ALLBASE/SQL |