Pro*COBOL Supplement to the Oracle Precompilers
Library
Product
Contents
Index
@
abbreviations
ALLOCATE statement
allocating cursor variables
automatic logons
bind descriptor
bind SQLDA
BNDDFCLP variable (SQLDA)
BNDDFCRCP variable (SQLDA)
BNDDFMT variable (SQLDA)
BNDDFMTL variable (SQLDA)
BNDDH-CUR-VNAMEL variable (SQLDA)
BNDDH-MAX-VNAMEL variable (SQLDA)
BNDDH-VNAME variable (SQLDA)
BNDDI variable (SQLDA)
BNDDI-CUR-VNAMEL variable (SQLDA)
BNDDI-MAX-VNAMEL variable (SQLDA)
BNDDI-VNAME variable (SQLDA)
BNDDV variable (SQLDA)
BNDDVLN variable (SQLDA)
BNDDVTYP variable (SQLDA)
character host variables, as output variables
[
2
]
handling
multi-byte
server handling
[
2
]
types
CLOSE statement
cursor variable
in dynamic SQL Method 4
COBOL datatypes
COBOL-74 restrictions
coding area, for paragraph names
coding conventions
comments
ANSI SQL-style
C-style
embedded SQL statements
composite type
concurrent logons
CONNECT statement
logging on to Oracle
placement
requirements
connecting to Oracle
automatically
concurrently
example of
via SQL*Net
continuation lines, syntax
CONTINUE action (WHENEVER statement)
cursor cache, purpose
cursor variables
advantages
allocating
closing
declaring
error conditions
fetching from
heap memory usage
opening
stored procedure
restrictions
scope
data description language (DDL), embedded
datatypes
COBOL
coercing NUMBER to VARCHAR2
conversions
dealing with Oracle internal
descriptor codes
equivalencing
example
external
internal
need to coerce
PL/SQL equivalents
when to reset
DDL
DECLARE CURSOR statement, in dynamic SQL Method 4
declare section
allowable statements
COBOL datatypes supported
defining usernames and passwords
purpose
requirements
rules for defining
declaring
cursor variables
host tables
host variables
indicator variables
multi-byte NLS variables
ORACA
SQLCA
SQLDA
VARCHAR variables
default
error handling
setting of FORMAT option
setting of LITDELIM option
setting of ORACA option
DEPENDING ON clause
DESCRIBE BIND VARIABLES statement, in dynamic SQL Method 4
DESCRIBE SELECT LIST statement, in dynamic SQL Method 4
descriptors
bind descriptor
purpose
select descriptor
SQLADR subroutine
dimension of host tables
directory path, INCLUDE files
DO action (WHENEVER statement)
dynamic SQL Method 4
CLOSE statement
DECLARE CURSOR statement
DESCRIBE statement
[
2
]
external datatypes
FETCH statement
FOR clause
host tables
internal datatypes
OPEN statement
PREPARE statement
prerequisites
purpose of descriptors
requirements
sequence of statements used
SQLDA
steps for
dynamic SQL, restrictions
elementary items
embedded DDL
embedded PL/SQL
host variables
indicator variables
multi-byte NLS features
requirements
VARCHAR variables
where allowed
embedded SQL statements
associating paragraph names with
comments
continuing from one line to the next
figurative constants
referencing host tables
referencing host variables
referencing indicator variables
requirements
syntax
terminator
equivalencing datatypes
error conditions, cursor variable
error handling
alternatives
default
using status variables
SQLCA
[
2
]
SQLCODE
[
2
]
SQLSTATE
[
2
]
error message text, SQLGLM subroutine
error messages, maximum length
error reporting
error message text
key components of
parse error offset
rows-processed count
status codes
warning flags
EXEC SQL clause
external datatypes
dynamic SQL Method 4
general
FETCH statement
cursor variable
in dynamic SQL Method 4
figurative constants, embedded SQL statements
file extension, for INCLUDE files
flags
FOR clause, in dynamic SQL Method 4
FORMAT option, purpose
GOTO action (WHENEVER statement)
group items
declaring
implicit VARCHAR
heap memory, allocating cursor variables
host tables
declaring
dimensioning
in dynamic SQL Method 4
multi-dimensional
referencing
restrictions
support for
variable-length
host variables, declaring
[
2
] [
3
]
definition
initializing
naming
[
2
]
referencing
restrictions
[
2
] [
3
]
with PL/SQL
hyphenation, of host variable names
implicit VARCHAR
INCLUDE statement
case-sensitive operating systems
declaring the ORACA
declaring the SQLCA
declaring the SQLDA
effect of
indicator tables
example
purpose
indicator variables
association with host variables
declaring
[
2
]
function
nulls
referencing
required size
truncated values
with PL/SQL
internal datatypes
dynamic SQL Method 4
general
IS NULL operator, for testing null values
LITDELIM option
logging on
automatically
requirements
MAXLITERAL option
[
2
]
message text
MODE option
effects of
status variables
multi-byte NLS features, datatypes
[
2
]
with PL/SQL
naming
host variables
select-list items
NOT FOUND condition (WHENEVER statement)
nulls
handling
indicator variables
meaning in SQL (NVL function)
SQLNUL subroutine
NUMBER datatype, using the SQLPRC subroutine with
NVL function, for retrieving null values
OPEN statement, in dynamic SQL Method 4
opening a cursor variable
operators, relational
ORACA
declaring
enabling
precompiler option
purpose
[
2
]
Oracle Communications Area, ORACA
paragraph names
associating with SQL statements
coding area for
parse error offset
password
defining
hardcoding
PL/SQL
datatype equivalents
embedded
opening a cursor variable
stored procedure
precision
definition of
using SQLPRC to extract
when not specified
precompiler options, ASSUME_SQLCODE
[
2
]
FORMAT
LITDELIM
MAXLITERAL
[
2
]
MODE
[
2
] [
3
]
ORACA
SQLCHECK
PREPARE statement, in dynamic SQL Method 4
programming guidelines
REDEFINES clause
purpose
restrictions
reference cursor
referencing
host tables
host variables
indicator variables
VARCHAR variables
relational operators
restrictions
COBOL-74
cursor variables
dynamic SQL
host tables
host variables
[
2
]
declaring
naming
referencing
REDEFINES clause
SQLGLM subroutine
SQLIEM subroutine
rows-processed count
sample programs
calling a stored procedure
cursor operations
cursor variables
Pro*COBOL source
datatype equivalencing
dynamic SQL Method 1
dynamic SQL Method 2
dynamic SQL Method 3
dynamic SQL Method 4
fetching in batches
list
Oracle Forms user exit
simple query
scalar type
scale
definition
extracting with SQLPRC
when negative
scope
cursor variables
WHENEVER statement
SELDFCLP variable (SQLDA)
SELDFCRCP variable (SQLDA)
SELDFMT variable (SQLDA)
SELDFMTL variable (SQLDA)
SELDH-CUR-VNAMEL variable (SQLDA)
SELDH-MAX-VNAMEL variable (SQLDA)
SELDH-VNAME variable (SQLDA)
SELDI variable (SQLDA)
SELDI-CUR-VNAMEL variable (SQLDA)
SELDI-MAX-VNAMEL variable (SQLDA)
SELDI-VNAME variable (SQLDA)
SELDV variable (SQLDA)
SELDVLN variable (SQLDA)
SELDVTYP variable (SQLDA)
select descriptor
select SQLDA, purpose of
select-list items, naming
SQL Descriptor Area
SQL*Net, for concurrent logons
SQLADR subroutine
example
parameters
storing buffer addresses
syntax
SQLCA status variable
data structure
declaring
effect of MODE option
explicit versus implicit checking
purpose
SQLCHECK option
SQLCODE status variable
ASSUME_SQLCODE option
declaring
description
effect of MODE option
SQL92 deprecated feature
usage
SQLDA
BNDDFCLP variable
BNDDFCRCP variable
BNDDFMT variable
BNDDFMTL variable
BNDDH-CUR-VNAMEL variable
BNDDH-MAX-VNAMEL variable
BNDDH-VNAME variable
BNDDI variable
BNDDI-CUR-VNAMEL variable
BNDDI-MAX-VNAMEL variable
BNDDI-VNAME variable
BNDDV variable
BNDDVLN variable
BNDDVTYP variable
declaring
example
purpose
SELDFCLP variable
SELDFCRCP variable
SELDFMT variable
SELDFMTL variable
SELDH-CUR-VNAMEL variable
SELDH-MAX-VNAMEL variable
SELDH-VNAME variable
SELDI variable
SELDI-CUR-VNAMEL variable
SELDI-MAX-VNAMEL variable
SELDI-VNAME variable
SELDV variable
SELDVLN variable
SELDVTYP variable
SQLADR subroutine
SQLDFND variable
SQLDNUM variable
structure
SQLDFND variable (SQLDA)
SQLDNUM variable (SQLDA)
SQLERRD(3) variable
SQLERRMC variable
SQLERROR condition (WHENEVER statement)
SQLGLM subroutine
example
parameters
purpose
restrictions
syntax
SQLIEM subroutine, restrictions
SQLNUL subroutine
example
parameters
purpose
syntax
SQLPR2 subroutine
SQLPRC subroutine
example
parameters
purpose
syntax
SQLSTATE status variable
declaring
effect of MODE option
usage
SQLWARNING condition (WHENEVER statement)
status codes for error reporting
STOP action (WHENEVER statement)
stored procedure, opening a cursor
[
2
]
sample programs
[
2
]
string literals, continuing to the next line
syntax
continuation lines
embedded SQL statements
SQLADR subroutine
SQLGLM subroutine
SQLNUL subroutine
SQLPRC
tables
terminator for embedded SQL statements
truncated values, indicator variables
Trusted Oracle7
username
defining
hardcoding
VALUE clause, initializing host variables
VAR statement, syntax for
VARCHAR variables
advantages
as input variables
as output variables
declaring
implicit group items
length element
maximum length
referencing
server handling
[
2
]
string element
structure
versus fixed-length strings
with PL/SQL
VARYING keyword, versus VARYING phrase
warning flags for error reporting
WHENEVER statement
CONTINUE action
DO action
example
GOTO action
NOT FOUND condition
purpose
scope
SQLERROR condition
SQLWARNING condition
STOP action
syntax