Index

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

A

ADDR built-in function

use in SQLADR procedure, 5.2.1

automatic logins, 1.13.1

B

bind descriptor, 5.2.1

descriptor areas, 5.2.1

bind descriptor area, 5.2.1

bind SQLDA

purpose of, 5.1.3

C

CHAR

Oracle external datatype, 5.2.5.4

CLOSE statement

use in Dynamic SQL Method 4, 5.4.17

colon

use of with host variables, 1.3.2

comments

ANSI-style, 1.1.1

PL/I-style, 1.1.1

compiling, 3.5

conditional precompilation

benefits of, 3.3

purpose of, 3.3

connecting to Oracle

automatically, 1.13.1

CONTINUE action

in the WHENEVER statement, 2.4

Conventions

description of, Preface

Notation, Preface

cursor

closing, 5.4.17

declaration of, 5.4.8

opening, 5.4.12

restricted scope of, 3.4.1

cursor cache

purpose of, 2.5

D

Data Definition Language

creating CHAR objects with DBMS=V6, 3.2.5

datatype codes, 5.2.5

defined, 5.2.5.1

list of, 5.2.5.4

datatype conversions, 1.10

datatype equivalencing, 1.11

example of, 1.11.1

datatypes, 5.2.5

coercing, 5.2.5.2

coercing NUMBER to VARCHAR2, 5.2.5.3

external, 5.2.5.1

internal, 5.2.5.1

DATE

Oracle external datatype, 5.2.5.4

DECIMAL

Oracle external datatype, 5.2.5.4

declaration

of host arrays, 1.5.1

of host variables, 1.3.1

of indicator variables, 1.4.1

of ORACA, 2.5.1

of SQLCA, 2.2.1

of SQLDA, 5.2.2

DECLARE CURSOR statement

use in Dynamic SQL Method 4, 5.4.8

declare section

PL/I datatypes allowed in, 1.3.1

purpose of, 1.2.1

rules for defining, 1.2.1

statements allowed in, 1.2.1

default

error handling, 2.4

setting of ORACA option, 2.5.2

DESCRIBE BIND VARIABLES statement

use in Dynamic SQL Method 4, 5.4.9

DESCRIBE SELECT LIST statement

use in Dynamic SQL Method 4, 5.4.13

descriptor areas, 5.2.1

select descriptor, 5.2.1

descriptors

reserved elements in, 5.2.4.16

E

embedded PL/SQL

requirements for, 1.12

using host variables with, 1.12.1

using indicator variables with, 1.12.2

where allowed, 1.12

embedded SQL

requirements for, 1.1.3

syntax for, 1.1.3

embedded SQL statements

comments in, 1.1.1

labels for, 1.1.14

referencing host variables in, 1.3.2

referencing indicator variables in, 1.4.2

terminator for, 1.1.13

use of, 1.1.11

use of apostrophes in, 1.1.11

equivalencing of datatypes, 1.11

error message text

use in error reporting, 2.2.3.5

using the SQLGLM function to get, 2.3

error messages

maximum length of, 2.3

error reporting

key components of, 2.2.3

use of error message text in, 2.2.3.5

use of parse error offset in, 2.2.3.4

use of rows-processed count in, 2.2.3.3

use of status codes in, 2.2.3.1

use of warning flags in, 2.2.3.2

EXEC ORACLE statement

syntax for, 3.2.7

using to enter options inline, 3.2.7

EXEC SQL clause

using to embed SQL statements, 1.1.3

EXECUTE statement

use in Dynamic SQL Method 4, 5.5

use with host arrays, 5.5

external datatype

defined, 5.2.5.1

external datatypes, 5.2.5.1

list of, 1.9.2

F

FETCH statement

use in Dynamic SQL Method 4, 5.4.15

file extension

for INCLUDE files, 1.2.2

flags

warning flags, 2.2.3.2

FLOAT

Oracle external datatype, 5.2.5.4

functions

precompiling, 3.4

G

GOTO action

in the WHENEVER statement, 2.4

H

host arrays

declaring, 1.5.1

multidimensional, 1.5.1

restrictions on, 1.5.1, 1.5.2

host variables

attribute factoring in declaration of, 1.3.1.2

compatibility with database objects, 1.3.1

declaring, 1.3.1

definition of, 1.1.4

naming, 1.3.2

passed to a subroutine, 1.3.1.3

referencing, 1.3.2

restrictions on, 1.6

rules for naming, 1.1.4

scope of, 1.1.12

using with PL/SQL, 1.12.1

where to declare, 1.2.1, 1.3.1.3

I

INAME option

when a file extension is required, 3.1

INCLUDE statement

