Index

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

A

  • abbreviations permitted 2.2.1
  • abnormal termination
    • automatic rollback E.8
  • active set 5.4
  • ALLOCATE DESCRIPTOR statement E.5
  • ALLOCATE statement E.4
    • use with ROWID 4.7
  • allocating
  • allocating cursor variables 6.10.2
  • ALTER AUTHORIZATION
    • changing password 3.2.4
  • ANSI/ISO SQL
  • ANSI dynamic SQL F.2.3
    • See also dynamic SQL (ANSI) 10
  • ANSI format
  • application development process 2.1.1
  • ARRAYLEN statement 6.6.1
  • ASACC precompiler option 14.7.1
  • ASSUME_SQLCODE precompiler option 14.7.2
  • AT clause
    • CONNECT statement 3.2.2.1
    • DECLARE CURSOR statement 3.2.2.1
    • DECLARE STATEMENT statement 3.2.2.1
    • EXECUTE IMMEDIATE statement 3.2.2.1
    • of COMMIT statement E.8
    • of CONNECT statement E.9
    • of DECLARE CURSOR directive E.14
    • of DECLARE STATEMENT directive E.16
    • of EXECUTE IMMEDIATE statement E.25
    • of EXECUTE statement E.22
    • of INSERT statements E.30
    • of SAVEPOINT statement E.53
    • of SELECT statement E.54
    • of UPDATE statement E.56
    • restrictions 3.2.2.1
  • AUTO_CONNECT option
    • instead of CONNECT statement 3.2.3.1
  • AUTO_CONNECT precompiler option 14.7.3
  • automatic logons 3.2.3
  • Avoiding Unnecessary Reparsing C.10

B

  • batch fetch 7.4.1
  • BFILES
  • bind descriptor 11.2.1
  • bind descriptors
  • binding host variables 9.5
  • bind SQLDA 11.1.3
  • bind variables 9.13.1
  • BNDDFCLP variable (SQLDA) 11.3
  • BNDDFCRCP variable (SQLDA) 11.3
  • BNDDFMT variable (SQLDA) 11.3
  • BNDDH-CUR-VNAMEL variable (SQLDA) 11.3
  • BNDDH-MAX-VNAMEL variable (SQLDA) 11.3
  • BNDDH-VNAME variable (SQLDA) 11.3
  • BNDDI-CUR-VNAMEL variable (SQLDA) 11.3
  • BNDDI-MAX-VNAMEL variable (SQLDA) 11.3
  • BNDDI variable (SQLDA) 11.3
  • BNDDI-VNAME variable (SQLDA) 11.3
  • BNDDVLN variable (SQLDA) 11.3
  • BNDDVTYP variable (SQLDA) 11.3
  • BNDDV variable (SQLDA) 11.3

C


