Hp Query User manual

QUERY/V

Reference Manual

HP 3000 MPE/iX Computer Systems

ABCDE

HP Part No. 30000-90042

Printed in U.S.A. OCT 98

E1098

The information contained in this do cument is sub ject 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 responsibilit y for the use or reliability of its software on

equipment that is not furnished by Hewlett-Packard.

This do cument contains proprietary information which is protected by copyright. All rights

are reserved. No part of this do cumentmay b e photo copied, repro duced or translated to

another language without the prior written consent of Hewlett-Packard Company.



PRINTING HISTORY

New editions are complete revisions of the man

ual. Up date packages, which are issued

between editions, contain additional and replacement pages to b e merged in

to the manual by

the customer. The dates on the title page c

hange only when a new edition or a new update

is published. No information is incorporated in

to a reprinting unless it appears as a prior

update; the edition do es not c

hange when an update is incorp orated.

The software code printed alongside the data indicates the v

ersion level of the softw

are

pro duct at the time the man

ual or up date w

as issued. Many pro duct updates and xes

do not require manual changes and, conversely, manual corrections may b e done without

accompanying pro duct changes. Therefore, do not expect a one-to-one corresp ondence

between product updates and man

ual updates.

First Edition Jun 1976 32216A.00.00

Update 1 Apr 1978 32216A.03.05

Update 2 May 1979 32216A.04.01

Update 2 Incorporated May 1979 32216A.04.01

Second Edition Nov 1981 32216B.00.00

Third Edition Dec 1985 32216C.00.00

Update 1 Apr 1986 32216C.00.00

Update 1 Incorporated May 1986 32216C.00.00

Fourth Edition May 1987 32216C.00.08

Update Oct 1998 Converted to SGML format

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 (MPE)

Operating System. QUERY/V enables you to access data in IMAGE data bases without

writing a computer program.

In order to use QUERY, you should know enough ab out the MPE Operating System to start

a job or op erate in session mo de. It is recommended that you read an introductory b o ok to

the HP 3000 systems if you are not an exp erienced MPE user. Knowledge of EDIT/3000 is

useful for some QUERY techniques but is not required to op erate QUERY.

This manual documents QUERYversions B.01.01 and later. Information on Native Language

Support (NLS) and the IMAGE data types I4, J4, and K2 has b een added to this edition.

NLS is supported on QUERYversions B.01.00 and later, and the IMAGE data types I4, J4,

and K2 are supported on QUERYversions C.00.00 and later. Information which is sp ecic to

a particular version of QUERY (B.01.01 or later) is noted throughout this manual.

This manual is arranged in three sections and seven app endices. Section 1 introduces QUERY

terminology, briey describ es IMAGE data bases, and discusses other imp ortant general

IMAGE, QUERY, and MPE concepts. Section 2 illustrates op erating QUERY in session

or job mo de and discusses the functions of QUERY and the commands which are used

iii

to p erform them. Appendix A con

tains all QUERY messages. Appendix B lists helpful

information on numeric limits of QUERY commands and discusses the les used b

y QUERY

during execution. Appendix C describ es three w

ays to access a data base on a remote HP

3000. Appendix D discusses Native Language Supp ort. Appendix E discusses self-describing

les. App endix F discusses user-dened pro cedures and giv

es examples in programming

languages. Appendix G lists the ASCII c

haracter set.

In addition to this manual, you may need to consult the following man

uals:

TurboIMAGE/XL Database Management System Reference Manual

IMAGE/SQL Adminstration Guide

MPE/iX Commands Reference Manual

Using NS3000/iX Network Services

Native Language Programmer's Guide

Throughout this manual, no distinction is made bet

ween TurboIMAGE/XL and

IMAGE/SQL. These manuals are both referenced as the

IMAGE Reference Manual

The QUERY pro duct is now referred to as QUERY/V. In previous editions of this manual,

the QUERY pro duct was called QUERY/3000. This edition of the QUERY/V Reference

Manual do cuments the C.00.08 version of QUERY.

Contents

1. INTRODUCING QUERY/V

STRUCTURE OF THE DATA BASE . . . . . . . . . . . . . . . . . . 1-2

Fully-Qualied Data Item Names . . . . . . . . . . . . . . . . . . . 1-3

Data Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-3

Data Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4

Literals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-4

Comp ound Data Items . . . . . . . . . . . . . . . . . . . . . . . 1-6

Data Set Relations . . . . . . . . . . . . . . . . . . . . . . . . . 1-6

