HP QUERY Manuel utilisateur

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 des matières

Autres manuels HP Matériel informatique

HP 64782 Manuel utilisateur

HP Z210 Series Manuel utilisateur

HP MCS G2 Guide d'installation

HP NVIDIA Tesla M2070Q Manuel utilisateur

HP HP 27113A Manuel

HP MPIO Manuel d'installation et d'exploitation

HP MCS-200 Manuel utilisateur

HP Compaq t5500 Manuel utilisateur

HP 10512 Instructions d'installation

HP Model 744 - VME Workstation Manuel utilisateur

HP 405132-B21 Manuel utilisateur

HP E2465A PowerPC 604 PGA Manuel utilisateur

HP Notebook Series Manuel utilisateur

HP Xw4600 - Workstation - 2 GB RAM Manuel utilisateur

HP A5830AF-48G Manuel utilisateur

HP A3550A - High Availability Disk Arrays Model 20 Storage... Manuel utilisateur

HP Z400 - Workstation Manuel utilisateur

HP OmniBook 3100 Manuel utilisateur

HP AF079A Guide d'installation

HP JG587A Manuel utilisateur

HP Vectra VE4 Manuel utilisateur

HP 98625A Manuel utilisateur

HP E5000 Manuel utilisateur

HP 381513-B21 - Smart Array P800 Controller... Manuel utilisateur

Manuels Matériel informatique populaires d'autres marques

EMC2

EMC2 VNX Series Manuel du propriétaire

Panasonic

Panasonic DV0PM20105 Manuel utilisateur

Mitsubishi Electric

Mitsubishi Electric Q81BD-J61BT11 Manuel utilisateur

Gigabyte

Gigabyte B660M DS3H AX DDR4 Manuel utilisateur

Raidon

Raidon iT2300 Manuel utilisateur

National Instruments

National Instruments PXI-8186 Manuel utilisateur

Hauppauge

Hauppauge WinTV-HVR-2250 Manuel utilisateur

Kontron

Kontron CP6002 Manuel utilisateur

Manhattan

Manhattan 702843 Manuel utilisateur

Aphex

Aphex 230 Manuel utilisateur

AMD

AMD Phenom II Manuel d'exploitation

Intel

Intel NUC 12 Pro Manuel utilisateur

dbx

dbx Zone Pro 1260 Manuel utilisateur

Galaxy

Galaxy GHDX2-2430S-24F4D Manuel utilisateur

Intel

Intel AXXRMFBU4 Manuel utilisateur

Kontron

Kontron DIMM-PC/MD Manuel utilisateur

ST X-NUCLEO-SAFEA1B Mode d'emploi

STEINWAY LYNGDORF

STEINWAY LYNGDORF SP-1 Manuel utilisateur