D

  • database links
    • using in DELETE statement E.18
    • using in INSERT statement E.30
    • using in UPDATE statement E.56
  • data definition language (DDL)
  • data integrity 3.3
  • data lock 3.3
  • datatype
    • internal versus external 2.1.7
  • datatype conversion
    • between internal and external types 4.11
  • datatype equivalencing
  • datatypes
    • ANSI DATE 4.2
    • coercing NUMBER to VARCHAR2 11.4.3
    • conversions 4.10
    • dealing with Oracle internal 11.4.3
    • descriptor codes 11.4.3
    • equivalencing
    • internal 11.4.2
    • INTERVAL DAY TO SECOND 4.2
    • INTERVAL YEAR TO MONTH 4.2
    • need to coerce 11.4.3
    • PL/SQL equivalents 11.4.3
    • TIMESTAMP 4.2
    • TIMESTAMP WITH LOCAL TIME ZONE 4.2
    • TIMESTAMP WITH TIME ZONE 4.2
    • when to reset 11.4.3
  • DATE_FORMAT precompiler option 14.7.9
  • DATE, ANSI
  • DATE datatype
  • DATE String Format
    • explicit control over 4.11
  • DBMS precompiler option 14.7.10, 14.7.11
  • DDL 14.7.35
  • DDL (Data Definition Language) 5.1.1
  • deadlock 3.3
  • DEALLOCATE DESCRIPTOR statement E.13
  • DECIMAL datatype 4.1.2.5
  • declaration
  • declarative SQL statement 2.1.2.1
    • using in transactions 3.5
  • declarative statements
  • DECLARE_SECTION precompiler option 14.7.12
  • DECLARE CURSOR directive E.14
  • DECLARE CURSOR statement
  • DECLARE DATABASE directive E.15
  • declare section
    • defining usernames and passwords 3.1
  • Declare Section
  • DECLARE statement
    • using in dynamic SQL method 3 9.11.2
  • DECLARE STATEMENT directive E.16
  • DECLARE STATEMENT statement
  • DECLARE TABLE directive E.17
  • DECLARE TABLE directives
    • using with the SQLCHECK option D.3.1.2
  • declaring
  • default
  • default connection 3.2.1
  • DEFINE precompiler option 14.7.13
  • DELETE statement E.18
    • embedded SQL examples E.18
    • example 5.3.6
    • restrictions with tables 7.7.1
    • using host tables 7.7
    • WHERE clause 5.3.6
  • DEPENDING ON clause 7.3.1.1
  • DEPT table 2.8
  • DESCRIBE BIND VARIABLES statement
    • in dynamic SQL method 4 11.6.8
  • DESCRIBE DESCRIPTOR statement E.20
  • DESCRIBE SELECT LIST statement
  • DESCRIBE statement E.19
    • example E.19
    • use with PREPARE statement E.19
    • using in dynamic SQL method 4 9.13.1
  • descriptor
  • descriptors
  • dimension of host tables 7.3.1.1
  • directives
    • also known as declarative statements 2.1.2.1
  • directory path
  • DISPLAY datatype 4.1.2.6
  • distributed processing 3.2.1
  • DML returning clause 5.3.3
  • DO CALL action
  • DO PERFORM action
  • DSNTIAR
    • DB2 compatible feature 8.3.7
  • DSNTIAR routine 8.3.7
  • DYNAMIC option
    • effect on functionality 10.5
  • dynamic PL/SQL 9.16
  • dynamic SQL
  • dynamic SQL (ANSI) F.2.3
  • dynamic SQL method 1
  • dynamic SQL method 2
    • commands 9.6.2
    • description 9.9
    • requirements 9.6.2
    • using PL/SQL 9.16.2
    • using the DECLARE STATEMENT statement 9.14
    • using the EXECUTE statement 9.9
    • using the PREPARE statement 9.9
  • dynamic SQL method 3
    • commands 9.6.3
    • compared to method 2 9.11
    • requirements 9.6.3
    • using PL/SQL 9.16.3
    • using the DECLARE statement 9.11.2
    • using the DECLARE STATEMENT statement 9.14
    • using the FETCH statement 9.11.4
    • using the OPEN statement 9.11.3
    • using the PREPARE statement 9.11.1
  • dynamic SQL method 4
  • dynamic SQL statement 9.1
    • binding of host variables 9.5
    • how processed 9.5
    • requirements 9.4
    • using host tables 9.15
    • versus static SQL statement 9.1

E


F


G

  • GET DESCRIPTOR statement E.29
  • Globalization Support 4.8, 14.7.35
    • multibyte character strings 4.9
  • Globalization Support parameter
  • GOTO action
  • group items
  • guidelines

H


I

  • IDE F.1.1
  • identifiers, ORACLE
  • implicit logons 3.2.6
  • implicit VARCHAR 4.5.2
  • INAME option
    • when a file extension is required 14.1
  • INAME precompiler option 14.7.23
  • INCLUDE precompiler option 14.7.24
  • INCLUDE statement
  • INCLUDE statements A.1.3
  • index
    • using to improve performance C.7
  • index-organized tables 4.7
  • indicator table 7.1
  • indicator tables
  • indicator variable
  • indicator variables 5.2
  • in-doubt transaction 3.13
  • IN OUT parameter mode 6.2.4.1
  • IN parameter mode 6.2.4.1
  • input host variable
  • inserting
    • rows into tables and views E.30
  • INSERT statement E.30
  • INTEGER datatype 4.1.2.8
  • internal datatype
  • internal datatypes
  • INTERVAL DAY TO SECOND datatype 4.2
  • INTERVAL YEAR TO MONTH datatype 4.2
  • INTO clause 5.1.1, 6.10.4
  • IRECLEN precompiler option 14.7.25
  • IS NULL operator
    • for testing NULL values 2.2.21

J

  • Java methods
    • calling from Pro*COBOL 6.8

L


M

  • MAXLITERAL A.1.4
  • MAXLITERAL precompiler option 14.7.31
  • MAXOPENCURSORS option C.9
    • using for separate precompilation 2.6.1.2
  • MAXOPENCURSORS precompiler option 14.7.32
  • MERANT Micro Focus COBOL
  • message text 8.3.3.5
  • MODE
  • mode, parameter 6.2.4.1
  • MODE option
  • MODE precompiler option 14.7.33
  • multibyte character sets 4.9
  • multibyte Globalization Support features
  • multi-byte Globalization Support features
  • multithreaded applications
    • sample program 12.5
    • user-interface features
      • embedded SQL statements and directives 12.4.2

