HPlogo QUERY/iX Reference Manual

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

MPE documents

Complete PDF
Table of Contents

E0300 Edition 7 ♥
E1098 Edition 6

HP Part Number: 32650-90889

Edition: Edition 7

Published: E0300

Notice

Table of Contents
Preface
1 INTRODUCING QUERY/iX
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
PASSWORDS
QUERY CHARACTER SET
MPE FILES
2 USING QUERY/iX
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/iX COMMANDS
ALTER
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
ASSIGN
Syntax
Parameters
Discussion
CLOSE
Syntax
Parameter
Discussion
COMMENT
Syntax
Parameter
Discussion
Example
CREATE
Syntax
Parameters
Discussion
File Input
Example
Terminal Input
Examples
CREATE SPACE
Syntax
Discussion
Example
DATA-BASE=
Syntax
Parameter
Discussion
Passwords and Access Modes
Example
DATA-SETS=
Syntax
Parameter
Discussion
Data Set Selection Rules
Automatic Data Set List Additions
Examples
DBLIST=
Syntax
Parameter
Discussion
Data Base Selection Rules
Automatic Data Base List Additions
Example
DEFINE
Syntax
Discussion
Examples
Example 2
DESTROY
Syntax
Parameter
Discussion
Example
DISPLAY
Syntax
Parameters
Discussion
Displaying to a File
Example
DISPLAY LIST
Syntax
Discussion
Example
EXIT
Syntax
Discussion
Example
FIND
Syntax
Parameters
Methods of Retrieval
U and X Type Values
Logical Connectors
Compound Items
Multiple Values
Using Null Values
Examples
Generic Search
FIND ALL
Syntax
Parameters
Discussion
Example
FIND CHAIN
Syntax
Parameters
Discussion
FIND procedure
Syntax
Parameters
Discussion
Example
FORM
Syntax
Parameters
Discussion
Dynamic Dataset Capacities
4 QUERY/iX COMMANDS (cont)
HELP
Syntax
Parameters
Discussion
Examples
JOIN
Syntax
Parameters
Discussion
Data Item Types
Data Set Equivalence
Using the @ Parameter
Propagating @ Signs
JOIN procedure
Syntax
Parameters
Discussion
LANGUAGE=
Syntax
Parameters
Discussion
LIST
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
LISTREDO
Syntax
Parameters
Discussion
Example
MODE=
Syntax
Parameter
Discussion
Example
MULTIDB
Syntax
Parameter
Discussion
Example
MULTIFIND
Syntax
Parameters
Discussion
Example
Using the $MISSING Parameter
Example
Methods of Retrieval
MULTIFIND ALL
Syntax
Parameters
Discussion
Example
MULTIFIND procedure
Syntax
Parameters
Discussion
OUTPUT=
Syntax
Options
Discussion
Using the MPE FILE Command
Examples
5 QUERY/iX COMMANDS (cont)
PASSWORD=
Syntax
Parameters
Discussion
PROC-FILE =
Syntax
Parameters
Discussion
Examples
REDO
Syntax
Parameters
Discussion
Parameters
Examples
RELEASE
Syntax
Discussion
RENAME
Syntax
Parameters
Discussion
REPORT
Syntax
Parameter
Discussion
REPORT Statements
Print Position
Skipping and Spacing
Designing a Report
REPORT - HEADER STATEMENTS
Syntax
Parameters
Discussion
REPORT - DETAIL STATEMENTS
Syntax
Parameters
Discussion
REPORT - EDIT STATEMENTS
Syntax
Parameters
Alphanumeric Edit Masks
Numeric Edit Masks
Real Numbers
Example
REPORT - SORT STATEMENTS
Syntax
Parameters
Control Breaks
Major to Minor Sort Fields
Maximum Number of Sort Items
Example
REPORT - GROUP STATEMENTS
Syntax
Parameters
Discussion
REPORT - TOTAL STATEMENTS
Syntax
Parameters
Discussion
The NOREPEAT Option
REPORT - REGISTER STATEMENTS
Syntax
Parameters
Discussion
Using QUERY Registers
Initializing Registers
Register and Data Types
Numeric Literals
REPORT - OUTPUT CONTROL STATEMENTS
Example
6 QUERY/iX COMMANDS (cont)
REPORT ALL
Syntax
Parameters
Discussion
Overpunch Characters
Examples
REPORT procedure
Syntax
Parameters
Discussion
SAVE
Syntax
Parameters
Discussion
Saving Multiple Data Set Select Files
SETLOCKS
Syntax
Discussion
SHOW
Syntax
Parameters
SUBSET
Syntax
Parameters
Discussion
Example
SUBSET procedure
Syntax
Parameters
Discussion
TRANSBEGIN
Syntax
Parameters
Discussion
TRANSEND
Syntax
Parameters
Discussion
TRANSMEMO
Syntax
Parameters
Discussion
UNDO
Syntax
Discussion
Examples
UPDATE ADD
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
Session Mode
Job Mode
Null Values
Examples
UPDATE procedure
Syntax
Parameters
Discussion
Example
VERSION
Syntax
Discussion
XEQ
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
FILE DATA
USER LABELS
Global Information Label Format
Item Description Label Format
ITEM NAMES
F USER-DEFINED PROCEDURES
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
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 ALL INDEXES
3-2 FORM ITEMS Output
3-3 FORM PATHS Output
3-4 FORM SETS Output
3-5 FORM data item name Output
3-6 FORM data set name Output
3-7 FORM DATA - Key and Search Items
3-8 FORM Example
5-1 General Report Format
5-2 Sample Report
5-3 Sample Output Using Numeric Edit Masks
6-1 REPORT Procedure Named SHIPMNTS
6-2 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/functions
4-1 LIST Command Relational Operators
4-2 Field Widths of Data Item Types
5-1 REPORT Statements
5-2 REPORT Statement Parameters
5-3 Numeric Edit Mask Characters
5-4 Numeric Edit Mask Combinations
6-1 REPORT ALL Options
6-2 Overpunch Characters
6-3 Output of P and Z Type Values
6-4 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
List of Examples
5-1 Title not available (Discussion)
5-2 Title not available (Discussion)




Appendix F Procedures


Preface