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
- &an variable
- &CALCid variable
- &COUNT variable
- &DATE variable
- &n variable
- &PAGE variable
- &ROW variable
- &TIME variable
- @IF
A
B
- B edit code
- B preceded by _ (_B)
- BACKWARD command
- BATCH command
- BETWEEN keyword
- BETWEEN SQL keyword
(1), (2)
- bit data type edit codes
- blank lines
- after block on FORM.DETAIL panel
- FORM.BREAKn panel
(1), (2), (3)
- FORM.FINAL panel
- FORM.PAGE panel
(1), (2), (3), (4)
- in break footing text
(1), (2)
- in final text
- in footing
(1), (2), (3), (4)
- in heading
(1), (2), (3), (4)
- Boolean operators
- BOTTOM command
- break
- columns, outlining
- example of
- footing text
(1), (2), (3), (4), (5), (6)
- FORM.MAIN
- FORM.OPTIONS panel
- heading text
(1), (2), (3), (4), (5), (6), (7), (8)
- in reports
- indicated on form
- multiple levels
- specifying
- summary
(1), (2), (3)
- text
- BREAK usage codes
- BREAKn
- BREAKn usage code
- built-in SQL functions
- BW edit code
C
- C edit code
- CALC form panel
- CALCid usage code
- calculated values
- calculation
- calculation expression on FORM.CALC
- calculations
(1), (2)
- callable interface
- CANCEL command
- CANCEL function key
- canceling
- canceling a command or query
- canceling commands
- cancelling
- CDx edit code
- CHANGE command
- CHANGE function key
- CHANGE mode
- changing
- changing currency symbols
- CHAR
- character
- chart
- CHECK command
(1), (2)
- CICS
- CICS data queue
- CLEAR command
- codes
- column
- comma (,)
- command
- ADD
- BACKWARD
- BATCH
- BOTTOM
- CANCEL
- canceling
- cancelling
- CHANGE
- CHECK
- CICS
- CLEAR
- complete the report
- CONFIRM parameter
- CONNECT
(1), (2), (3)
- CONVERT
- DELETE
- DESCRIBE
- DISPLAY
- distributed unit of work
(1), (2), (3)
- DPRE
- DRAW
- EDIT
- END
- ENLARGE
- entering
- environments
- ERASE
- EXIT
- EXPORT
(1), (2), (3)
- EXTRACT
- format
- FORWARD
- GET GLOBAL
- GETQMF
- HELP
(1), (2)
- IMPORT
(1), (2), (3)
- in procedures
- INSERT
(1), (2)
- INTERACT
- interface
- ISPF
- LAYOUT
- LEFT
- line
- LIST
- MESSAGE
- NEXT
- parameters
- PREVIOUS
- PRINT
(1), (2)
- QMF
- REDUCE
- REFRESH
- RESET GLOBAL
- RESET object
- RETRIEVE
- RIGHT
- RUN
- SAVE
- SEARCH
- SET GLOBAL
- SET PROFILE
- SHOW
- SHOW COMMAND
- SHOW ENTITY
- SHOW FIELD
- SHOW VIEW
- SORT
- SPECIFY
- START
- STATE
- structure
- SWITCH
- syntax
- TOP
- used in remote data access
- command synonym
- comment
- comparative operators
- completing the report
- concatenation
- concatenation (||)
(1), (2)
- conditions
- CONDITIONS form panel
- confirmation panel
- CONNECT command
(1), (2), (3)
- constants in queries
- continuation
- control
- converting
- correcting mistakes on forms
- corresponding entry areas on forms
(1), (2)
- COUNT
- COUNT(DISTINCT) SQL keyword
- CPCT usage code
- create
- CREATE SQL keyword
(1), (2), (3)
- CREATE statement, SQL
- CSR (cursor) parameter
- CSUM usage code
- CT edit code
- cumulative
- cumulative percentage
- currency symbols
- current
- custom edit codes
- CW edit code
D
E
F
G
H
I
J
K
- K edit code
- keep block on page on FORM.DETAIL panel
- keywords, SQL
- ADD
- ALL
(1), (2)
- ALTER TABLE
(1), (2), (3)
- AND
- ANY
- AS
- AVG
- BETWEEN
(1), (2)
- COUNT
- COUNT(DISTINCT)
- CREATE
- CREATE SYNONYM
- CREATE TABLE
- CREATE VIEW
- DELETE
(1), (2)
- DELETE FROM
- DISTINCT
- DROP
- FROM
- GRANT
(1), (2)
- GROUP BY
- HAVING
- IN
(1), (2), (3)
- INSERT
(1), (2)
- INSERT INTO
(1), (2)
- IS
(1), (2), (3)
- LIKE
(1), (2), (3)
- MAX
- MIN
- NOT
- NOT NULL
(1), (2)
- NULL
(1), (2)
- OR
- ORDER BY
(1), (2), (3)
- REVOKE
(1), (2)
- SELECT
(1), (2), (3)
- SET
- SOME
- SUM
- SYNONYM
- TABLE
(1), (2)
- UNION
- UPDATE
(1), (2), (3)
- VALUES
(1), (2)
- VIEW
(1), (2)
- WHERE
(1), (2)
- WITH GRANT OPTION SQL keyword
- WITH REVOKE OPTION SQL keyword
L
M
N
O
P
- P edit code
- page
- breaks
- description
- entry area on FORM.MAIN panel
- footing
(1), (2), (3), (4), (5), (6), (7), (8)
- form panel
- heading
(1), (2), (3), (4), (5), (6), (7)
- number
- renumbering at highest break level
- splitting
- variable
(1), (2)
- PAGE
- panel variations, FORM.DETAIL panel
- parameters
- parentheses
- PASS NULLS
- PCT usage code
- percent sign (%)
- with LIKE SQL keyword
(1), (2)
- percentage
- performing calculations in reports, and REXX
- placement of break heading text
- plus sign (+)
- PREVIOUS command
- PREVIOUS function key
- PRINT command
- printing
- procedure
- and QMF temporary storage areas
- combining
- commands in
(1), (2), (3)
- continuation character
- comma (,) in procedures with logic
(1), (2)
- plus sign (+) in linear procedure
(1), (2)
- continuation line
(1), (2), (3), (4)
- displaying
- editing
- entering QMF commands
- erasing
- exit from
- exporting
(1), (2), (3)
- in QMF temporary storage
- inserting lines
- length
- linear
(1), (2)
- MESSAGE command
- naming
- printing
(1), (2)
- QMF command
- RESET GLOBAL command
- RESET object command
- REXX
- running
(1), (2), (3), (4)
- SAVE command
- scrolling
(1), (2)
- with logic
- with variables
- procedures
- profile
- PROFS
- prompt panel
- prompted query
- Prompted Query
(1), (2)
- punctuation of numeric data
- Put Tabular Data at Line (FORM.DETAIL panel)
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
- Q.SYSTEM_INI
- QBE query
- QMF
- QMF command
- qualified names
- query
- all columns
- calculated values
(1), (2)
- changing
- conditions
(1), (2)
- converting
- data definition
- data entry
- DELETE FROM
- deleting lines
- displaying
- DRAW command
- editing
- eliminate duplicate rows
- enlarging
- erasing
- exit from
- exporting
(1), (2), (3)
- expressions in
- grant authorization
- in QMF temporary storage
- including calculations in, example
- including SQL statements in
- inserting lines
- naming
- order rows in a report
(1), (2)
- printing
(1), (2)
- QBE
(1), (2)
- RESET GLOBAL command
- RESET object command
- revoke authorization
- running
- SAVE command
- scrolling
(1), (2), (3), (4)
- select
- SQL
(1), (2), (3)
- subqueries
- SWITCH command
- Query-by-Example (QBE)
- question mark (?)
- quick reference to form panels
- quit an operation (END command)
- quotation marks
R
- range, values within a
- re-display a command (RETRIEVE command)
- REDUCE command
- REFRESH command
- remote data
- remote location
- remote unit of work
- remove
- rename tables
- renumbering, pages, at highest break level
- reordering columns in a report
(1), (2)
- repeat detail heading
- report
- across summary
- area on FORM.COLUMNS panel
- asterisks in
- calculation expression examples
- changing
(1), (2), (3)
- creating
- creating a sample
- displaying
- entry areas
- exit from
- exporting
(1), (2), (3)
- footing
- FORM.MAIN panel
- formatting
(1), (2), (3)
- greater than characters in
- heading
- inserting
- nonentry areas
- of report columns
- printing
(1), (2)
- question marks in
- REDUCE command
- scrolling
(1), (2), (3)
- summary
(1), (2)
- symbols in
- text line width on FORM.OPTIONS panel
- width
- without data
- wrapping column data
- reserved words
(1), (2)
- reset
- RESET GLOBAL command
(1), (2)
- RESET object command
- restore an object to its initial state
- retain leading or trailing blanks (_B)
- RETRIEVE command
- REVOKE SQL keyword
- REXX
- REXX @IF function
- RIGHT command
- RIGHT function key
- rollback
- rows
- rules for evaluation of expressions
- RUN command
- running commands
(1), (2)
S
- SAA callable interface
- sample
- sample tables
(1), (2)
- SAVE command
- QMF temporary storage
(1), (2)
- scalar functions
(1), (2), (3)
- scrolling
- SEARCH
- SECOND scalar function
- secure data with a view
- select
- selection symbols
- separators
(1), (2), (3), (4)
- sequencing columns
- set
- SET GLOBAL command
(1), (2)
- SET PROFILE command
- SET SQL keyword
- SHOW command
- single-byte character set (SBCS)
- slash (/)
- SMALLINT data type
- SOME SQL keyword
- SORT command
- sorting sequence, ORDER BY
- spacing between tabular data lines
- special characters
- SPECIFY command
- Specify function key
(1), (2)
- SPECIFY function key
- specifying expressions defined on FORM.CALC panel
- SQL
- SQL/DS
- SQL keywords
- ADD
- ALL
(1), (2)
- ALTER TABLE
(1), (2), (3)
- AND
- ANY
- AS
- AVG
- BETWEEN
(1), (2)
- COUNT
- COUNT(DISTINCT)
- CREATE
- CREATE SYNONYM
- CREATE TABLE
- CREATE VIEW
- DELETE
(1), (2)
- DELETE FROM
- DISTINCT
- DROP
- FROM
- GRANT
(1), (2)
- GROUP BY
- HAVING
- IN
(1), (2), (3)
- INSERT
(1), (2)
- INSERT INTO
(1), (2)
- IS
(1), (2), (3)
- LIKE
(1), (2), (3)
- MAX
- MIN
- NOT
- NOT NULL
(1), (2)
- NULL
(1), (2)
- OR
- ORDER BY
(1), (2), (3)
- REVOKE
(1), (2)
- SELECT
(1), (2), (3)
- SET
- SOME
- SUM
- SYNONYM
- TABLE
(1), (2)
- UNION
- UPDATE
(1), (2), (3)
- VALUES
(1), (2)
- VIEW
(1), (2)
- WHERE
(1), (2)
- WITH REVOKE OPTION SQL keyword
- START command
- STATE command
- STDEV usage code
- stop your QMF session (EXIT command)
- STOPPROC parameter for MESSAGE command
- string
- subqueries
- SUBSTR scalar function
- SUM
- summary
- summary report
(1), (2)
- suppressing zero values
- SWITCH command
- SWITCH function key
- symbol
- synonym
- SYNONYM SQL keyword
- syntax diagrams
- system initialization procedure
T
U
V
W
X
Y
Z
[ Previous Page | Contents | Index ]