Programmer's Guide to the Pro*Ada Precompiler
Library
Product
Contents
Index
Index
@
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
@
active set, about
[
2
]
changing
how identified
when no longer defined
Ada
advantages
library
ALLOCATE, precompiler statement
allocation, of a cursor variable
ANSI mode, must use SQL_STANDARD datatypes
AREASIZE option, obsolete options
array
about
elements of
host arrays
[
2
]
operations
arrays.pad
AT clause
in CONNECT statement
in DECLARE CURSOR statement
use of
bar, vertical
batch fetches
example of
number of rows returned by
BIND_LIST_SIZE, function
BIND_VARIABLE_LENGTH, function
BIND_VARIABLE
function
procedure
binding
about
in dynamic SQL method 4
of host arrays
callsp.pad
CHAR datatype
column, maximum width
internal
character data, how handled
child cursor
CLOSE statement
DECLARE statement, FETCH statement, OPEN statement
dependence on precompiler options
example of
purpose of
[
2
] [
3
]
syntax diagram for
usage notes for
column list
in INSERT statements
when permissible to omit
COMMIT statement
delimits transaction
effect of
example of
fetching across
purpose of
[
2
]
RELEASE parameter in
ROLLBACK statement, SAVEPOINT statement
syntax diagram for
usage notes for
using
using in a PL/SQL block
where to place
commits
automatic
explicit versus implicit
function of
communication over a network
compilation units, restrictions in Pro*Ada
concat.pad
concurrency, about
conditional precompilation
defining symbols for
example of
purpose of
using predefined symbols
CONFIG precompiler option
configuration file
advantages
system versus user
CONNECT statement
AT clause in
purpose of
requirements for
syntax diagram for
usage notes for
USING clause in
using to log on
connecting to ORACLE
automatically
concurrently
example of
via SQL*Net
connection
concurrent
default versus non-default
implicit
naming
context area
about
association with cursors
opening
context block, about
CONTINUE action
in the WHENEVER statement
result of
CURRENT OF clause
example of
mimicking with ROWID
[
2
]
purpose of
current row
about
using FETCH to retrieve
CURRVAL pseudocolumn
cursor
cursor variables
allocating
declaring
opening
restrictions on
cursors
about
analogy for
association with queries
cache
[
2
]
child
closing before reopening
control statements
declaring
declaring more than one
explicit
explicit versus implicit
for multi-row queries
how handling affects performance
operations
parent
purpose of
reopening
restrictions on declaring
rules for naming
scope of
sequence of statements
statements for manipulating
types
when closed automatically
cursvar.pad
cursvar.sql
data definition statements
executed using PREPARE in dynamic SQL
in transactions
data integrity
about
ensuring
data locks
database link
creating synonym for
defining
example using
where stored
database
default
naming
datatypes
about
external
internal
DATE datatype
default values
external
internal
internal format
DBMS option
syntax for
usage notes for
values for
deadlock
about
effect on transactions
how broken
DECIMAL datatype, external (not used in Pro*Ada)
declaration
of cursors
of host variables
of indicator variables
declarative SQL statements
embedded SQL statements
in transactions
uses
where allowed
DECLARE CURSOR statement
AT clause in
purpose of
syntax diagram for
usage notes for
DECLARE DATABASE statement
purpose of
syntax diagram for
usage notes for
declare section
SQL declare section
things allowed in
use is optional
usernames and passwords
DECLARE STATEMENT statement
purpose of
syntax diagram for
usage notes for
DECLARE statement
CLOSE statement
example of
FETCH statement
OPEN statement
purpose of
required placement of
use in dynamic SQL method 3
DECLARE TABLE statement
purpose of
syntax diagram for
usage notes for
default
connection
database
define operation, dynamic SQL method 4
DEFINE option
default value for
purpose of
syntax for
usage notes for
DELETE statement
example of
purpose of
[
2
]
syntax diagram for
usage notes for
using host arrays in
WHERE clause in
demerror.pad
demo program
array bind example
FETCH example
method 2 example
stored PL/SQL procedure example
derive.pad
desc.pad, sample program
DESCRIBE statement
purpose of
syntax diagram for
usage notes for
distributed processing
support for
using SQL*Net for
DO action
in the WHENEVER statement
result of
dummy host variables, Placeholders
dyn1.pad
dyn3.pad
dyn4.pad
dynamic PL/SQL
rules for
versus dynamic SQL
dynamic SQL method 1
commands used with
description of
how to use
requirements for
sample program
use of PL/SQL with
use of the EXECUTE IMMEDIATE statement with
dynamic SQL method 2
commands used with
description of
example of
how to use
requirements for
sample program
use of PL/SQL with
use of the EXECUTE statement with
use of the PREPARE statement with
dynamic SQL method 3
commands used with
compared to method 2
how to use
requirements for
sample program
sequence of statements used with
use of PL/SQL with
use of the DECLARE statement with
use of the FETCH statement with
use of the OPEN statement with
use of the PREPARE statement with
dynamic SQL method 4
basic steps
requirements
sample describe program
sample program
steps in detail
dynamic SQL
about
advantages and disadvantages of
binding of host variables in
cannot use cursor variables with
choosing the right method
guidelines for
how processed
methods
overview
overview of
parsing of
requirements for
use of PL/SQL with
use of placeholders in
uses for
versus static SQL statements
when to use
with descriptors
embedded PL/SQL
advantages of
checking the syntax of
cursor FOR loop
embedded block terminator
example of
[
2
]
overview
packages
PL/SQL tables
procedures and functions
requirements for
support for SQL
user-defined records
using %TYPE
using to improve performance
where allowed
with Pro*Ada
embedded SQL
about
CLOSE
COMMIT
CONNECT
DECLARE CURSOR
DECLARE DATABASE
DECLARE STATEMENT
DECLARE TABLE
DELETE
DESCRIBE
ENABLE THREADS
EXECUTE
EXECUTE IMMEDIATE
EXECUTE plsql_block
FETCH
INSERT
OPEN
PREPARE
referencing host variables
referencing indicator variables
requirements for
ROLLBACK
SAVEPOINT
SELECT
syntax
UPDATE
VAR
WHENEVER
ENABLE THREADS statement
purpose of
syntax diagram for
usage notes for
enqueues, locking
error handling
alternatives
key components
main benefit of
meaning for the ORACLE Precompilers
need for
SQLCA
use of indicator variables in
use of ROLLBACK statement in
WHENEVER statement
error reporting
key components of
use of parse error offset in
use of rows-processed count in
use of status codes in
use of warning flags in
ERROR_CODE, function
ERRORS option
default value for
purpose of
syntax for
usage notes for
exception, PL/SQL
EXEC ORACLE statement
DEFINE
ELSE
ENDIF
IFDEF
IFNDEF
syntax
uses for
using to enter options inline
EXEC SQL clause, used to embed SQL
EXEC TOOLS, form variable
[
2
]
GET
GET CONTEXT
MESSAGE
SET
SET CONTEXT
statements
user exits
[
2
]
executable SQL statements
embedded SQL statements
purpose of
repeating
types
uses
where allowed
EXECUTE IMMEDIATE statement
purpose of
syntax diagram for
usage notes for
use in dynamic SQL Method 1
EXECUTE plsql_block statement
purpose of
syntax diagram for
usage notes for
EXECUTE statement
purpose of
syntax diagram for
usage notes for
use in dynamic SQL method 2
execution
path
plan
EXPLAIN PLAN statement
function of
using to improve performance
explicit logons
description of
implicit logons
multiple
single
external datatypes
CHAR
DATE
DECIMAL
description of
FLOAT
INTEGER
list of
LONG
LONG RAW
LONG VARCHAR
LONG VARRAW
MLSLABEL
NUMBER
RAW
ROWID
STRING
UNSIGNED
VARCHAR
VARCHAR2
VARNUM
VARRAW
FETCH statement
example
example of
INTO clause in
purpose of
[
2
] [
3
]
syntax diagram for
usage notes for
use in dynamic SQL method 3
FETCH, dynamic SQL description
flags, warning flags
FLOAT datatype
FOR clause
example of using
purpose of
requirements for
syntax diagram for
usage notes for
using with host arrays
variable
FOR UPDATE OF clause
locking rows with
purpose of
when to use
forward references, why not allowed
full scan, description of
generic procedures
generic software components
GENXTB form
use with user exits
using
GENXTB utility
how to run
use with user exits
GOTO action
in the WHENEVER statement
result of
guidelines
for creating applications
for dynamic SQL
for host variables
for indicator variables
for separate precompilations
for the WHENEVER statement
for transactions
for user exits
HOLD_CURSOR option
default value for
purpose of
syntax for
usage notes for
using to improve performance
what it affects
holdcurs.pad
host arrays
about
advantages of
binding
declaring
deleting with
in the DELETE statement
in the INSERT statement
in the SELECT statement
in the UPDATE statement
in the WHERE clause
inserting with
matching sizes of
maximum size of
restrictions on
restrictions on
[
2
]
selecting into
updating with
used as input host variables
used as output host variables
using in SQL statements
using the FOR clause with
using to improve performance
using with PL/SQL
when not allowed
host variables, about
[
2
]
assigning values to
compatibility with database columns
datatypes allowed for
declaring
derived types
dummy
guidelines for
in user exits
input
input versus output
output
purpose of
referencing
requirements for
rules for naming
scope in PL/SQL
using in embedded SQL
using in PL/SQL
[
2
]
where allowed
IAF GET statement
about
example of using
specifying block and field names in
IAF PUT statement
example of
in user exits
purpose of
syntax
IAP in SQL*Forms, purpose of
identifiers, ORACLE, how to form
implicit logons
description of
explicit logons
multiple
single
IN OUT parameter mode
IN parameter mode
in-doubt transaction
INAME option
default value for
purpose of
syntax for
usage notes for
INCLUDE statement, using to copy a file of inline options
indexes, using to improve performance
indicator arrays
definition of
example of using
using
INDICATOR keyword
about
when it must be used
indicator variables
about
assigning values to
association with host variables
declaring
example of using
function of
guidelines for
interpreting values of
referencing
requirements for
using
using in embedded SQL
using in PL/SQL
[
2
]
using to detect null values
using to detect truncated values
using to insert null values
using to return null values
using to test for nulls
INDICATOR_VARIABLE_LENGTH, function
INDICATOR_VARIABLE, function
INDICATOR
keyword
when MODE=ANSI
input host variables
about
assigning values to
host variables
output host variables
restrictions on
uses for
where allowed
insert of no rows, cause of
INSERT statement
column list in
example of
INTO clause in
purpose of
purpose of
requirements for
syntax diagram for
usage notes for
using host arrays in
VALUES clause in
INTEGER datatype
internal datatypes
CHAR
DATE
description
list of
LONG
LONG RAW
MLSLABEL
NUMBER
pseudocolumns
RAW
ROWID
VARCHAR2
INTO clause
for output host variables
in FETCH statements
in INSERT statements
in SELECT statements
used with FETCH instead of SELECT
IRECLEN option
default value for
purpose of
syntax
usage notes for
keywords
LEVEL pseudocolumn
library units
about
restrictions in Pro*Ada
link, link
LNAME option
default value for
purpose of
syntax
usage notes for
location transparency
LOCK TABLE statement
example of
locking tables with
NOWAIT parameter in
purpose of
specifying lock mode in
locking
about
explicit versus implicit
modes of
overriding default
privileges needed to obtain
row locks, table locks
table versus row
uses for
with FOR UPDATE OF
with the LOCK TABLE statement
logon, automatic
[
2
]
concurrent
connecting to ORACLE
explicit
LONG datatype
column, maximum width
compared with CHAR
external
internal
restrictions
where allowed
LONG RAW datatype
column, maximum width
compared with LONG
external
restrictions
LONG RAW, internal datatype
LONG VARCHAR datatype
LONG VARRAW datatype
LRECLEN option
default value for
purpose of
syntax
usage notes for
LTYPE option
default value for
purpose of
syntax
usage notes for
MAX_DISPLAY_LENGTH, function
MAXLITERAL option
default value for
purpose of
syntax
usage notes for
MAXOPENCURSORS option
default value for
effect on performance
for multiple cursors
purpose of
specifying for separate precompilation
syntax
usage notes for
what it affects
MLSLABEL datatype, external
MLSLABEL, internal datatype
MODE option
ANSI
ANSI command line option
default value for
effect on OPEN
purpose of
syntax
usage notes for
modes, parameter
namespaces, reserved by Oracle
naming
of cursors
of database objects
of savepoints
NATIVE, value of DBMS option
network
communicating over
reducing traffic over
new features
tasking
UNSAFE_NULL option
NEXTVAL pseudocolumn
node
about
current
NOT FOUND condition
in the WHENEVER statement
meaning of
notation, rules for
NOWAIT parameter
effect of
in LOCK TABLE statements
omitting
null values
about
detecting
[
2
]
hardcoding
inserting
returning
NULL_PERMITTED, function
nulls
fetching with indicator variables
fetching without indicator variables
restrictions on
testing for
NUMBER datatype
external
internal
obsolete options
AREASIZE
REBIND
REENTRANT
ONAME option
default value for
purpose of
syntax
usage notes for
OPEN statement
CLOSE statement
DECLARE statement
dependence on precompiler options
example of
FETCH statement
purpose of
[
2
] [
3
]
results of
syntax diagram for
usage notes for
use in dynamic SQL method 3
OPEN_CURSORS parameter
open, a cursor variable
operating system-specific information
Ada library
building an Ada library
compiling a user exit
compiling and linking
configuration files
IAP
list of
pre-defined symbols
ROWID
source files
SQL*Net
user exits
options
options, precompiler, precompiler options
ORACLE identifiers, how to form
Oracle keywords
Oracle namespaces
Oracle Open Gateway, using the ROWID datatype
ORACLE Precompilers, use of PL/SQL with
Oracle reserved words
ORECLEN option
default value for
purpose of
syntax
usage notes for
OUT parameter mode
output host variables
about
assigning values to
host variables
input host variables
overhead, reducing
package
osd
SQL_STANDARD
[
2
]
PAGELEN option
default value for
purpose of
syntax
usage notes for
parameter modes
parent cursor
parse error offset
how to interpret
use in error reporting
parsing, about
password
defining
prompting for
path, execution
performance
causes of poor
eliminating extra parsing to improve
improving
optimizing SQL statements to improve
using embedded PL/SQL to improve
using HOLD_CURSOR to improve
using host arrays to improve
using indexes to improve
using RELEASE_CURSOR to improve
using row-level locking to improve
PL/SQL reserved words
PL/SQL
advantages
anonymous block
calling stored subprograms
cursor FOR loop
exceptions
integration with server
packages
PL/SQL tables
procedures and functions
user-defined records
using with dynamic SQL
placeholders
about
duplicate
naming
proper order of
use in dynamic SQL statements
pls1.pad
pls2.pad
pointer, to a cursor variable
PRECISION
function
NUMBER
precompilation
conditional
scope of options
separate
[
2
]
what occurs during
precompiler command
issuing
optional arguments
required arguments
precompiler options
CONFIG
configuration file
DBMS
DEFINE
displaying
entering
entering inline
entering on the command line
ERRORS
HOLD_CURSOR
INAME
INCLUDing a file of
inline versus on the command line
IRECLEN
list of
LNAME
LRECLEN
LTYPE
MAXLITERAL
MAXOPENCURSORS
MODE
obsolete
ONAME
ORECLEN
PAGELEN
RELEASE_CURSOR
scope of
SELECT_ERROR
setting default values
specifying
[
2
]
SQLCHECK
syntax
THREADS
UNSAFE_NULL
USERID
using
XREF
precompiler pragma
PREPARE statement
purpose of
syntax diagram for
usage notes for
use in dynamic SQL
[
2
]
private area, about
private SQL area, purpose of
Pro*Ada
development process
features
precompiler
procedural database extension
Program Global Area (PGA)
program termination, normal versus abnormal
protocol, about
pseudocolumns
CURRVAL
description
LEVEL
list of
NEXTVAL
ROWID
ROWLABEL
ROWNUM
queries
association with cursors
forwarding
incorrectly coded
kinds of
requirements for
returning more than one row
single-row versus multi-row
raise action, result of
raise exception, in the WHENEVER statement
RAW datatype
column, maximum width
compared with CHAR
external
internal datatype
restrictions
RAW, Pro*Ada type
read consistency, about
READ ONLY parameter, in SET TRANSACTION statement
read-only transactions
description of
example of
how ended
REBIND option, obsolete options
record
REENTRANT option, obsolete options
reentrant, definition of
referencing
of host variables
of indicator variables
RELEASE parameter
COMMIT statement, ROLLBACK statement
if omitted
in COMMIT statement
in ROLLBACK statement
purpose of
using
RELEASE_CURSOR option
default value for
purpose of
syntax
usage notes for
using to improve performance
what it affects
reserved words
PL/SQL
restrictions
on declaring cursors
on host arrays
[
2
] [
3
]
on input host variables
on LONG datatype
on LONG RAW datatype
on nulls
on RAW datatype
on separate precompilations
on SET TRANSACTION statement
return codes, user exits
RETURN_SIZE, function
ROLLBACK statement
COMMIT statement, SAVEPOINT statement
delimits transaction
effect of
example of
in error handling routines
purpose of
[
2
]
RELEASE parameter in
syntax diagram for
TO SAVEPOINT clause in
usage notes for
using
using in a PL/SQL block
where to place
rollback
automatic
function of
segment
statement-level
row locks
acquiring with FOR UPDATE OF
advantage of
using to improve performance
when acquired
when released
ROWID datatype
external
internal
Pro*Ada datatype
ROWID pseudocolumn
using to mimic CURRENT OF
[
2
]
ROWLABEL pseudocolumn
ROWNUM pseudocolumn
rows-processed count, use in error reporting
sample programs
arrays.pad
callsp.pad
concat.pad
cursvar.pad
cursvar.sql
demerror.pad
derive.pad
desc.pad
dyn1.pad
dyn3.pad
dyn4.pad
holdcurs.pad
pls1.pad
pls2.pad
simple.pad
task_a.pad
task_b.pad
task_drv.pad
tasks.a
SAVEPOINT statement
COMMIT statement, ROLLBACK statement
delimits transaction
example of
purpose of
[
2
]
syntax diagram for
usage notes for
using
SAVEPOINTS parameter
savepoints
about
limit on number of
naming
raising limit on number of
uses for
when active
when erased
SCALE
function
NUMBER
range of
scope
of a cursor variable
of precompiler options
of WHENEVER statement
search condition
about
in the WHERE clause
select list
about
number of items in
SELECT statement
clauses available for
example of
INTO clause in
purpose of
[
2
]
Queries
syntax diagram for
testing
usage notes for
using host arrays in
WHERE clause in
select-list item, about
SELECT_DATA_TYPE, function
SELECT_ENTRY_LENGTH, function
SELECT_ENTRY
function
procedure
SELECT_ERROR option
default value for
purpose of
syntax
usage notes for
SELECT_LIST_SIZE, function
separate precompilation
guidelines for
not supported for embedded SQL
referencing cursors for
restrictions on
specifying MAXOPENCURSORS for
server, integration with PL/SQL
session, about
SET clause
in UPDATE statements
purpose of
use of subqueries in
SET TRANSACTION statement
example of
purpose of
READ ONLY parameter in
requirements for
restrictions on
using
simple.pad, sample program
snapshot
special terms
SQL Communications Area
[
2
]
SQL language
SQL statements
about
concerns when executing
executable versus declarative
for defining and controlling transactions
for manipulating a cursor
[
2
]
for manipulating ORACLE data
for querying ORACLE data
optimizing to improve performance
rules for executing
static versus dynamic
types
SQL*Connect, using the ROWID datatype
SQL*Forms
Display Error screen in
IAP constants in
returning values to
Reverse Return Code Switch in
use of user exits in
user exit
user exits
SQL*Net
connecting to ORACLE via
for concurrent logons
function of
syntax
SQL*Plus, using to test SELECT statements
SQL_BIND procedure
SQL_INTO procedure
SQL_INTO, procedure
SQL_STANDARD
datatypes
package
[
2
]
SQL_STORE procedure, implicit use in static SQL
SQL_STORE, procedure
SQLCA
about
description of
[
2
]
information in
overview
SQLCODE field in
SQLWARN(2) flag in
SQLWARN(3) warning flag
SQLWARN(4) flag in
SQLWARN(5) flag in
using
using with SQL*Net
using with SQLSTATE
SQLCHECK option
default value for
purpose of
restrictions on
syntax
usage notes for
using to check syntax
what it affects
SQLCODE status variable
[
2
]
declaring
interpreting values of
purpose of
using with SQLSTATE
SQLCODE, deprecated feature under SQL92
SQLERRD(3) field
example of using
example of using with batch fetches
purpose of
SQLERRD(5) field, purpose of
SQLIEM function
purpose of
syntax
use in user exits
SQLROWS function
example
using
SQLSTATE status variable
[
2
] [
3
]
class code
coding scheme
declaring
interpreting values of
predefined classes
predefined status codes and conditions
rules for using
subclass code
SQLWARN(2) flag, purpose of
SQLWARN(3) warning flag, interpreting
SQLWARN(4) flag, purpose of
SQLWARN(5) flag, purpose of
SQLWARNING condition
in the WHENEVER statement
meaning of
statement-level rollback
description of
to break deadlocks
status codes, meaning of
[
2
] [
3
]
use in error reporting
status variable
stored subprograms, calling
STRING datatype, external
STRING_DEF, Pro*Ada, type
subqueries
example of
[
2
]
using in the SET clause
using in the VALUES clause
substitution variable
subtypes, constraints not checked by Pro*Ada
subunits, cannot contain embedded SQL
syntactic checking
about
controlling the type and extent
controlling with SQLCHECK
rules
SQLCHECK = NONE
SQLCHECK = SYNTAX
syntax checking
syntax diagram
description of
how to read
how to use
symbols used in
syntax, embedded SQL
SYSDATE function
system failure, effect on transactions
table locks
acquiring with LOCK TABLE
effect of
exclusive
row share
when released
task_a.pad, sample program
task_b.pad, sample program
task_drv.pad, sample program
tasking
tasks
tasks.a, sample program
termination, program, normal versus abnormal
THREADS option
default value for
purpose of
syntax
usage notes for
TO SAVEPOINT clause
in ROLLBACK statement
purpose of
trace facility
function of
using to improve performance
transactions
about
beginning and ending
contents of
[
2
]
description of
failure during
guarding databases with
guidelines for
handling distributed
how to begin
how to end
making permanent
processing
statements used for
read-only
subdividing with savepoints
terminating
terminology
undoing
undoing parts of
when rolled back automatically
[
2
]
trigger command
format of
in SQL*Forms
trigger step, calling line in
truncated values, detecting
[
2
]
truncation error, when generated
tuning, performance
type checking, for Ada variables in dynamic method 4
types
Pro*Ada, RAW
Pro*Ada, ROWID
Pro*Ada, STRING_DEF
Pro*Ada, VARCHAR
Pro*Ada, VARRAW
UID function
unconditional deletion, about
UNSAFE_NULL option
default value for
purpose of
[
2
]
syntax
usage notes for
[
2
]
UNSIGNED datatype
UPDATE statement
example of
purpose of
[
2
]
SET clause in
syntax diagram for
usage notes for
using host arrays in
WHERE clause in
user exits
about
calling from a SQL*Forms trigger
calling from a SQL*Forms trigger
common uses for
developing
guidelines for
kinds of statements allowed in
linking into IAP
linking into SQL*Forms
meaning of codes returned by
naming
passing parameters to
passing values between SQL*Forms
requirements for variables in
running the GENXTB form
running the GENXTB utility for
sample program
steps in developing
use of IAF GET statements in
use of IAF PUT statements in
use of WHENEVER statement in
writing
USER function
user session, about
user-defined record
USERID option
default value for
purpose of
syntax
usage notes for
username
defining
prompting for
USING clause
in CONNECT statement
in the EXECUTE statement
purpose of
using indicator variables in
V6, value of DBMS option
V7, value of DBMS option
VALUES clause
in INSERT statements
kinds of values allowed in
purpose of
requirements for
use of subqueries in
VAR statement
purpose of
syntax diagram for
usage notes for
VARCHAR datatype
components described
in method 4
Pro*Ada type
requirements for using with PL/SQL
VARCHAR2 datatype
column, maximum width
external
internal
VARCHAR_TEXT_IO, Oracle-supplied package
variables
cursor
host variables and indicator variables
number found by DESCRIBE
VARNUM, external datatype
VARRAW datatype
components defined
Pro*Ada type
warning flags, use in error reporting
warning flag
WHENEVER statement
automatic checking of SQLCA with
CONTINUE action in
DO action in
examples of
GOTO action in
guidelines for
maintaining addressability for
NOT FOUND condition in
overview
purpose of
raise action in
scope
scope of
SQLWARNING condition in
syntax diagram for
usage notes for
use in user exits
using
using to avoid infinite loops
using to handle end-of-data conditions
where to place
WHERE clause
host arrays in
if omitted
in DELETE statements
in SELECT statements
in UPDATE statements
purpose of
[
2
]
search condition in
syntax diagram for
usage notes for
WHERE CURRENT OF clause, CURRENT OF clause
XREF option
default value for
purpose of
syntax
usage notes for