N


O


P


Q

  • queries
    • association with cursor 5.4
    • single-row versus multirow 5.3.1
  • query 5.3

R

  • RAW datatype
  • RAWTOHEX function 4.12.5
  • read consistency 3.3
  • READ ONLY parameter
    • using in SET TRANSACTION 3.10
  • read-only transaction 3.10
  • record, user-defined 6.2.7
  • REDEFINES clause
  • reference
  • reference cursor 6.10
  • referencing
  • relational operators
  • RELEASE_CURSOR option C.9
    • of ORACLE Precompilers E.7
  • RELEASE_CURSOR precompiler option 14.7.51
  • RELEASE option 3.6, 3.9
    • COMMIT statement 3.6
    • omitting 3.9
    • restrictions 3.8
    • ROLLBACK statement 3.7
  • remote database
    • declaration of E.15
  • restrictions
  • retrieving rows from a table
  • RETURN-CODE special register is unpredictable A.1.6
  • returning clause 5.3.3
  • rollback
  • roll back
    • to a savepoint E.53
    • to the same savepoint multiple times E.52
  • rollback segments 3.3
  • ROLLBACK statement 3.7, E.52
    • effects 3.7
    • ending a transaction E.52
    • example 3.7
    • examples E.52
    • RELEASE option 3.7
    • TO SAVEPOINT clause 3.7
    • using in a PL/SQL block 3.14.3
    • using in error-handling routines 3.7
    • where to place 3.7
  • rolling back
  • ROWID datatype
    • heap tables versus index-organized tables 4.7
    • Universal 4.7
    • use of 4.7
    • use of ALLOCATE 4.7
  • ROWID pseudocolumns
    • retrieving with SQLROWIDGET 4.7.1
    • universal ROWID 4.7
    • using to mimic CURRENT OF 3.12, 7.11
  • row lock
  • ROWNUM pseudocolumns 4.1.2.23
  • rows
    • fetching from cursors E.26, E.27
    • inserting into tables and views E.30
    • updating E.56
  • rows-processed count 8.3.3.3
  • RR diagrams
    • see syntax diagrams E.3

S


T

  • table (host) elements
  • table lock
  • tables
    • elements 7.1
    • index-organized 4.7
    • inserting rows into E.30
    • updating rows in E.56
  • tables, host 7.1
  • TERMINAL format
  • terminator for embedded SQL statements 2.2.25
  • threads E.10
  • THREADS
  • TIMESTAMP datatype 4.2
  • TIMESTAMP WITH LOCAL TIME ZONE datatype 4.2
  • TIMESTAMP WITH TIME ZONE datatype 4.2
  • TO SAVEPOINT clause 3.8
    • restrictions 3.8
    • using in ROLLBACK statement 3.8
  • trace facility
    • using to improve performance C.5.1.1
  • transaction 3.4
  • transactions
    • committing E.8
    • contents 3.5
    • guidelines 3.14.1
    • how to begin 3.5
    • how to end 3.5
    • in-doubt 3.13
    • making permanent 3.6
    • read-only 3.10
    • rolling back E.52
    • subdividing with savepoints 3.8
    • undoing 3.7
    • undoing parts of 3.8
    • when rolled back automatically 3.5, 3.7
  • truncated values 6.5.2
  • truncation errors
  • tuning, performance C.1
  • TYPE_CODE option
    • effect on functionality 10.5
  • TYPE_CODE precompiler option 14.7.55, 14.7.56
  • TYPE statements
    • using the CHARF datatype specifier 4.12.3

U

  • UID function 4.1.2.23
  • undo a transaction E.52
  • universal ROWID
    • ROWID pseudocolumns 4.7
  • UNSAFE_NULL precompiler option 14.7.57
  • UNSIGNED datatype 4.1.2.18
  • UPDATE statement E.56
  • updating
    • rows in tables and views E.56
  • use
  • user-defined record 6.2.7
  • USER function 4.1.2.23
  • USERID option
    • using with the SQLCHECK option D.3.1.1
  • USERID precompiler option 14.7.58
  • usernames
  • user session 3.3
  • USING clause
    • CONNECT statement 3.2.2.1
    • of FETCH statement E.26
    • of OPEN statement E.49
    • using indicator variables 9.9.1
    • using in the EXECUTE statement 9.9.1
  • using dbstring
    • Oracle Net Services database id specification E.9

V


W


X