effect of, 1.2.2

not like PL/I %INCLUDE directive, 1.2.2

using to declare the ORACA, 2.5.1

using to declare the SQLCA, 2.2.1

using to declare the SQLDA, 5.2.2

indicator variables, 1.4

association with host variables, 1.4

declaring, 1.4.1

function of, 1.4

referencing, 1.4.2

required size of, 1.4.1

using with PL/SQL, 1.12.2

insert of no rows

cause of, 2.1.4

internal datatype, 5.2.5.1

defined, 5.2.5.1

internal datatypes

list of, 1.9.1

IS NULL operator

for testing nulls, 1.1.6

L

LIKE attribute

cannot be used for host variables, 1.3.1.1

linking, 3.5

LMARGIN, 3.2.8

logical operators, 1.1.7

LONG

Oracle external datatype, 5.2.5.4

LONG RAW

Oracle external datatype, 5.2.5.4

LONG VARRAW

Oracle external datatype, 5.2.5.4, 5.2.5.4

M

MAXLITERAL

default value, 1.1.5

message text

error message text, 2.2.3.5

MLSLABEL

Oracle external datatype, 5.2.5.4

MODE option

default value for, 3.2.6

effects of, 1.8.1

purpose of, 3.2.6

syntax for, 3.2.6

usage notes for, 3.2.6

multidimensional arrays

cannot be declared as host variables, 1.5.1

invalid use of, 1.5.1

N

naming

of host variables, 1.1.4

NOT FOUND condition

in the WHENEVER statement, 2.4

Notation

rules for, Preface

Conventions, Preface

NULL

meaning of in SQL, 1.1.6

PL/I built-in function, 1.1.6

null values

handling in Dynamic SQL Method 4, 5.2.6

using the SQLNUL procedure to test for, 5.2.6

NUMBER datatype

using the SQLPRC procedure with, 5.2.5.3

NVL function

for retrieving nulls, 1.1.6

O

OPEN statement

use in Dynamic SQL Method 4, 5.4.12

operators

relational, 1.1.8

options

precompiler, 3.2

ORACA

declaring, 2.5.1

enabling, 2.5.2

fields in, 2.5.3

purpose of, 2.5

ORACLE Communications Area

ORACA, 2.5

Oracle Precompilers

use of PL/SQL with, 1.12

P

parse error offset

how to interpret, 2.2.3.4

use in error reporting, 2.2.3.4

PL/I

BASED variables, 1.6

labels, 1.1.14

preprocessor not supported, 1.1.10

use of apostrophes in, 1.1.11

use of pointers in embedded SQL, 1.6

PL/I datatypes

allowed in SQL declare section, 1.3.1

CHARACTER VARYING, 1.7

FIXED DECIMAL, 5.2.4.6

supported by Oracle Precompilers, 1.3.1

PL/SQL

embedded PL/SQL, 1.12

pointers

use of in PL/I, 1.6

precision

extracting, 5.2.5.3

in the FIXED DECIMAL PL/I datatype, 5.2.4.6

precision and scale

using the SQLPRC procedure to extract, 5.2.5.3

precompiler command

issuing, 3.1

optional arguments of, 3.2

required arguments, 3.1

Precompiler options

MODE, 3.2.6

precompiler options

default settings, 3.2

displaying, 3.2

entering inline, 3.2.7

inline versus on the command line, 3.2.7

respecifying, 3.2.4

scope of, 3.2.4

scope of inline options, 3.2.7

specifying, 3.2

PREPARE statement

use in Dynamic SQL Method 4, 5.4.7

preprocessor

not supported in SQL blocks, 1.1.10

procedures

declare section in, 1.3.1.3

pseudocolumns

list of, 1.9.2

Q

quotation marks

use of in embedded SQL, 1.1.11

R

RAW

Oracle external datatype, 5.2.5.4

referencing

of host variables, 1.3.2

of indicator variables, 1.4.2

relational operators, 1.1.8

restrictions

on host arrays, 1.5.2

on PL/I variables, 1.6

RMARGIN, 3.2.8

ROWID

Oracle external datatype, 5.2.5.4

rows-processed count

use in error reporting, 2.2.3.3

S

scale

extracting, 5.2.5.3

in the FIXED DECIMAL PL/I datatype, 5.2.4.6

when negative, 5.2.5.3

scope

of host variables, 1.1.12

of precompiler options, 3.2.4

of WHENEVER statement, 2.4.1

select descriptor, 5.2.1

select descriptor area, 5.2.1

select SQLDA

purpose of, 5.1.3

Separate compilation

restrictions on, 3.4.1

separate precompilation

definition of, 3.4