Sample Data Base . . . . . . . . . . . . . . . . . . . . . . . . . 1-6

MODES OF ACCESS . . . . . . . . . . . . . . . . . . . . . . . . . 1-8

Logging and Mo de Selection . . . . . . . . . . . . . . . . . . . . . 1-11

PASSWORDS . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-11

QUERY CHARACTER SET . . . . . . . . . . . . . . . . . . . . . . 1-11

MPE FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1-12

2. USING QUERY/V

USING QUERY IN SESSION MODE . . . . . . . . . . . . . . . . . . 2-1

Running QUERY.. . . . . . . . . . . . . . . . . . . . . . . . . 2-1

Accessing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2

Using the Break Key . . . . . . . . . . . . . . . . . . . . . . . . 2-2

Using Control Y . . . . . . . . . . . . . . . . . . . . . . . . . . 2-2

Exiting QUERY . . . . . . . . . . . . . . . . . . . . . . . . . . 2-3

USING QUERY IN JOB MODE . . . . . . . . . . . . . . . . . . . . 2-3

Discussion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2-4

QUERY COMMANDS . . . . . . . . . . . . . . . . . . . . . . . . 2-5

IDENTIFYING THE QUERY ENVIRONMENT . . . . . . . . . . . . . 2-8

LOCATING DATA . . . . . . . . . . . . . . . . . . . . . . . . . . 2-9

MODIFYING DATA . . . . . . . . . . . . . . . . . . . . . . . . . 2-10

REPORTING DATA . . . . . . . . . . . . . . . . . . . . . . . . . 2-11

USING PROCEDURES IN A PROC-FILE . . . . . . . . . . . . . . . . 2-12

USING QUERY COMMANDS FROM AN XEQ FILE . . . . . . . . . . 2-13

3. QUERY/V COMMANDS

ALTER . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-2

ASSIGN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-8

CLOSE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-9

COMMENT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-10

CREATE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-11

CREATE SPACE . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-14

DATA-BASE= . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-15

DATA-SETS= . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-18

DBLIST= . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-21

Contents-1

DEFINE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-24

DESTROY. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-26

DISPLAY . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-27

DISPLAY LIST . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-29

EXIT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-30

FIND . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-31

FIND ALL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-41

FIND CHAIN . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-43

FIND pro cedure . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-46

FORM . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-48

HELP . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-54

JOIN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-56

JOIN pro cedure . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-65

LANGUAGE= . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-66

LIST . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-67

LISTREDO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-73

MODE= . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-75

MULTIDB . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-76

MULTIFIND . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-78

MULTIFIND ALL . . . . . . . . . . . . . . . . . . . . . . . . . . 3-82

MULTIFIND pro cedure . . . . . . . . . . . . . . . . . . . . . . . . 3-84

OUTPUT= . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-85

PASSWORD= . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-88

PROC-FILE = . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-90

REDO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-92

RELEASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-95

RENAME . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-96

REPORT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-97

REPORT ALL . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-130

REPORT pro cedure . . . . . . . . . . . . . . . . . . . . . . . . . . 3-134

SAVE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-136

SETLOCKS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-137

SHOW . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-138

SUBSET . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-139

SUBSET pro cedure . . . . . . . . . . . . . . . . . . . . . . . . . . 3-142

TRANSBEGIN . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-143

TRANSEND . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-144

TRANSMEMO . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-145

UNDO . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-146

UPDATE ADD . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-147

UPDATE DELETE . . . . . . . . . . . . . . . . . . . . . . . . . . 3-151

UPDATE REPLACE . . . . . . . . . . . . . . . . . . . . . . . . . 3-153

UPDATE procedure . . . . . . . . . . . . . . . . . . . . . . . . . . 3-157

VERSION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-159

XEQ . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-160

Contents-2

A. QUERY/V MESSAGES

B. QUERY/3000 SPECIFICATIONS

LIMITS USED BY QUERY . . . . . . . . . . . . . . . . . . . . . . B-1

FILES USED BY QUERY. . . . . . . . . . . . . . . . . . . . . . . B-3

C. ACCESSING A REMOTE DATA BASE

METHOD 1: QUERY ON REMOTE SYSTEM . . . . . . . . . . . . . C-1

METHOD 2: QUERY ON LOCAL SYSTEM . . . . . . . . . . . . . . C-2

METHOD 3: USING A DATA-BASE-ACCESS FILE . . . . . . . . . . . C-4

D. NATIVE LANGUAGE SUPPORT

EFFECTS OF NLS ON QUER

