HP QUERY Bedienungsanleitung

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

Inhaltsverzeichnis

Andere HP Computerhardware Handbücher

HP HPE LSWM2XGT2PM Bedienungsanleitung

HP AF079A Installationsanleitung

HP 8168E Bedienungsanleitung

HP Smart Array P400 Gebrauchsanweisung

HP Apollo r2800 Montageanleitung

HP 5930-4Slot Bedienungsanleitung

HP Sangoma 2 Montageanleitung

HP OmniBook 3100 Bedienungsanleitung

HP StoreOnce 2700 Bedienerhandbuch

HP C-CLASS BLADESYSTEM 409513-B21 Gebrauchsanweisung

HP ML570 - ProLiant - G2 Bedienungsanleitung

HP P Class 450/500/550/600/650/700/750 Handbuch

HP HP 27113A Handbuch

HP Model 744 - VME Workstation Bedienungsanleitung

HP D7171A - NetServer - LPr Installations- und Betriebshandbuch

HP E2416B Bedienungsanleitung

HP SC08Ge Bedienungsanleitung

HP Rp5700 - Point of Sale System Montageanleitung

HP HP-UX 10.20 Bedienungsanleitung

HP QMH2572 8Gb FC HBA Gebrauchsanweisung

HP 64793 Series Bedienungsanleitung

HP Xw8400 - Workstation - 4 GB RAM Bedienungsanleitung

HP E5000 Bedienungsanleitung

HP Smart Array B140i Bedienungsanleitung

Beliebte Computerhardware Handbücher anderer Marken

EMC2

EMC2 VNX Series Betriebsanleitung

Panasonic

Panasonic DV0PM20105 Bedienungsanleitung

Mitsubishi Electric

Mitsubishi Electric Q81BD-J61BT11 Bedienungsanleitung

Gigabyte

Gigabyte B660M DS3H AX DDR4 Bedienungsanleitung

Raidon

Raidon iT2300 Bedienungsanleitung

National Instruments

National Instruments PXI-8186 Bedienungsanleitung

Hauppauge

Hauppauge WinTV-HVR-2250 Bedienungsanleitung

Kontron

Kontron CP6002 Bedienungsanleitung

Manhattan

Manhattan 702843 Bedienungsanleitung

Aphex

Aphex 230 Bedienungsanleitung

AMD

AMD Phenom II Betriebshandbuch

Intel

Intel NUC 12 Pro Bedienungsanleitung

dbx

dbx Zone Pro 1260 Bedienungsanleitung

Galaxy

Galaxy GHDX2-2430S-24F4D Bedienungsanleitung

Intel

Intel AXXRMFBU4 Bedienungsanleitung

Kontron

Kontron DIMM-PC/MD Bedienungsanleitung

ST X-NUCLEO-SAFEA1B Betriebsanleitung

STEINWAY LYNGDORF

STEINWAY LYNGDORF SP-1 Bedienungsanleitung