Index
Special characters
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Special characters
A
- access
- accessing data, methods of
- add
- addition of dates and times
- administrator, QMF
- alias
- alias, in place of three-part name
- ALL keyword
- AND keyword
- AO keyword
- application requester
(1), (2), (3)
- application server
(1), (2)
- arithmetic
(1), (2)
- ascending order, sorting sequence
(1), (2)
- ASIS formatting type
- asterisk (*), placement of cursor
(1), (2)
- authorization
- automatic interrupt
- AVG column function
- AVG column function in SQL
- AVG keyword
B
C
- calculated values
- CANCEL command
- canceling a command or query
- case operand for Prompted Query
- changing
- CHAR
- CHAR scalar function
- character
- CHART database object
- charts
- CHECK command
- CICS
- CLIST
- CLIST used with editor
- CLOB
- CMS
- codes
- column
- column functions
(1), (2), (3), (4), (5), (6), (7), (8)
- column names
- changing
- distinguishing between
- finding
- columns
- command
- command line
- comment
- COMMENTS box
(1), (2)
- concatenation, rules for
- conditions
- CONDITIONS box
(1), (2), (3)
- CONNECT command
- connecting
- constants
- conversion functions
- conversion scalar functions
- CONVERT command
- converting
- converting queries to SQL
- copy tables
(1), (2)
- correcting, saved query
- correlation names
- COUNT
- COUNT column function
(1), (2)
- counting number of values in a column
- creating
- currency symbol
- current location
- CURRENT SQLID
(1), (2)
D
- D operator
- data
- DATA database object
- Data Extract
- data type
- data types
- database
- Database Status Panel
- DATE
- DATE scalar function
- date/time
- DAY scalar function
- DAYS scalar function
- DB2/6000 for AIX
- DB2 for MVS
- DB2 for VM
- DBCLOB
- DBCS (double-byte character set)
- DCF (Document Composition Facility)
- DECIMAL
- DECIMAL scalar function
- decrementing dates, times, or timestamps
- default
- defining
- DELETE
- DELETE command
- deleting
- descending order, sorting sequence
(1), (2)
- detail blocks
- DIGITS scalar function
- display
- DISPLAY command
- displaying
- distributed unit of work
(1), (2)
- division sign (/)
- DO keyword
- Document Composition Facility
- document interface
- double-byte character set (DBCS)
- double byte data
- DRAW command
(1), (2), (3), (4)
- Draw function key
- drawing
- DSN option, GETQMF
- DSQAO_CONNECT_LOC
- DSQDC_COST_EST
- DSQSDBNM program parameter
(1), (2)
- duplicate rows
- duplicate rows in reports, eliminating
(1), (2), (3)
- durations
- DXT (Data Extract)
E
F
G
H
I
J
K
L
M
N
O
P
Q
- Q.APPLICANT sample table
- Q.INTERVIEW sample table
- Q.ORG sample table
- Q.PARTS sample table
- Q.PRODUCTS sample table
- Q.PROJECT sample table
- Q.STAFF sample table
- Q.SUPPLIER sample table
- QBE (Query-By-Example)
- QMF
- qualifiers, to distinguish between columns
- query
- adding
- calculated values
- calculated values in
(1), (2)
- changing
- changing saved
- conditions
- converting
- creating using Prompted Query
(1), (2), (3)
- creating using SQL
(1), (2)
- data entry
(1), (2)
- definition
- deleting
- eliminating duplicate rows
(1), (2)
- erasing from database
- example elements
- expressions
- format
- joining multiple columns in
- listing
- making reusable
(1), (2)
- model
- multiple table
- non-displaying, correcting
- ordering rows in a report
(1), (2)
- Prompted Query
- Query-by-Example
- resetting
- retrieving from database
- reusing
- row conditions in
(1), (2), (3), (4)
- rows
- running
(1), (2), (3)
- saving
(1), (2), (3)
- select
- selecting
- all columns
(1), (2), (3), (4)
- columns for a Prompted Query
- from multiple tables
(1), (2), (3)
- rows for a Prompted Query
- specific columns
(1), (2), (3)
- specific rows
(1), (2), (3), (4)
- table for a Prompted Query
- selecting on conditions
- sharing with other users
(1), (2), (3)
- sorting rows in
(1), (2)
- SQL
- starting
(1), (2)
- substitution variables in
(1), (2)
- with DBCS data
- with substitution variable data
- Query-by-Example
(1), (2)
- QUERY database object
- quotation marks
R
S
- sample tables
(1), (2), (3)
- SAVE command
- saved query, changing
- saving
- SAY statements to specify REXX variables
- scalar functions
(1), (2), (3)
- SCATTER chart format
- SCRIPT/VS
- SECOND scalar function
- select
- selecting
(1), (2), (3), (4)
- selection symbols
- SET GLOBAL command
- SET PROFILE command
- sharing
- shift in delimiter (SI)
(1), (2)
- shift in delimiter character
- shift out delimiter (SO)
(1), (2)
- shift out delimiter character
- shortened form panel names
- SHOW command
- SHOW FIELD
- SHOW FIELD function key
- SHOW FORM command
- SHOW GLOBAL command
(1), (2)
- Show Global Variable panel
- SHOW GLOBALS command
(1), (2)
- SI character
- size limits for chart data
- slash (/)
- SO character
- solutions to exercises for QBE
- sort order
- sorting sequence
- special characters in Prompted Query
- special conditions
- SQL
- SQL (Structured Query Language)
- SQL/DS
- SQL query
- starting
- status, database panel
- string
- string functions
(1), (2)
- string of characters with LIKE
- subquery
- substitution
- substitution values
- substitution variables
- SUBSTR scalar function
- SUBSTR string function
- subtotals
- subtraction of dates and times
(1), (2)
- SUM
- SUM column function
- summary
- summary conditions
- summary functions
- SURFACE chart format
- synonym
T
U
V
W
X
Y
Z
[ Previous Page | Contents | Index ]