need for, 3.4

SQL statement

terminator for, 1.1.13

SQL*Forms user exit

sample program, 4.6

SQLADR procedure

syntax of, 5.2.1

use of, 5.2.1

SQLCA

declaring, 2.2.1

purpose of, 2.2

SQLCODE variable, 2.2.3.1

declaring, 2.1.4

interpreting values of, 2.1.4

SQLDA

datatypes in, 5.2.5

declaring, 5.2.2

SQLDFMT element in, 5.2.4.6

SQLDFND element in, 5.2.4.3

SQLDH_CUR_VNAMEL element in, 5.2.4.12

SQLDH_MAX_VNAME element in, 5.2.4.11

SQLDH_VNAME element in, 5.2.4.10

SQLDI element in, 5.2.4.9

SQLDI_CUR_VNAMEL element in, 5.2.4.15

SQLDI_MAX_VNAMEL element in, 5.2.4.14

SQLDI_VNAME element in, 5.2.4.13

SQLDNUM element in, 5.2.4.2

SQLDSC element in, 5.2.4.4

SQLDV element in, 5.2.4.6

SQLDVLN element in, 5.2.4.7

SQLDVTYP element in, 5.2.4.8

structure, 5.2.4

variables, 5.2.4

SQLDFMT

element in SQLDA, 5.2.4.6

SQLDFMT element in SQLDA

how value is set, 5.2.4.6

SQLDFND element in SQLDA

how value is set, 5.2.4.3

SQLDH_CUR_VNAME element in SQLDA

how value is set, 5.2.4.12

SQLDH_MAX_VNAME element in SQLDA

how value is set, 5.2.4.11

SQLDH_VNAME element in SQLDA

how value is set, 5.2.4.10

SQLDI element in SQLDA

how value is set, 5.2.4.9

SQLDI_CUR_VNAMEL element in SQLDA

how value is set, 5.2.4.15

SQLDI_MAX_VNAMEL element in SQLDA

how value is set, 5.2.4.14

SQLDI_VNAME element in SQLDA

how value is set, 5.2.4.13

SQLDNUM element in SQLDA

how value is set, 5.2.4.2

SQLDSC element in SQLDA

how N is set, 5.2.4.4

SQLDV element in SQLDA

how value is set, 5.2.4.6

SQLDVLN

must be set by program, 5.2.4.7

SQLDVLN element in SQLDA

how value is set, 5.2.4.7

SQLDVTYP element in SQLDA

how it is used, 5.2.5

how value is set, 5.2.4.8

SQLERRD(3) variable, 2.2.3.3

SQLERRM variable, 2.2.3.5

SQLERROR condition

in the WHENEVER statement, 2.4

SQLGLM function

example of using, 2.3

need for, 2.3

parameters of, 2.3

syntax for, 2.3

SQLNUL procedure

example of using, 5.2.6

parameters of, 5.2.6

purpose of, 5.2.6

syntax for, 5.2.6

use of with SQLDVTYP, 5.2.4.8

SQLPR2 procedure

purpose of, 5.2.5.3

SQLPRC procedure

example of using, 5.2.5.3

parameters of, 5.2.5.3

purpose of, 5.2.5.3

syntax for, 5.2.5.3

SQLSTATE

class codes, 2.1.2

declaring, 2.1.1

mapping to Oracle errors, 2.1.2

predefined classes, 2.1.2

status codes, 2.1.2

using, 2.1.3

values, 2.1.2

SQLWARNING condition

in the WHENEVER statement, 2.4

statement labels, 1.1.14

status codes

use in error reporting, 2.2.3.1

STOP action

in the WHENEVER statement, 2.4

STRING

Oracle external datatype, 5.2.5.4

structure

elements in allowed as host variable, 1.3.1.1

use of as host variable not allowed, 1.3.1.1

subroutines

declare section in, 1.3.1.3

precompiling, 3.4

syntax

embedded SQL, 1.1.3

U

UNSIGNED

Oracle external datatype, 5.2.5.4

V

VAR statement

syntax for, 1.11.1

VARCHAR2

Oracle external datatype, 5.2.5.4

VARRAW

Oracle external datatype, 5.2.5.4

W

warning flags

use in error reporting, 2.2.3.2

WHENEVER statement

automatic checking of SQLCA with, 2.4

CONTINUE action in, 2.4

DO action in, 2.4

GOTO action in, 2.4

maintaining addressability for, 2.4.1.2

NOT FOUND condition in, 2.4

scope of, 2.4.1

SQLERROR condition in, 2.4

SQLWARNING condition in, 2.4

STOP action in, 2.4

syntax for, 2.4

uses for, 2.4