HP QUERY Manual de usuario

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

Tabla de contenidos

Otros manuales de Hardware de computadora de HP

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

HP D7171A - NetServer - LPr Manual de usuario

HP 6600 FIP-20 Flex Instrucciones de montaje

HP StorageWorks XP128 Manual de usuario

HP 8886 - Photosmart Camera Dock Digital Docking... Manual de usuario

HP Smart Array P400 Instrucciones de uso

HP FlexFabric 12908E LSXM108XFAN Manual de usuario

HP E5000 Manual de usuario

HP 64793 Series Manual de usuario

HP 6-Port SATA RAID Manual de usuario

HP Xw460c - ProLiant - Blade Workstation Manual de usuario

HP ML570 - ProLiant - G2 Manual de usuario

HP ProLiant DL140 Manual de usuario

HP RDX USB 3.0 Manual de instrucciones

HP Z400 - Workstation Manual de usuario

HP 3000 Series Manual

HP Nc6400 - Compaq Business Notebook Manual de usuario

HP HPE LSWM2XGT2PM Manual de usuario

HP Xw4400 - Workstation - 2 GB RAM Manual de usuario

HP 82718A Manual de usuario

HP 81200 Manual de usuario

HP Metal Jet S100 Manual de usuario

HP 381513-B21 - Smart Array P800 Controller... Manual de usuario

HP StorageWorks FC1142SR Manual de usuario

Manuales populares de Hardware de computadora de otras marcas

EMC2

EMC2 VNX Series Manual del propietario

Panasonic

Panasonic DV0PM20105 Manual de usuario

Mitsubishi Electric

Mitsubishi Electric Q81BD-J61BT11 Manual de usuario

Gigabyte

Gigabyte B660M DS3H AX DDR4 Manual de usuario

Raidon

Raidon iT2300 Manual de usuario

National Instruments

National Instruments PXI-8186 Manual de usuario

Hauppauge

Hauppauge WinTV-HVR-2250 Manual de usuario

Kontron

Kontron CP6002 Manual de usuario

Manhattan

Manhattan 702843 Manual de usuario

Aphex

Aphex 230 Manual de usuario

AMD

AMD Phenom II Manual operacional

Intel

Intel NUC 12 Pro Manual de usuario

dbx

dbx Zone Pro 1260 Manual de usuario

Galaxy

Galaxy GHDX2-2430S-24F4D Manual de usuario

Intel

Intel AXXRMFBU4 Manual de usuario

Kontron

Kontron DIMM-PC/MD Manual de usuario

ST X-NUCLEO-SAFEA1B Instrucciones de funcionamiento

STEINWAY LYNGDORF

STEINWAY LYNGDORF SP-1 Manual de usuario