Y . . . . . . . . . . . . . . . . . . . . D-2

E. SELF-DESCRIBING FILES

FILE DATA . . . . . . . . . . . . . . . . . . . . . . . . . . . . . E-1

USER LABELS . . . . . . . . . . . . . . . . . . . . . . . . . . . . E-1

Global Information Label F

ormat . . . . . . . . . . . . . . . . . . . E-2

Item Description Lab el Format . . . . . . . . . . . . . . . . . . . . E-2

ITEM NAMES . . . . . . . . . . . . . . . . . . . . . . . . . . . . E-3

F. USER-DEFINED PROCEDURES

Pro cedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . F-1

Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . F-2

Examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . F-5

MPROC Pro cedure . . . . . . . . . . . . . . . . . . . . . . . . . F-5

SPL - MPROC Pro cedure . . . . . . . . . . . . . . . . . . . . . . F-6

COBOL - MPROC Pro cedure . . . . . . . . . . . . . . . . . . . . F-8

COBOL Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . F-10

PASCAL - MPROC Pro cedure . . . . . . . . . . . . . . . . . . . . F-10

PASCAL Notes . . . . . . . . . . . . . . . . . . . . . . . . . . . F-13

Additional Comments . . . . . . . . . . . . . . . . . . . . . . . . F-14

FORTRAN - MPROC Pro cedure . . . . . . . . . . . . . . . . . . . F-14

QPROC Pro cedure . . . . . . . . . . . . . . . . . . . . . . . . . F-16

SPL - QPROC Pro cedure . . . . . . . . . . . . . . . . . . . . . . F-16

COBOL - QPROC Pro cedure . . . . . . . . . . . . . . . . . . . . F-21

G. ASCII CHARACTER SET

Contents-3

Figures

1-1. ORDERS Data Base Structure . . . . . . . . . . . . . . . . . . . . 1-7

1-2. Sample Entry Values . . . . . . . . . . . . . . . . . . . . . . . . 1-7

1-3. IMAGE/QUERYEnvironments . . . . . . . . . . . . . . . . . . . . 1-10

2-1. Job Mo de Operation . . . . . . . . . . . . . . . . . . . . . . . . 2-4

3-1. FORM ITEMS Output . . . . . . . . . . . . . . . . . . . . . . . 3-49

3-2. FORM PATHS Output . . . . . . . . . . . . . . . . . . . . . . . 3-50

3-3. FORM SETS Output . . . . . . . . . . . . . . . . . . . . . . . . 3-50

3-4. FORM

data item name

Output . . . . . . . . . . . . . . . . . . . . 3-51

3-5. FORM

data set name

Output . . . . . . . . . . . . . . . . . . . . 3-51

3-6. FORM Output . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-53

3-7. General Rep ort Format . . . . . . . . . . . . . . . . . . . . . . . 3-100

3-8. Sample Report . . . . . . . . . . . . . . . . . . . . . . . . . . . 3-101

3-9. Sample Output Using Numeric Edit Masks . . . . . . . . . . . . . . . 3-109

3-10. REPORT Pro cedure Named SHIPMNTS . . . . . . . . . . . . . . . 3-135

3-11. Billing Report From an XEQ File . . . . . . . . . . . . . . . . . . . 3-162

C-1. Using Metho d 1 . . . . . . . . . . . . . . . . . . . . . . . . . . C-2

C-2. Using Metho d 2 . . . . . . . . . . . . . . . . . . . . . . . . . . C-3

C-3. Using Metho d 3 . . . . . . . . . . . . . . . . . . . . . . . . . . C-4

Contents-4

Tables

1-1. Data Item Types and Values . . . . . . . . . . . . . . . . . . . . . 1-5

2-1. Command Categories and Functions . . . . . . . . . . . . . . . . . . 2-6

2-2. Pro cedure Commands . . . . . . . . . . . . . . . . . . . . . . . . 2-12

2-3. Commands Used to Dene Pro cedures . . . . . . . . . . . . . . . . . 2-13

3-1. FIND Command Relational Operators . . . . . . . . . . . . . . . . . 3-33

3-2. MATCHING Pattern Operators . . . . . . . . . . . . . . . . . . . 3-40

3-3. LIST Command Relational Operators . . . . . . . . . . . . . . . . . 3-68

3-4. Field Widths of Data Item T

ypes . . . . . . . . . . . . . . . . . . . 3-69

3-5. REPORT Statements . . . . . . . . . . . . . . . . . . . . . . . . 3-98

