QUERY/V Reference Manual: HP 3000 MPE/iX Computer Systems

»

Technical documentation


	Complete book in PDF


»	Feedback

» Table of Contents

HP Part Number: 32650-90387

Edition:

Published: Printed in U.S.A. OCT 98

Table of Contents

1 INTRODUCING QUERY/V

STRUCTURE OF THE DATA BASE

Fully-Qualified Data Item Names
Data Types
Data Values
Compound Data Items
Data Set Relations
Sample Data Base

MODES OF ACCESS

Logging and Mode Selection

QUERY CHARACTER SET

2 USING QUERY/V

USING QUERY IN SESSION MODE

Running QUERY
Accessing Data
Using the Break Key
Using Control Y
Exiting QUERY

USING QUERY IN JOB MODE

Discussion

QUERY COMMANDS

IDENTIFYING THE QUERY ENVIRONMENT

LOCATING DATA

MODIFYING DATA

REPORTING DATA

USING PROCEDURES IN A PROC-FILE

USING QUERY COMMANDS FROM AN XEQ FILE

3 QUERY/V COMMANDS

Syntax
Parameter
Discussion
ALTER - INSERT STATEMENT
Syntax
Parameters
Discussion
Example
ALTER - REPLACE STATEMENT
Syntax
Parameters
Example
ALTER - DELETE STATEMENT
Syntax
Parameters
Discussion
Example
ALTER - END STATEMENT
Syntax
Discussion
Example

Syntax
Parameters
Discussion

Syntax
Parameter
Discussion

Syntax
Parameter
Discussion
Example

Syntax
Parameters
Discussion
File Input
Example
Terminal Input
Examples

CREATE SPACE

Syntax
Discussion
Example

Syntax
Parameter
Discussion
Passwords and Access Modes
Example

Syntax
Parameter
Discussion
Data Set Selection Rules
Automatic Data Set List Additions
Examples

Syntax
Parameter
Discussion
Data Base Selection Rules
Automatic Data Base List Additions
Example

Syntax
Discussion
Examples
Example 2

Syntax
Parameter
Discussion
Example

Syntax
Parameters
Discussion
Displaying to a File
Example

DISPLAY LIST

Syntax
Discussion
Example

Syntax
Discussion
Example

Syntax
Parameters
Methods of Retrieval
U and X Type Values
Logical Connectors
Compound Items
Multiple Values
Using Null Values
Examples
Generic Search

Syntax
Parameters
Discussion
Example

Syntax
Parameters
Discussion

FIND procedure

Syntax
Parameters
Discussion
Example

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion
Examples

Syntax
Parameters
Discussion
Data Item Types
Data Set Equivalence
Using the @ Parameter
Propagating @ Signs

JOIN procedure

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion
Listing Format
Listing a Subset of the Data
Determining the Data Set to be Used
The Relation of LIST and FIND
Examples

Syntax
Parameters
Discussion
Example

Syntax
Parameter
Discussion
Example

Syntax
Parameter
Discussion
Example

Syntax
Parameters
Discussion
Example
Using the $MISSING Parameter
Example
Methods of Retrieval

MULTIFIND ALL

Syntax
Parameters
Discussion
Example

MULTIFIND procedure

Syntax
Parameters
Discussion

Syntax
Options
Discussion
Using the MPE FILE Command
Examples

Syntax
Parameters
Discussion

PROC-FILE =

Syntax
Parameters
Discussion
Examples

Syntax
Parameters
Discussion
Parameters
Examples

Syntax
Discussion

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion
Overpunch Characters
Examples

REPORT procedure

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion
Saving Multiple Data Set Select Files

Syntax
Discussion

Syntax
Parameters

Syntax
Parameters
Discussion
Example

SUBSET procedure

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion

Syntax
Parameters
Discussion

Syntax
Discussion
Examples

Syntax
Parameters
Discussion
Example
Using Quotation Marks
Null Values
Real Number Values
Detail Data Sets
Terminating UPDATE ADD
Example

UPDATE DELETE

Syntax
Discussion
Master Data Entries

UPDATE REPLACE

Syntax
Parameters
Discussion
Null Values
Examples

UPDATE procedure

Syntax
Parameters
Discussion
Example

Syntax
Discussion

Syntax
Parameters
Discussion
Control Y
Examples

A QUERY/V MESSAGES

B QUERY/3000 SPECIFICATIONS

LIMITS USED BY QUERY
FILES USED BY QUERY

C ACCESSING A REMOTE DATA BASE

METHOD 1: QUERY ON REMOTE SYSTEM
METHOD 2: QUERY ON LOCAL SYSTEM
METHOD 3: USING A DATA-BASE-ACCESS FILE

D NATIVE LANGUAGE SUPPORT

EFFECTS OF NLS ON QUERY

E SELF-DESCRIBING FILES

USER LABELS

Global Information Label Format
Item Description Label Format

F USER-DEFINED PROCEDURES

Parameters
Examples
MPROC Procedure
SPL - MPROC Procedure
COBOL - MPROC Procedure
COBOL Notes
PASCAL - MPROC Procedure
PASCAL Notes
Additional Comments
FORTRAN - MPROC Procedure
QPROC Procedure
SPL - QPROC Procedure
COBOL - QPROC Procedure

G ASCII CHARACTER SET

List of Figures

1-1 ORDERS Data Base Structure
1-2 Sample Entry Values
1-3 IMAGE/QUERY Environments
2-1 Job Mode Operation
3-1 FORM ITEMS Output
3-2 FORM PATHS Output
3-3 FORM SETS Output
3-4 FORM data item name Output
3-5 FORM data set name Output
3-6 FORM Output
3-7 General Report Format
3-8 Sample Report
3-9 Sample Output Using Numeric Edit Masks
3-10 REPORT Procedure Named SHIPMNTS
3-11 Billing Report From an XEQ File
C-1 Using Method 1
C-2 Using Method 2
C-3 Using Method 3

List of Tables

1-1 Data Item Types and Values
2-1 Command Categories and Functions
2-2 Procedure Commands
2-3 Commands Used to Define Procedures
3-1 FIND Command Relational Operators
3-2 MATCHING Pattern Operators
3-3 LIST Command Relational Operators
3-4 Field Widths of Data Item Types
3-5 REPORT Statements
3-6 REPORT Statement Parameters
3-7 Numeric Edit Mask Characters
3-8 Numeric Edit Mask Combinations
3-9 REPORT ALL Options
3-10 Overpunch Characters
3-11 Output of P and Z Type Values
3-12 Retrieval Command Relational Operators
B-1 General
B-2 JOIN Command
B-3 LIST Command
B-4 PROC-FILE Command
B-5 REPORT Command
B-6 Retrieval Command (FIND, MULTIFIND, SUBSET)
B-7 SAVE Command
B-8 TRANSMEMO Command
B-9 Updating Command (UPDATE ADD and UPDATE REPLACE)
B-10 Files Equated by the User
B-11 Files Not Equated by the User (Temporary Files)
B-12 Files Created by the User and/or Specified to be Built by QUERY
B-13 Unnamed Scratch Files (Temporary Files)
D-1 Commands for Language-Dependent Information


Feedback to webmaster