HP 3000 Manuals HP 3000 Manuals
QUERY/V Reference Manual HP 3000 Computer Systems HP Part No. 30000-90042 Edition E0587 Printed in U.S.A. Printed May 1987
NOTICE The information contained in this document is subject to change without notice. HEWLETT-PACKARD MAKES NO WARRANTY OF ANY KIND WITH REGARD TO THIS MATERIAL, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. Hewlett-Packard shall not be liable for errors contained herein or for incidental or consequential damages in connection with the furnishing, performance or use of this material. Hewlett-Packard assumes no responsibility for the use or reliability of its software on equipment that is not furnished by Hewlett-Packard. This document contains proprietary information which is protected by copyright. All rights are reserved. No part of this document may be photocopied, reproduced or translated to another language without the prior written consent of Hewlett-Packard Company. Copyright Æ 1976, 1981, 1985, 1986, 1987 by HEWLETT-PACKARD COMPANY PRINTING HISTORY New editions are complete revisions of the manual. Update packages, which are issued between editions, contain additional and replacement pages to be merged into the manual by the customer. The dates on the title page change only when a new edition or a new update is published. No information is incorporated into a reprinting unless it appears as a prior update; the edition does not change when an update is incorporated. The software code printed alongside the date indicates the version level of the software product at the time the manual or update was issued. Many product updates and fixes do not require manual changes and, conversely, manual corrections may be done without accompanying product changes. Therefore, do not expect a one to one correspondence between product updates and manual updates. First Edition Jun 1976 32216A.00.00 Update No.1 Apr 1978 32216A.03.05 Update No. 2 May 1979 32216A.04.01 Update No. 2 Incorporated May 1979 32216A.04.01 Second Edition Nov 1981 32216B.00.00 Third Edition Dec 1985 32216C.00.00 Update No. 1 Apr 1986 32216C.00.00 Update No. 1 Incorporated May 1986 32216C.00.00 Fourth Edition May 1987 32216C.00.08 LIST OF EFFECTIVE PAGES The List of Effective Pages gives the date of the most recent version of each page in the manual. To verify that your manual contains the most current information, check the dates printed at the bottom of each page with those listed below. The date on the bottom of each page reflects the edition or subsequent update in which that page was printed. Effective Pages Date all May 1987 PREFACE This manual describes QUERY/V, the Hewlett-Packard Data Base Inquiry Facility which is designed to run under the control of the HP 3000 Multiprogramming Executive Operating System. QUERY/V enables you to access data in IMAGE data bases without writing a computer program. To use QUERY, you should know enough about the MPE Operating System to start a job or operate in session mode. It is recommended that you read the first section of Using the HP 3000 if you are not an experienced MPE user. Knowledge of EDIT/3000 useful for some QUERY techniques but is not required to operate QUERY. This manual is arranged into three sections and seven appendices. Section 1 introduces QUERY terminology, briefly describes IMAGE data bases, and discusses other important general IMAGE, QUERY, and MPE concepts. Section 2 illustrates operating QUERY in session or job mode and discusses the functions of QUERY and the commands which are used to perform them. Section 3 is a reference section which documents all the QUERY commands. Appendix A contains all QUERY messages. Appendix B lists helpful information on numeric limits of QUERY commands and discusses the files used by QUERY during execution. Appendix C describes three ways to access a data base on a remote HP 3000. Appendix D discusses Native Language Support. Appendix E discusses self-describing files. Appendix F discusses user-defined procedures and gives examples in programming languages. Appendix G lists the ASCII character set. In addition to this manual, you may need to consult the following manuals: TurboIMAGE Reference Manual * 32215-90050 IMAGE/3000 Reference Manual * 32215-90003 Using the HP 3000 03000-90121 MPE Commands Reference Manual 30000-90009 DS/3000 Reference Manual 32190-90001 NS/3000 User/Programmer Reference Manual 32344-90001 Native Language Support Reference Manual 32414-90001 * Throughout this manual, no distinction is made between the TurboIMAGE Reference Manual and the IMAGE/3000 Reference Manual, both are referenced as the IMAGE Reference Manual. In addition, both IMAGE/3000 and TurboIMAGE/V are referred to as IMAGE. Changes to This Manual In this edition, the QUERY product is referred to as QUERY/V. In previous editions of this manual, the QUERY product was called QUERY/3000. This edition of the QUERY/V Reference Manual documents the C.00.08 version of QUERY. Two new commands are included in this edition: REDO and LISTREDO. In addition, the REPORT ALL command has been enhanced to allow a new option, and the REPORT command has been enhanced to allow a new output control statement. (QUERY versions prior to C.00.00 only access IMAGE/3000 data bases, and QUERY versions C.00.00 and later access TurboIMAGE/V data bases.) CONVENTIONS USED IN THIS MANUAL NOTATION DESCRIPTION nonitalics Words in syntax statements which are not in italics must be entered exactly as shown. Punctuation characters other than brackets, braces and ellipses must also be entered exactly as shown. For example: EXIT italics Words in syntax statements which are in italics denote a parameter which must be replaced by a user-supplied variable. For example: CLOSE data base name [ ] An element inside brackets in a syntax statement is optional. Several elements stacked inside brackets means the user may select any one or none of these elements. For example: [A] [B] User may select A or B or neither. { } When several elements are stacked within braces in a syntax statement, the user must select one of those elements. For example: {A} {B} User must select A or B or C. {C} ... A horizontal ellipsis in a syntax statement indicates that a previous element may be repeated. For example: [,data item name]... In addition, vertical and horizontal ellipses may be used in examples to indicate that portions of the example have been omitted. underlining When necessary for clarity in an example, user input may be underlined. For example: PASSWORD = >>CLERK The symbol may be used to indicate a key on the terminal keyboard. For example, RETURN indicates the carriage return key. CONTROLchar Control characters are indicated by CONTROL followed by the character. For example, CONTROLY means the user presses the control key and the character Y simultaneously.