HP 3000 Manuals HP 3000 Manuals
QUERY/V
QUERY/V is a database management subsystem used for retrieval and
reporting of data. You can use it to retrieve, report on, update, add,
and delete data in a database and display the database structure. It
provides you with the ability to:
* Inquire into a database without writing special programs
* Make low-volume data modification and load new data
* Generate reports comparable to those that many languages produce
* Debug new application programs
The report generation capability of QUERY/V allows you to select data on
a basis of compound logical comparison. Once selected, you can control
which items are reported and how they are formatted on the report.
You can run QUERY/V by entering:
:RUN QUERY.PUB.SYS
Frequently used QUERY/V commands are:
* HELP, which explains QUERY/V commands
* DEFINE, which prompts for needed environment information
* FORM, which displays a database structure
* LIST, which displays data in a data set
* FIND, which searches a data set for data items
* REPORT, which displays data in a data set located by the FIND
command in the format you specify
* XEQ, which executes QUERY/V commands stored in a text file
* EXIT, which terminates QUERY/V execution
Table 7-3 shows a comparison of data management considerations to
help you determine whether to set up a data base with TurboIMAGE/XL or
KSAM.
The preferred choice of KSAM over TurboIMAGE/XL for generic key retrieval
is based on the fact that KSAM automatically handles partial key
searches. A TurboIMAGE/XL database requires defining an additional
master set and detail set to handle the partial key search, as well as
requiring some additional programming.
Table 7-3. Data Management Considerations
----------------------------------------------------------------------------------------------
- - TurboIMAGE/XL - KSAM -
----------------------------------------------------------------------------------------------
- Heavy sequential processing - no - yes -
- Unanticipated inquiries - yes - use FCOPY -
- Program-data independence - yes - no -
- Easy conversion from ISAM - no - yes -
- Privacy and security - yes - file level only -
- Privileged files (protected) - yes - no -
- Variable-length records - no - yes -
- Field access by name - yes - no -
| Generic (partial) key | no | yes |
| retrieval | | |
- Sorted retrieval by key - yes - yes -
----------------------------------------------------------------------------------------------