Pro*PL/I Supplement to the Oracle Precompilers Guide
Release 1.8

Part Number A87540-01

Home

Book List

Contents

Master Index

Feedback

Go to previous page

Index

A  B  C  D  E  F  G  H  I  L  M  N  O  P  Q  R  S  U  V  W  Z 


A

ADDR built-in function
use in SQLADR procedure, 5-4
automatic logins, 1-25

B

bind descriptor, 5-4
descriptor areas, 5-4
bind descriptor area, 5-4
bind SQLDA
purpose of, 5-3

C

CHAR
Oracle external datatype, 5-16
CLOSE statement
use in Dynamic SQL Method 4, 5-36
colon
use of with host variables, 1-10
comments
ANSI-style, 1-2
PL/I-style, 1-2
compiling, 3-10
conditional precompilation
benefits of, 3-9
purpose of, 3-9
connecting to Oracle
automatically, 1-25
CONTINUE action
in the WHENEVER statement, 2-17
Conventions
description of, xiii
cursor
closing, 5-36
declaration of, 5-25
opening, 5-30
restricted scope of, 3-9
cursor cache
purpose of, 2-19

D

Data Definition Language
creating CHAR objects with DBMS=V6, 3-7
datatype codes, 5-13
defined, 5-13
list of, 5-15
datatype conversions, 1-22
datatype equivalencing, 1-22
example of, 1-23
datatypes, 5-12
coercing, 5-13
coercing NUMBER to VARCHAR2, 5-14
external, 5-13
internal, 5-13
DATE
Oracle external datatype, 5-16
DECIMAL
Oracle external datatype, 5-16
declaration
of host arrays, 1-13
of host variables, 1-8
of indicator variables, 1-12
of ORACA, 2-20
of SQLCA, 2-13
of SQLDA, 5-5
DECLARE CURSOR statement
use in Dynamic SQL Method 4, 5-25
declare section
PL/I datatypes allowed in, 1-8
purpose of, 1-5
rules for defining, 1-6
statements allowed in, 1-6
default
error handling, 2-16
setting of ORACA option, 2-20
DESCRIBE BIND VARIABLES statement
use in Dynamic SQL Method 4, 5-25
DESCRIBE SELECT LIST statement
use in Dynamic SQL Method 4, 5-30
descriptor areas, 5-4
select descriptor, 5-4
descriptors
reserved elements in, 5-12
directory
current, 1-7
directory path
for INCLUDE files, 1-7
DISPLAY
Oracle external datatype, 5-16
DO action
in the WHENEVER statement, 2-17
Dynamic SQL Method 1
program example, 4-14
Dynamic SQL Method 2
program example, 4-17
Dynamic SQL Method 3
program example, 4-20
Dynamic SQL Method 4
requirements of, 5-2
sequence of statements used with, 5-19
steps for, 5-18
use of CLOSE statement in, 5-36
use of DECLARE CURSOR statement in, 5-25
use of DESCRIBE statement in, 5-25, 5-30
use of FETCH statement in, 5-34
use of OPEN statement in, 5-30
use of PREPARE statement in, 5-25

E

embedded PL/SQL
requirements for, 1-24
using host variables with, 1-24
using indicator variables with, 1-24
where allowed, 1-24
embedded SQL
requirements for, 1-2
syntax for, 1-2
embedded SQL statements
comments in, 1-2
labels for, 1-5
referencing host variables in, 1-10
referencing indicator variables in, 1-12
terminator for, 1-5
use of, 1-4
use of apostrophes in, 1-4
equivalencing of datatypes, 1-22
error message text
use in error reporting, 2-15
using the SQLGLM function to get, 2-15
error messages
maximum length of, 2-16
error reporting
key components of, 2-14
use of error message text in, 2-15
use of parse error offset in, 2-15
use of rows-processed count in, 2-15
use of status codes in, 2-14
use of warning flags in, 2-14
EXEC ORACLE statement
syntax for, 3-8
using to enter options inline, 3-8
EXEC SQL clause
using to embed SQL statements, 1-2
EXECUTE statement
use in Dynamic SQL Method 4, 5-36
use with host arrays, 5-36
external datatype
defined, 5-13
external datatypes, 5-13
list of, 1-21

F

FETCH statement
use in Dynamic SQL Method 4, 5-34
file extension
for INCLUDE files, 1-6
flags
warning flags, 2-14
FLOAT
Oracle external datatype, 5-16
functions
precompiling, 3-9

G

GOTO action
in the WHENEVER statement, 2-17

H

