HP QUERY Manuale utente

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

Indice

Altri manuali HP Hardware per computer

HP 64782 Manuale utente

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

HP E8402A Guida alla risoluzione dei problemi

HP Metal Jet S100 Manuale utente

HP Xw4600 - Workstation - 2 GB RAM Foglio di istruzioni

HP NVIDIA Tesla M2070Q Manuale utente

HP ML570 - ProLiant - G2 Manuale utente

HP 624189-B21 Manuale utente

HP Smart Array 5300A Manuale utente

HP Xw4600 - Workstation - 2 GB RAM Manuale utente

HP MPEGscope Portable Guida utente

HP ProLiant DL140 Manuale utente

HP Apollo r2800 Istruzioni per l'installazione

HP D7171A - NetServer - LPr Manuale di installazione e funzionamento

HP 6-Port SATA RAID Manuale utente

HP KVM Server Console Switch G2 Istruzioni utente

HP D7171A - NetServer - LPr Manuale utente

HP Pavilion xl700 - Desktop PC Manuale utente

HP Smart Array P400 Istruzioni utente

HP Integrity rx8620 Manuale utente

HP 381513-B21 - Smart Array P800 Controller... Manuale utente

HP HP-UX 10.20 Manuale utente

HP A3550A - High Availability Disk Arrays Model 20 Storage... Manuale utente

HP NC364T Manuale utente

Manuali Hardware per computer popolari di altre marche

EMC2

EMC2 VNX Series Manuale del proprietario

Panasonic

Panasonic DV0PM20105 Manuale utente

Mitsubishi Electric

Mitsubishi Electric Q81BD-J61BT11 Manuale utente

Gigabyte

Gigabyte B660M DS3H AX DDR4 Manuale utente

Raidon

Raidon iT2300 Manuale utente

National Instruments

National Instruments PXI-8186 Manuale utente

Hauppauge

Hauppauge WinTV-HVR-2250 Manuale utente

Kontron

Kontron CP6002 Manuale utente

Manhattan

Manhattan 702843 Manuale utente

Aphex

Aphex 230 Manuale utente

AMD

AMD Phenom II Manuale operativo

Intel

Intel NUC 12 Pro Manuale utente

dbx

dbx Zone Pro 1260 Manuale utente

Galaxy

Galaxy GHDX2-2430S-24F4D Manuale utente

Intel

Intel AXXRMFBU4 Manuale utente

Kontron

Kontron DIMM-PC/MD Manuale utente

ST X-NUCLEO-SAFEA1B Istruzioni operative

STEINWAY LYNGDORF

STEINWAY LYNGDORF SP-1 Manuale utente