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
