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
- directory
-
- current, 1.2.2
- directory path
-
- for INCLUDE files, 1.2.2
- DISPLAY
-
- Oracle external datatype, 5.2.5.4
- DO action
-
- in the WHENEVER statement, 2.4
- Dynamic SQL Method 1
-
- program example, 4.7
- Dynamic SQL Method 2
-
- program example, 4.8
- Dynamic SQL Method 3
-
- program example, 4.9
- Dynamic SQL Method 4
-
- requirements of, 5.1.1
- sequence of statements used with, 5.4
- steps for, 5.3
- use of CLOSE statement in, 5.4.17
- use of DECLARE CURSOR statement in, 5.4.8
- use of DESCRIBE statement in, 5.4.9, 5.4.13
- use of FETCH statement in, 5.4.15
- use of OPEN statement in, 5.4.12
- use of PREPARE statement in, 5.4.7
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