host arrays
declaring, 1-13
multidimensional, 1-14
restrictions on, 1-14, 1-15
host variables
attribute factoring in declaration of, 1-9
compatibility with database objects, 1-8
declaring, 1-8
definition of, 1-2
naming, 1-10
passed to a subroutine, 1-9
referencing, 1-10
restrictions on, 1-16
rules for naming, 1-2
scope of, 1-5
using with PL/SQL, 1-24
where to declare, 1-5, 1-9

I

INAME option
when a file extension is required, 3-2
INCLUDE statement
effect of, 1-6
not like PL/I %INCLUDE directive, 1-7
using to declare the ORACA, 2-20
using to declare the SQLCA, 2-13
using to declare the SQLDA, 5-5
indicator variables, 1-12
association with host variables, 1-12
declaring, 1-12
function of, 1-12
referencing, 1-12
required size of, 1-12
using with PL/SQL, 1-24
insert of no rows
cause of, 2-12
internal datatype, 5-13
defined, 5-13
internal datatypes
list of, 1-19
IS NULL operator
for testing nulls, 1-3

L

LIKE attribute
cannot be used for host variables, 1-9
linking, 3-10
LMARGIN, 3-9
logical operators, 1-3
LONG
Oracle external datatype, 5-16
LONG RAW
Oracle external datatype, 5-16
LONG VARRAW
Oracle external datatype, 5-16

M

MAXLITERAL
default value, 1-3
message text
error message text, 2-15
MLSLABEL
Oracle external datatype, 5-16
MODE option
default value for, 3-7
effects of, 1-17
purpose of, 3-7
syntax for, 3-7
usage notes for, 3-7
multidimensional arrays
cannot be declared as host variables, 1-14
invalid use of, 1-14

N

naming
of host variables, 1-2
NOT FOUND condition
in the WHENEVER statement, 2-17
Notation
rules for, xiii
NULL
meaning of in SQL, 1-3
PL/I built-in function, 1-3
null values
handling in Dynamic SQL Method 4, 5-17
using the SQLNUL procedure to test for, 5-17
NUMBER datatype
using the SQLPRC procedure with, 5-14
NVL function
for retrieving nulls, 1-3

O

OPEN statement
use in Dynamic SQL Method 4, 5-30
operators
logical, 1-3
relational, 1-4
options
precompiler, 3-2
ORACA
declaring, 2-20
enabling, 2-20
fields in, 2-21
purpose of, 2-19
ORACLE Communications Area
ORACA, 2-19
Oracle Precompilers
use of PL/SQL with, 1-24

P

parse error offset
how to interpret, 2-15
use in error reporting, 2-15
PL/I
BASED variables, 1-16
labels, 1-5
preprocessor not supported, 1-4
use of apostrophes in, 1-4
use of pointers in embedded SQL, 1-16
PL/I datatypes
allowed in SQL declare section, 1-8
CHARACTER VARYING, 1-16
FIXED DECIMAL, 5-9
supported by Oracle Precompilers, 1-8
PL/SQL
embedded PL/SQL, 1-24
pointers
use of in PL/I, 1-16
precision
extracting, 5-14
in the FIXED DECIMAL PL/I datatype, 5-9
precision and scale
using the SQLPRC procedure to extract, 5-14
precompiler command
issuing, 3-2
optional arguments of, 3-2
required arguments, 3-2
Precompiler options
MODE, 3-7
precompiler options
default settings, 3-2
displaying, 3-3
entering inline, 3-8
inline versus on the command line, 3-8
respecifying, 3-5
scope of, 3-5
scope of inline options, 3-8
specifying, 3-2
PREPARE statement
use in Dynamic SQL Method 4, 5-25
preprocessor
not supported in SQL blocks, 1-4
procedures
declare section in, 1-9
pseudocolumns
list of, 1-20

Q

quotation marks
use of in embedded SQL, 1-4

R

RAW
Oracle external datatype, 5-16
referencing
of host variables, 1-10
of indicator variables, 1-12
relational operators, 1-4
restrictions
on host arrays, 1-15
on PL/I variables, 1-16
RMARGIN, 3-9
ROWID
Oracle external datatype, 5-16
rows-processed count
use in error reporting, 2-15

S

