|
|
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
- Dynamic Dataset Capacities
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.
|
|