3-6. REPORT StatementParameters . . . . . . . . . . . . . . . . . . . 3-98

3-7. Numeric Edit Mask Characters . . . . . . . . . . . . . . . . . . . . 3-108

3-8. Numeric Edit Mask Combinations . . . . . . . . . . . . . . . . . . . 3-109

3-9. REPORT ALL Options . . . . . . . . . . . . . . . . . . . . . . . 3-131

3-10. Overpunch Characters . . . . . . . . . . . . . . . . . . . . . . . . 3-131

3-11. Output of P and Z Type Values . . . . . . . . . . . . . . . . . . . 3-132

3-12. Retrieval Command Relational Op erators . . . . . . . . . . . . . . . 3-140

B-1. General . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . B-1

B-2. JOIN Command . . . . . . . . . . . . . . . . . . . . . . . . . . B-1

B-3. LIST Command . . . . . . . . . . . . . . . . . . . . . . . . . . B-1

B-4. PROC-FILE Command . . . . . . . . . . . . . . . . . . . . . . . B-1

B-5. REPORT Command . . . . . . . . . . . . . . . . . . . . . . . . B-2

B-6. Retrieval Command (FIND, MULTIFIND, SUBSET) . . . . . . . . . . B-2

B-7. SAVE Command . . . . . . . . . . . . . . . . . . . . . . . . . . B-2

B-8. TRANSMEMO Command . . . . . . . . . . . . . . . . . . . . . . B-2

B-9. Up dating Command (UPDATE ADD and UPDATE REPLACE) . . . . . B-3

B-10. Files Equated by the User . . . . . . . . . . . . . . . . . . . . . . B-3

B-11. Files Not Equated by the User (Temp orary Files) . . . . . . . . . . . . B-3

B-12. Files Created by the User and/or Sp ecied to be Built b

y QUERY . . . . B-4

B-13. Unnamed Scratch Files (Temp orary Files) . . . . . . . . . . . . . . . B-4

D-1. Commands for Language-Dep endent Information . . . . . . . . . . . . D-2

Contents-5

Table of contents

Other HP Computer Hardware manuals

HP JG587A User manual

HP 381513-B21 - Smart Array P800 Controller... User manual

HP 64782 User manual

HP Xw6600 - Workstation - 2 GB RAM User manual

HP E3473A User manual

HP MCS G2 Installation guide

HP D7171A - NetServer - LPr User manual

HP M8201R User manual

HP ProLiant DL140 User manual

HP Metal Jet S100 User manual

HP KVM Server Console Switch G2 User instructions

HP SC08Ge User manual

HP 64793 Series User manual

HP 6600 FIP-20 Flex Assembly instructions

HP NVIDIA Tesla M2070Q User manual

HP Model 748 - VME Workstation User manual

HP D7171A - NetServer - LPr Installation and operation manual

HP Adaptec ultra p2280a User manual

HP HP-UX 10.20 User manual

HP A58 0AF Series Assembly instructions

HP Xw4600 - Workstation - 2 GB RAM User manual

HP OmniBook 3100 User manual

HP FlexFabric 12908E LSXM108XFAN User manual

HP Kayak XW U3-W3 User manual

Popular Computer Hardware manuals by other brands

Toshiba

Toshiba TOSVERT VF-MB1/S15 IPE002Z Function manual

Shenzhen

Shenzhen MEITRACK MVT380 user guide

TRENDnet

TRENDnet TEW-601PC - SUPER G MIMO WRLS PC CARD user guide

StarTech.com

StarTech.com CF2IDE18 instruction manual

Texas Instruments

Texas Instruments LMH0318 Programmer's guide

Gateway

Gateway 8510946 user guide

Devon IT

Devon IT TC2D Quick setup guide

Krüger & Matz

Krüger & Matz Air Shair2 owner's manual

Crystalio

Crystalio VPS-2300 quick guide

MYiR

MYiR FZ3 user manual

Protech Systems

Protech Systems BC-K200 Quick reference guide

Miranda

Miranda DENSITE series DAP-1781 Guide to installation and operation

Sierra Wireless

Sierra Wireless Sierra Wireless AirCard 890 quick start guide

Leadtek

Leadtek Killer Xeno Pro Quick installation guide

Star Cooperation

Star Cooperation FlexTiny 3 Series Instructions for use

Hotone

Hotone Ampero user manual

Connect Tech

Connect Tech Xtreme/104-Express user manual

Yealink

Yealink WF50 user guide

HP QUERY User manual

Popular Computer Hardware manuals by other brands