scale
extracting, 5-14
in the FIXED DECIMAL PL/I datatype, 5-9
when negative, 5-14
scope
of host variables, 1-5
of precompiler options, 3-5
of WHENEVER statement, 2-18
select descriptor, 5-4
select descriptor area, 5-4
select SQLDA
purpose of, 5-3
Separate compilation
restrictions on, 3-9
separate precompilation
definition of, 3-9
need for, 3-9
SQL statement
terminator for, 1-5
SQL*Forms user exit
sample program, 4-12
SQLADR procedure
syntax of, 5-4
use of, 5-4
SQLCA
declaring, 2-13
purpose of, 2-13
SQLCODE variable, 2-14
declaring, 2-12
interpreting values of, 2-12
SQLDA
datatypes in, 5-12
declaring, 5-5
SQLDFMT element in, 5-9
SQLDFMTL element in, 5-10
SQLDFND element in, 5-8
SQLDH_CUR_VNAMEL element in, 5-11
SQLDH_MAX_VNAME element in, 5-11
SQLDH_VNAME element in, 5-11
SQLDI element in, 5-10
SQLDI_CUR_VNAMEL element in, 5-12
SQLDI_MAX_VNAMEL element in, 5-12
SQLDI_VNAME element in, 5-12
SQLDNUM element in, 5-8
SQLDSC element in, 5-8
SQLDV element in, 5-9
SQLDVLN element in, 5-9
SQLDVTYP element in, 5-10
structure, 5-7
variables, 5-7
SQLDFMT
element in SQLDA, 5-9
SQLDFMT element in SQLDA
how value is set, 5-9
SQLDFMTL
element in SQLDA, 5-10
SQLDFMTL element in SQLDA
how value is set, 5-10
SQLDFND element in SQLDA
how value is set, 5-8
SQLDH_CUR_VNAME element in SQLDA
how value is set, 5-11
SQLDH_MAX_VNAME element in SQLDA
how value is set, 5-11
SQLDH_VNAME element in SQLDA
how value is set, 5-11
SQLDI element in SQLDA
how value is set, 5-10
SQLDI_CUR_VNAMEL element in SQLDA
how value is set, 5-12
SQLDI_MAX_VNAMEL element in SQLDA
how value is set, 5-12
SQLDI_VNAME element in SQLDA
how value is set, 5-12
SQLDNUM element in SQLDA
how value is set, 5-8
SQLDSC element in SQLDA
how N is set, 5-8
SQLDV element in SQLDA
how value is set, 5-9
SQLDVLN
must be set by program, 5-10
SQLDVLN element in SQLDA
how value is set, 5-9
SQLDVTYP element in SQLDA
how it is used, 5-12
how value is set, 5-10
SQLERRD(3) variable, 2-15
SQLERRM variable, 2-15
SQLERROR condition
in the WHENEVER statement, 2-17
SQLGLM function
example of using, 2-16
need for, 2-15
parameters of, 2-15
syntax for, 2-15
SQLNUL procedure
example of using, 5-17
parameters of, 5-17
purpose of, 5-17
syntax for, 5-17
use of with SQLDVTYP, 5-10
SQLPR2 procedure
purpose of, 5-15
SQLPRC procedure
example of using, 5-14
parameters of, 5-14
purpose of, 5-14
syntax for, 5-14
SQLSTATE
class codes, 2-2
declaring, 2-2
mapping to Oracle errors, 2-4
predefined classes, 2-3
status codes, 2-4
using, 2-11
values, 2-2
SQLWARNING condition
in the WHENEVER statement, 2-17
statement labels, 1-5
status codes
use in error reporting, 2-14
STOP action
in the WHENEVER statement, 2-17
STRING
Oracle external datatype, 5-16
structure
elements in allowed as host variable, 1-9
use of as host variable not allowed, 1-9
subroutines
declare section in, 1-9
precompiling, 3-9
syntax
embedded SQL, 1-2

U

UNSIGNED
Oracle external datatype, 5-16

V

VAR statement
syntax for, 1-23
VARCHAR2
Oracle external datatype, 5-16
VARRAW
Oracle external datatype, 5-16

W

warning flags
use in error reporting, 2-14
WHENEVER statement
automatic checking of SQLCA with, 2-17
CONTINUE action in, 2-17
DO action in, 2-17
GOTO action in, 2-17
maintaining addressability for, 2-19
NOT FOUND condition in, 2-17
scope of, 2-18
SQLERROR condition in, 2-17
SQLWARNING condition in, 2-17
STOP action in, 2-17
syntax for, 2-17
uses for, 2-17

Z

Conventions
Notation, xiii
Notation
Conventions, xiii

Go to previous page
Oracle
Copyright © 1996-2001 Oracle Corporation.

All Rights Reserved.

Home

Book List

Contents

Master Index

Feedback