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

Chapter 3 QUERY/V COMMANDS
» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

spacerspacerspacer
spacer
spacer
  		 
 

Table of Contents

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
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
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
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
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
Null Values
Examples
UPDATE procedure
Syntax
Parameters
Discussion
Example
VERSION
Syntax
Discussion
XEQ
Syntax
Parameters
Discussion
Control Y
Examples

The following characteristics apply to all commands.

  • Command names can be spelled out completely or abbreviated. The minimum abbreviation is specified in the syntax under each command. In most cases, any subset of the characters between the full command name and the abbreviation may be used. For example, the syntax of the FORM command specifies FO[RM]. In this case, any of the following may be used: FORM, FOR, or FO. Refer to "Conventions Used in This Manual" for an explanation of the symbols used in the syntax in this manual.

  • Commands consist of English keywords and parameters (both required and optional).

  • QUERY processes only the first 72 characters of a line (record). Any remaining characters can be used for comments or sequencing information.

  • If the command you want to enter is longer than 72 characters, you can continue it on the next line by using an ampersand (&) as the last character on the current line. QUERY combines all lines connected with the & continuation character. Any blanks preceding the & are saved. Therefore, if you break a command name or other parameter with an &, the & should be adjacent to the last significant character with no intervening blanks. If a blank is necessary, it can be included at the beginning of the next line.

Refer to Table 2-1 “Command Categories and Functions” for a list of QUERY commands and their functions.

NOTE: During an actual session, passwords are not echoed back to the screen. The examples in this manual are shown in uppercase letters. When using QUERY, you can use either lower or uppercase letters except for passwords which must be entered exactly as defined by the data base administrator.


USING QUERY COMMANDS FROM AN XEQ FILE
  		 


ALTER  
Feedback to webmaster