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 1
  • abnormal termination
    • automatic rollback 1
  • active set
    • changing 1 , 2
    • definition 1
    • when empty 1
  • ALLOCATE DESCRIPTOR statement 1
  • ALLOCATE statement
    • use with ROWID 1
  • allocating
    • cursors 1
    • thread context 1 , 2
  • allocating cursor variables 1
  • ALTER AUTHORIZATION
    • changing password 1
  • ANSI/ISO SQL
    • extensions 1
  • ANSI dynamic SQL
    • See also dynamic SQL (ANSI) 1
  • ANSI format
    • COBOL statements 1
  • application development process 1
  • ARRAYLEN statement 1
  • ASACC precompiler option 1
  • ASSUME_SQLCODE precompiler option 1
  • AT clause
    • CONNECT statement 1
    • DECLARE CURSOR statement 1
    • DECLARE STATEMENT statement 1
    • EXECUTE IMMEDIATE statement 1
    • of COMMIT statement 1
    • of CONNECT statement 1
    • of DECLARE CURSOR directive 1
    • of DECLARE STATEMENT directive 1
    • of EXECUTE IMMEDIATE statement 1
    • of EXECUTE statement 1
    • of INSERT statements 1
    • of SAVEPOINT statement 1
    • of SELECT statement 1
    • of UPDATE statement 1
    • restrictions 1
  • AUTO_CONNECT option
    • instead of CONNECT statement 1
  • AUTO_CONNECT precompiler option 1
  • automatic logons 1 , 2
  • Avoiding Unnecessary Reparsing 1

B

  • batch fetch
    • example 1
    • number of rows returned 1
  • BFILES
    • definition 1
  • bind descriptor 1
  • bind descriptors
    • information in 1
  • binding host variables 1
  • bind SQLDA 1
  • bind variables 1
  • BNDDFCLP variable (SQLDA) 1
  • BNDDFCRCP variable (SQLDA) 1
  • BNDDFMT variable (SQLDA) 1
  • BNDDH-CUR-VNAMEL variable (SQLDA) 1
  • BNDDH-MAX-VNAMEL variable (SQLDA) 1
  • BNDDH-VNAME variable (SQLDA) 1
  • BNDDI-CUR-VNAMEL variable (SQLDA) 1
  • BNDDI-MAX-VNAMEL variable (SQLDA) 1
  • BNDDI variable (SQLDA) 1
  • BNDDI-VNAME variable (SQLDA) 1
  • BNDDVLN variable (SQLDA) 1
  • BNDDVTYP variable (SQLDA) 1
  • BNDDV variable (SQLDA) 1

C

  • CALL SQL statement 1
  • CALL statement
    • example 1
  • case-insensitivity 1
  • character host variables
    • as output variables 1
    • handling 1
    • server handling 1
    • types 1
  • character sets
    • multibyte 1
  • character strings
    • multibyte 1
  • CHAR datatypes
    • external 1
  • CHARF datatypes
    • external 1
  • CHARF datatype specifier
    • using in VAR statement 1
  • CHARZ datatype
    • external 1
  • CLOSE_ON_COMMIT
    • precompiler option 1 , 2
  • CLOSE_ON_COMMIT precompiler option 1
  • CLOSE command
    • examples 1
  • CLOSE statement
    • example 1
    • in dynamic SQL method 4 1
  • closing
    • cursors 1
  • COBOL-74 1
  • COBOL-85 1
  • COBOL versions supported 1 , 2
  • code page 1
  • coding area
    • for paragraph names 1
  • coding conventions 1
  • column list 1
  • COMMENT clause
    • of COMMIT statement 1
  • comments
    • ANSI SQL-style 1
    • C-style 1
    • embedded SQL statements 1
    • in embedded SQL 1
  • comments in dynamic PL/SQL blocks 1
  • commit
    • automatic 1
    • explicit versus implicit 1
  • COMMIT statement
    • effects 1
    • ending a transaction 1
    • example 1
    • examples 1
    • RELEASE option 1
    • using in a PL/SQL block 1
    • where to place 1
  • committing
    • transactions 1
  • COMP_CHARSET precompiler option 1
  • compilation 1
  • composite types 1
  • concurrency 1
  • concurrent logons 1
  • conditional precompilation
    • defining symbols 1
    • example 1
  • CONFIG precompiler option 1 , 2
  • configuration file
    • system versus user 1
  • connecting to Oracle
    • automatically 1
    • concurrently 1
    • example of 1
    • via Oracle Net Services 1
  • connections
    • default versus non-default 1
    • implicit 1
    • naming 1
  • CONNECT statement
    • AT clause 1
    • enabling a semantic check 1
    • examples 1
    • logging on to Oracle 1
    • placement 1
    • requirements 1
    • USING clause 1
    • when not required 1
  • CONTEXT ALLOCATE statement 1 , 2
  • CONTEXT FREE statement 1 , 2
  • CONTEXT USE directive 1
  • CONTEXT USE SQL directive 1
  • CONTEXT USE SQL statement 1
  • continuation lines
    • syntax 1
  • CONTINUE action
    • of WHENEVER directive 1 , 3
  • CONVBUFSZ clause in VAR statement 1
  • CREATE PROCEDURE statement 1
  • creating
    • savepoints 1
  • CURRENT OF clause
    • example 1
    • mimicking with ROWID 1 , 2
    • restrictions 1
  • current row 1
  • CURRVAL pseudocolumn 1
  • cursor cache
    • gathering statistics about 1
    • purpose 1 , 2
  • cursors
    • allocating 1
    • association with query 1
    • closing 1
    • declaring 1
    • effects on performance 1
    • explicit versus implicit 1
    • fetching rows from 1 , 2
    • naming 1
    • opening 1 , 2
    • reopening 1 , 2
    • restricted scope of 1
    • restrictions 1
    • scope 1
    • using for multirow queries 1
    • using more than one 1
    • when closed automatically 1
  • cursor variables
    • advantages 1
    • allocating 1
    • closing 1
    • declaring 1
    • fetching from 1
    • heap memory usage 1
    • opening
      • anonymous block 1
      • stored procedure 1
    • restrictions 1
    • scope 1

D

  • database links
    • using in DELETE statement 1
    • using in INSERT statement 1
    • using in UPDATE statement 1
  • data definition language (DDL)
    • description 1
    • embedded 1
  • data integrity 1
  • data lock 1
  • datatype
    • internal versus external 1
  • datatype conversion
    • between internal and external types 1
  • datatype equivalencing
    • advantages 1
    • example 1
    • guidelines 1
  • datatypes
    • ANSI DATE 1
    • coercing NUMBER to VARCHAR2 1
    • conversions 1
    • dealing with Oracle internal 1
    • descriptor codes 1
    • equivalencing
      • description 1
      • example 1
    • internal 1
    • INTERVAL DAY TO SECOND 1
    • INTERVAL YEAR TO MONTH 1
    • need to coerce 1
    • PL/SQL equivalents 1
    • TIMESTAMP 1
    • TIMESTAMP WITH LOCAL TIME ZONE 1
    • TIMESTAMP WITH TIME ZONE 1
    • when to reset 1
  • DATE_FORMAT precompiler option 1
  • DATE, ANSI
    • datatype 1
  • DATE datatype
    • converting 1
    • default format 1
  • DATE String Format
    • explicit control over 1
  • DBMS precompiler option 1 , 2
  • DDL 1
  • DDL (Data Definition Language) 1
  • deadlock
    • effect on transactions 1
    • how broken 1
  • DEALLOCATE DESCRIPTOR statement 1
  • DECIMAL datatype 1
  • declaration
    • cursor 1
    • host variable 1
  • declarative SQL statement
    • using in transactions 1
  • declarative statements
    • also known as directives 1
  • DECLARE_SECTION precompiler option 1
  • DECLARE CURSOR directive
    • example 1
    • examples 1
  • DECLARE CURSOR statement
    • AT clause 1
    • in dynamic SQL method 4 1
    • where to place 1
  • DECLARE DATABASE directive 1
  • declare section
    • defining usernames and passwords 1
  • Declare Section
    • allowable statements 1
    • example 1
    • purpose 1
    • requirements 1
    • rules for defining 1
    • using more than one 1
  • DECLARE statement
    • using in dynamic SQL method 3 1
  • DECLARE STATEMENT directive
    • examples 1
    • scope of 1
  • DECLARE STATEMENT statement
    • AT clause 1
    • example 1
    • using in dynamic SQL 1
    • when required 1
  • DECLARE TABLE directive
    • examples 1
  • DECLARE TABLE directives
    • using with the SQLCHECK option 1
  • declaring
    • cursor variables 1
    • host tables 1
    • indicator variables 1
    • ORACA 1
    • SQLCA 1
    • SQLDA 1
    • VARCHAR variables 1
  • default
    • error handling 1
    • setting of LITDELIM option 1 , 2
    • setting of ORACA option 1
  • default connection 1
  • DEFINE precompiler option 1
  • DELETE statement
    • embedded SQL examples 1
    • example 1
    • restrictions with tables 1
    • using host tables 1
    • WHERE clause 1
  • DEPENDING ON clause 1
  • DEPT table 1
  • DESCRIBE BIND VARIABLES statement
    • in dynamic SQL method 4 1
  • DESCRIBE DESCRIPTOR statement 1
  • DESCRIBE SELECT LIST statement
    • in dynamic SQL method 4 1
  • DESCRIBE statement
    • example 1
    • use with PREPARE statement 1
    • using in dynamic SQL method 4 1
  • descriptor
    • naming 1
  • descriptors
    • bind descriptor 1
    • purpose 1
    • select descriptor 1
    • SQLADR subroutine 1
  • dimension of host tables 1
  • directives
    • also known as declarative statements 1
  • directory path
    • INCLUDE files 1
  • DISPLAY datatype 1
  • distributed processing 1
  • DML returning clause 1
  • DO CALL action
    • of WHENEVER directive 1 , 2 , 3
  • DO PERFORM action
    • of WHENEVER directive 1 , 2
  • DSNTIAR
    • DB2 compatible feature 1
  • DSNTIAR routine 1
  • DYNAMIC option
    • effect on functionality 1
  • dynamic PL/SQL 1
  • dynamic SQL
    • advantages and disadvantages 1
    • choosing the right method 1
    • guidelines 1
    • overview 1 , 2
    • restrictions 1
    • using PL/SQL 1
    • using the AT clause 1
    • when useful 1
  • dynamic SQL (ANSI)
    • ALLOCATE DESCRIPTOR statement 1
    • basics 1
    • bulk operations 1
    • CLOSE CURSOR statement 1
    • compared to Oracle dynamic SQL method 4 1
    • DEALLOCATE DESCRIPTOR statement 1
    • DESCRIBE DESCRIPTOR statement 1
    • differences from Oracle dynamic SQL 1
    • EXECUTE statement 1
    • FETCH statement 1
    • GET DESCRIPTOR statement 1
    • OPEN statement 1
    • Oracle extensions 1
    • overview 1
    • precompiler options 1 , 2
    • reference semantics 1
    • restrictions 1
    • SAMPLE12.PCO 1
    • sample programs 1
    • SET DESCRIPTOR statement 1
    • use of DECLARE CURSOR 1
    • use of EXECUTE IMMEDIATE statement 1
    • use of PREPARE statement 1
    • when to use 1
  • dynamic SQL method 1
    • commands 1
    • description 1
    • example 1
    • requirements 1
    • using EXECUTE IMMEDIATE 1
    • using PL/SQL 1
  • dynamic SQL method 2
    • commands 1
    • description 1
    • requirements 1
    • using PL/SQL 1
    • using the DECLARE STATEMENT statement 1
    • using the EXECUTE statement 1
    • using the PREPARE statement 1
  • dynamic SQL method 3
    • commands 1
    • compared to method 2 1
    • requirements 1
    • using PL/SQL 1
    • using the DECLARE statement 1
    • using the DECLARE STATEMENT statement 1
    • using the FETCH statement 1
    • using the OPEN statement 1
    • using the PREPARE statement 1
  • dynamic SQL method 4
    • CLOSE statement 1
    • DECLARE CURSOR statement 1
    • DESCRIBE statement 1 , 2
    • external datatypes 1
    • FETCH statement 1
    • internal datatypes 1
    • OPEN statement 1
    • PREPARE statement 1
    • prerequisites 1
    • purpose of descriptors 1
    • requirements 1 , 2
    • sequence of statements used 1
    • SQLDA 1
    • steps for 1
    • using descriptors 1
    • using PL/SQL 1
    • using the DECLARE STATEMENT statement 1
    • using the DESCRIBE statement 1
    • using the FOR clause 1
    • using the SQLDA 1
    • when needed 1
  • dynamic SQL statement
    • binding of host variables 1
    • how processed 1
    • requirements 1
    • using host tables 1
    • versus static SQL statement 1

E

  • embedded DDL 1
  • embedded PL/SQL
    • advantages 1
    • cursor FOR loop 1
    • example 1 , 2
    • host variables 1
    • indicator variables 1
    • multibyte Globalization Support features 1
    • need for SQLCHECK option 1
    • need for USERID option 1
    • overview 1
    • package 1
    • PL/SQL table 1
    • requirements 1
    • subprogram 1
    • support for SQL 1
    • user-defined record 1
    • using %TYPE 1
    • using the VARCHAR pseudotype 1
    • using to improve performance 1
    • VARCHAR variables 1
    • where allowed 1 , 2
  • embedded SQL
    • ALLOCATE DESCRIPTOR statement 1
    • ALLOCATE statement 1 , 2 , 3
    • CALL statement 1 , 2
    • CLOSE statement 1 , 2 , 3
    • COMMIT statement 1
    • CONNECT statement 1
    • CONTEXT ALLOCATE statement 1 , 2
    • CONTEXT FREE statement 1 , 2
    • CONTEXT USE directive 1
    • DEALLOCATE DESCRIPTOR statement 1
    • DECLARE [CURSOR] directive 1
    • DECLARE CURSOR directive 1
    • DECLARE DATABASE directive 1
    • DECLARE STATEMENT directive 1
    • DECLARE TABLE directive 1
    • DELETE statement 1 , 2
    • DESCRIBE DESCRIPTOR statement 1
    • DESCRIBE statement 1
    • ENABLE THREADS statement 1
    • EXECUTE...END-EXEC statement 1
    • EXECUTE IMMEDIATE statement 1
    • EXECUTE statement 1
    • FETCH DESCRIPTOR statement 1
    • FETCH statement 1 , 2 , 3 , 4
    • FREE statement 1 , 2
    • GET DESCRIPTOR statement 1
    • INSERT statement 1 , 2 , 3
    • key concepts 1
    • OPEN DESCRIPTOR statement 1
    • OPEN statement 1 , 2 , 4
    • PREPARE statement 1
    • ROLLBACK statement 1
    • SAVEPOINT statement 1 , 2
    • SELECT statement 1 , 2 , 3
    • SET DESCRIPTOR statement 1
    • SET TRANSACTION statement 1
    • UPDATE statement 1 , 2
    • VAR directive 1
    • versus interactive SQL 1
    • WHENEVER directive 1
    • when to use 1
  • embedded SQL statements
    • associating paragraph names with 1
    • comments 1
    • continuation 1
    • figurative constants 1
    • mixing with host-language statements 1
    • referencing host tables 1
    • referencing host variables 1
    • referencing indicator variables 1
    • requirements 1
    • summary 1
    • syntax 1 , 2
    • terminator 1
  • embedding
    • PL/SQL blocks in Oracle7 precompiler programs 1
  • EMP table 1
  • ENABLE THREADS SQL statement 1
  • ENABLE THREADS statement 1
  • enabling
    • threads 1
  • encoding scheme 1
  • END_OF_FETCH precompiler option 1
  • equivalencing
    • host variable equivalencing 1
  • equivalencing datatypes 1
  • error detection
    • error reporting 1
  • error handling
    • alternatives 1
    • benefits 1
    • default 1
    • overview 1
    • using status variables
      • SQLCA 1 , 2
    • using the ROLLBACK statement 1
    • using the SQLGLS routine 1
  • error messages
    • maximum length 1
  • error message text
    • SQLGLM subroutine 1
  • error reporting
    • error message text 1
    • key components of 1
    • parse error offset 1
    • rows-processed count 1
    • status codes 1
    • warning flags 1
    • WHENEVER directive 1
  • ERRORS precompiler option 1
  • exception, PL/SQL 1
  • EXEC ORACLE DEFINE statement 1
  • EXEC ORACLE ELSE statement 1
  • EXEC ORACLE ENDIF statement 1
  • EXEC ORACLE IFDEF statement 1
  • EXEC ORACLE IFNDEF statement 1
  • EXEC ORACLE statement
    • scope of 1
    • syntax for 1
    • uses for 1
    • using to enter options inline 1
  • EXEC SQL clause 1 , 2
  • EXECUTE...END-EXEC statement 1
  • EXECUTE IMMEDIATE statement
    • AT clause 1
    • examples 1
    • using in dynamic SQL Method 1 1
  • EXECUTE optional keyword of ARRAYLEN statement 1
  • EXECUTE statement
    • examples 1 , 2
    • using in dynamic SQL Method 2 1
  • execution plan 1
  • EXPLAIN PLAN statement
    • using to improve performance 1
  • explicit logon
    • single 1
  • explicit logons 1
  • external datatypes
    • CHAR 1
    • CHARF 1
    • CHARZ 1
    • DECIMAL 1
    • definition 1
    • DISPLAY 1
    • dynamic SQL method 4 1
    • FLOAT 1
    • INTEGER 1
    • LONG 1
    • LONG RAW 1
    • LONG VARCHAR 1
    • LONG VARRAW 1
    • parameters 1
    • RAW 1
    • STRING 1
    • table of 1
    • UNSIGNED 1
    • VARCHAR 1
    • VARCHAR2 1
    • VARNUM 1
    • VARRAW 1

F

  • fetch, batch 1
  • fetching
    • rows from cursors 1 , 2
  • FETCH SQL statement 1
  • FETCH statement
    • cursor variable 1
    • example 1
    • examples 1
    • in dynamic SQL method 4 1
    • INTO clause 1
    • used after OPEN statement 1 , 2
    • using in dynamic SQL method 3 1
  • figurative constants
    • embedded SQL statements 1
  • file extension
    • for INCLUDE files 1
  • file length limit 1
  • FIPS flagger
    • warns of array usage 1
  • FIPS precompiler option 1
  • flags 1
  • FLOAT datatype 1
  • FORCE clause
    • of COMMIT statement 1
    • of ROLLBACK statement 1
  • FOR clause
    • example 1
    • of embedded SQL EXECUTE statement 1 , 2
    • of embedded SQL INSERT statement 1
    • restrictions 1
    • using with host tables 1
  • format mask 1
  • FORMAT precompiler option
    • purpose 1
  • formats of COBOL statements
    • ANSI 1
    • TERMINAL 1
  • FOR UPDATE OF clause 1
  • forward reference 1
  • freeing
    • thread context 1 , 2
  • FREE statement 1
  • full scan 1

G

  • GET DESCRIPTOR statement 1
  • Globalization Support
    • multibyte character strings 1
  • Globalization Support parameter
    • NLS_LANG 1
  • GOTO action
    • of WHENEVER directive 1 , 2
  • group items
    • allowed as host variables 1
    • implicit VARCHAR 1
  • guidelines
    • datatype equivalencing 1
    • dynamic SQL 1
    • separate precompilation 1
    • transaction 1

H

  • header files 1
  • heap 1
  • heap memory
    • allocating cursor variables 1
  • heap tables 1
  • hint, optimizer 1
  • hints
    • in DELETE statements 1
    • in SELECT statements 1
    • in UPDATE statements 1
  • HOLD_CURSOR option
    • of ORACLE Precompilers 1
    • using to improve performance 1
    • what it affects 1
  • HOLD_CURSOR precompiler option 1
  • host language 1
  • HOST precompiler option 1
  • host programs 1
  • host table elements
    • maximum 1
  • host table example 1
  • host tables
    • advantages 1
    • declaring 1
    • dimensioning 1
    • multi-dimensional 1
    • operations on 1
    • referencing 1
    • restrictions 1 , 3 , 4 , 5
    • restrictions on 1
    • support for 1
    • using in dynamic SQL statements 1
    • using in the DELETE statement 1
    • using in the INSERT statement 1
    • using in the SELECT statement 1
    • using in the UPDATE statement 1
    • using in the WHERE clause 1
    • using the FOR clause 1
    • using to improve performance 1
    • variable-length 1
  • host variables
    • assigning a value 1
    • declaring 1 , 2
    • declaring and naming 1
    • definition 1
    • host variable equivalencing 1
    • in EXECUTE statement 1
    • initializing 1
    • in OPEN statement 1
    • length up to 30 characters 1
    • naming 1 , 2 , 3
    • overview 1
    • referencing 1 , 2
    • requirements 1
    • restrictions 1 , 2
    • using in PL/SQL 1
    • where allowed 1
    • with PL/SQL 1
  • hyphenation
    • of host variable names 1

I

  • IDE 1
  • identifiers, ORACLE
    • how to form 1
  • implicit logons 1
  • implicit VARCHAR 1
  • INAME option
    • when a file extension is required 1
  • INAME precompiler option 1
  • INCLUDE precompiler option 1
  • INCLUDE statement
    • case-sensitive operating systems 1
    • declaring the ORACA 1
    • declaring the SQLCA 1
    • declaring the SQLDA 1
    • effect of 1
  • INCLUDE statements 1
  • index
    • using to improve performance 1
  • index-organized tables 1
  • indicator table 1
  • indicator tables
    • example 1
    • purpose 1
  • indicator variable
    • using to handle NULLs 1 , 2
  • indicator variables
    • assigning values to 1
    • association with host variables 1 , 2
    • declaring 1 , 2
    • function 1
    • function of 1
    • interpreting value 1
    • NULLs 1
    • referencing 1
    • required size 1
    • truncated values 1
    • used with multibyte character strings 1
    • using in PL/SQL 1
    • using to detect NULLs 1
    • using to detect truncated values 1
    • using to test for NULLs 1
    • with PL/SQL 1
  • in-doubt transaction 1
  • IN OUT parameter mode 1
  • IN parameter mode 1
  • input host variable
    • restrictions 1
    • where allowed 1
  • inserting
    • rows into tables and views 1
  • INSERT statement
    • column list 1
    • example 1
    • INTO clause 1
    • using host tables 1
    • VALUES clause 1
  • INTEGER datatype 1
  • internal datatype
    • definition 1
  • internal datatypes
    • dynamic SQL method 4 1
  • INTERVAL DAY TO SECOND datatype 1
  • INTERVAL YEAR TO MONTH datatype 1
  • INTO clause
    • FETCH statement 1
    • INSERT statement 1
    • of FETCH statement 1 , 2
    • of SELECT statement 1
    • SELECT statement 1
  • IRECLEN precompiler option 1
  • IS NULL operator
    • for testing NULL values 1

J

  • Java methods
    • calling from Pro*COBOL 1

L

  • language support 1
  • LEVEL pseudocolumns 1
  • library file 1
  • line continuation 1
  • linking 1
  • LITDELIM option
    • purpose 1
  • LITDELIM precompiler option 1 , 2
  • LNAME precompiler option 1
  • LOB and precompiler datatypes 1
  • LOB APPEND statement 1
  • LOB ASSIGN statement 1
  • LOB CLOSE statement 1
  • LOB COPY statement 1
  • LOB CREATE statement 1
  • LOB DESCRIBE statement 1
  • LOB DISABLE BUFFERING statement 1
  • LOB ENABLE BUFFERING statement 1
  • LOB ERASE statement 1
  • LOB FILE CLOSE statement 1
  • LOB FILE SET statement 1
  • LOB FLUSH BUFFER statement 1
  • LOB FREE TEMPORARY 1
  • LOB LOAD statement 1
  • LOB OPEN statement 1
  • LOB READ statement 1
  • LOBs
    • advantage of buffering 1
    • CHUNKSIZE attribute 1
    • compared with LONG and LONG RAW 1
    • definition 1
    • DIRECTORY attribute 1
    • external 1
    • FILEEXISTS attribute 1
    • FILENAME attribute 1
    • internal 1
    • ISOPEN attribute 1
    • ISTEMPORARY attribute 1
    • LENGTH attribute 1
    • LOB demo program 1
    • locators 1
    • rules for all statements 1
    • rules for buffering subsystem 1
    • rules for statements 1
    • temporary 1
    • using polling method to read and write 1
  • LOB statements
    • LOB APPEND 1
    • LOB ASSIGN 1
    • LOB CLOSE 1
    • LOB CLOSE ALL 1
    • LOB COPY 1
    • LOB CREATE TEMPORARY 1
    • LOB DISABLE BUFFERING 1
    • LOB ENABLE BUFFERING 1
    • LOB ERASE 1
    • LOB FILE SET 1
    • LOB FLUSH BUFFER 1
    • LOB FREE TEMPORARY 1
    • LOB LOAD FROM FILE 1
    • LOB OPEN 1
    • LOB READ 1
    • LOB TRIM 1
    • LOB WRITE 1
  • LOB TRIM statement 1
  • LOB WRITE statement 1
  • lock
    • released by ROLLBACK statement 1
  • locking
    • explicit versus implicit 1
    • modes 1
    • overriding default 1
    • privileges needed 1
    • using the FOR UPDATE OF clause 1
    • using the LOCK TABLE statement 1
  • LOCK TABLE statement
    • example 1
    • using the NOWAIT parameter 1
  • logons
    • automatic 1
    • concurrent 1
    • explicit 1
    • requirements 1
  • LONG datatype
    • external 1
  • LONG RAW datatype
    • converting 1
  • LONG RAW datatypes
    • external 1
  • LONG VARCHAR datatype 1
  • LONG VARRAW datatype 1
  • LRECLEN precompiler option 1
  • LTYPE precompiler option 1

M

  • MAXLITERAL 1
  • MAXLITERAL precompiler option 1
  • MAXOPENCURSORS option
    • using for separate precompilation 1
  • MAXOPENCURSORS precompiler option 1
  • MERANT Micro Focus COBOL
    • IDE 1
    • NetExpress 1
  • message text 1
  • MODE
    • equivalent values 1
  • mode, parameter 1
  • MODE option
    • effects of 1
  • MODE precompiler option 1
  • multibyte character sets 1
  • multibyte Globalization Support features
    • with PL/SQL 1
  • multi-byte Globalization Support features
    • datatypes 1
  • multithreaded applications
    • sample program 1
    • user-interface features
      • embedded SQL statements and directives 1

N

  • namespaces
    • reserved by Oracle 1
  • naming
    • host variables 1
    • of database objects 1
    • select-list items 1
  • naming conventions
    • cursor 1
    • default database 1
    • host variable 1
  • NATIVE
    • value of DBMS option 1
  • NESTED precompiler option 1
  • nested programs
    • support for 1
  • NetExpress 1
  • NEXTVAL pseudocolumns 1
  • nibbles 1
  • NLS_LOCAL
    • precompiler option 1
  • NOT FOUND condition
    • of WHENEVER directive 1 , 2
  • NOWAIT parameter
    • using in LOCK TABLE statement 1
  • NULLs
    • definition 1
    • detecting 1
    • handling
      • indicator variables 1
      • in dynamic SQL method 4 1
    • hardcoding 1
    • inserting 1
    • meaning in SQL (NVL function) 1
    • restrictions 1
    • retrieving 1
    • SQLNUL subroutine 1
    • testing for 1
  • NULLs in SQL
    • how to detect 1
  • NUMBER datatype
    • using the SQLPRC subroutine with 1
  • NVL function
    • for retrieving NULL values 1

O

  • ONAME precompiler option 1
  • OPEN DESCRIPTOR statement 1
  • opening
    • cursors 1 , 2
  • opening a cursor variable 1
  • OPEN SQL statement 1
  • OPEN statement
    • example 1
    • examples 1
    • in dynamic SQL method 4 1
    • using in dynamic SQL method 3 1
  • operators
    • relational 1
  • optimizer hint 1
  • optional division headers 1
  • options
    • precompiler concepts 1
  • ORACA
    • declaring 1 , 2
    • enabling 1
    • example 1
    • fields 1
    • gathering cursor cache statistics 1
    • ORACABC field 1
    • ORACAID field 1
    • ORACCHF flag 1
    • ORACOC field 1
    • ORADBGF flag 1
    • ORAHCHF flag 1
    • ORAHOC field 1
    • ORAMOC field 1
    • ORANEX field 1
    • ORANOR field 1
    • ORANPR field 1
    • ORASFNMC field 1
    • ORASFNML field 1
    • ORASLNR field 1
    • ORASTXTC field 1
    • ORASTXTF flag 1
    • ORASTXTL field 1
    • precompiler option 1
    • purpose 1 , 2
    • structure of 1
  • ORACABC field 1
  • ORACAID field 1
  • ORACA precompiler option 1 , 2 , 3 , 4 , 5 , 6 , 7
  • ORACCHF flag 1
  • Oracle Communications Area
    • ORACA 1
  • Oracle dynamic SQL
    • when to use 1
  • Oracle names
    • how to form 1
  • Oracle namespaces 1
  • Oracle Net
    • using ROWID datatype 1
    • using to connect to Oracle 1
  • Oracle Net Services
    • concurrent logons 1
  • Oracle Open Gateway
    • using ROWID datatype 1
  • ORACOC
    • in ORACA 1
  • ORACOC field 1
  • ORADBGF flag 1
  • ORAHCHF flag 1
  • ORAHOC field 1
  • ORAMOC field 1
  • ORANEX
    • in ORACA 1
  • ORANEX field 1
  • ORANOR field 1
  • ORANPR field 1
  • ORASFNM, in ORACA 1
  • ORASFNMC field 1
  • ORASFNML field 1
  • ORASLNR
    • in ORACA 1
  • ORASLNR field 1
  • orasql11.lib library file 1
  • ORASTXTC field 1
  • ORASTXTF flag 1
  • ORASTXTL field 1
  • ORECLEN precompiler option 1
  • OUT parameter mode 1
  • output host variable 1
  • output versus input 1

P

  • PAGELEN precompiler option 1
  • paragraph names
    • associating with SQL statements 1
    • coding area for 1
  • parameter mode 1
  • parse error offset 1
  • parsing dynamic statements
    • PREPARE statement 1
  • passwords
    • changing at runtime with ALTER AUTHORIZATION 1
    • defining 1
    • hardcoding 1
  • performance
    • causes of poor 1
    • improving 1
  • PIC G for Globalization Support characters 1
  • PIC N for Globalization Support characters 1
  • PICX precompiler option 1 , 2
  • PL/SQL
    • advantages 1
    • cursor FOR loop 1
    • datatype equivalents 1
    • embedded 1
    • exception 1
    • integration with server 1
    • opening a cursor variable
      • anonymous block 1
      • stored procedure 1
    • package 1
    • relationship with SQL 1
    • subprogram 1
    • user-defined record 1
  • PL/SQL block execution
    • effect on SQLCA components 1
  • PL/SQL blocks
    • embedded in Oracle7 precompiler programs 1
  • PL/SQL subprogram
    • calling from Pro*COBOL 1
  • PL/SQL table 1
  • placeholders
    • duplicate 1
  • PLAN_BASELINE
    • precompiler option 1
  • PLAN_ENABLED
    • precompiler option 1
  • PLAN_FIXED
    • precompiler option 1
  • PLAN_PREFIX
    • precompiler option 1
  • PLAN_RUN
    • precompiler option 1
  • plan, execution 1
  • precompilation
    • conditional 1
    • generated code 1
    • separate 1
  • precompilation unit 1
  • precompiler command
    • required arguments 1
  • precompiler options
    • abbreviating name 1
    • ANSI Dynamic SQL 1
    • ASACC 1
    • ASSUME_SQLCODE 1
    • AUTO_CONNECT 1 , 2
    • CLOSE_ON_COMMIT 1 , 2 , 3
    • COMP_CHARSET 1
    • CONFIG 1
    • current values 1
    • DATE_FORMAT 1
    • DBMS 1 , 2
    • DECLARE_SECTION 1 , 2
    • DEFINE 1
    • displaying 1
    • displaying syntax, default, purpose 1
    • DYNAMIC 1 , 2
    • END_OF_FETCH 1
    • entering 1
    • entering inline 1
    • entering on the command line 1
    • ERRORS 1
    • FIPS 1
    • FORMAT 1
    • HOLD_CURSOR 1 , 2
    • HOST 1
    • INAME 1
    • INCLUDE 1
    • IRECLEN 1
    • list 1
    • LITDELIM 1 , 2
    • LNAME 1
    • LRECLEN 1
    • LTYPE 1
    • macro and micro 1
    • MAXLITERAL 1
    • MAXOPENCURSORS 1 , 2 , 3
    • MODE 1 , 2 , 3 , 4
    • name of the system configuration file 1
    • NESTED 1
    • NLS_LOCAL 1
    • ONAME 1
    • ORACA 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8
    • ORECLEN 1
    • PAGELEN 1
    • PICX 1 , 2
    • PLAN_BASELINE 1
    • PLAN_ENABLED 1
    • PLAN_FIXED 1
    • PLAN_PREFIX 1
    • PLAN_RUN 1
    • precedence 1
    • PREFETCH 1 , 2 , 3
    • RELEASE_CURSOR 1 , 2
    • respecifying 1
    • scope of 1
    • SELECT_ERROR 1
    • specifying 1
    • SQLCHECK 1
    • syntax for 1
    • table of how macro options set micro options 1
    • THREADS 1
    • TYPE_CODE 1 , 2 , 3
    • UNSAFE_NULL 1
    • USERID 1
    • VARCHAR 1
    • XREF 1
  • precompilers
    • advantages 1
    • Globalization Support 1
    • language support 1
    • running 1
    • using PL/SQL 1
  • PREFETCH precompiler option 1 , 2 , 3
  • PREPARE statement
    • effect on data definition statements 1
    • examples 1
    • in dynamic SQL method 4 1
    • using in dynamic SQL 1 , 2
  • private SQL area
    • association with cursors 1
    • opening 1
    • purpose 1
  • Pro*COBOL
    • how it works 1
  • programming guidelines 1
  • programming language support 1
  • program termination 1
  • pseudocolumns
    • CURRVAL 1
    • LEVEL 1
    • NEXTVAL 1
    • ROWNUM 1

Q

  • queries
    • association with cursor 1
    • single-row versus multirow 1
  • query 1

R

  • RAW datatype
    • converting 1
    • external 1
  • RAWTOHEX function 1
  • read consistency 1
  • READ ONLY parameter
    • using in SET TRANSACTION 1
  • read-only transaction
    • ending 1
    • example 1
  • record, user-defined 1
  • REDEFINES clause
    • purpose 1
    • restrictions 1
  • reference
    • host variable 1
  • reference cursor 1
  • referencing
    • host tables 1
    • host variables 1
    • indicator variables 1
    • VARCHAR variables 1
  • relational operators
    • COBOL versus SQL 1
  • RELEASE_CURSOR option
    • of ORACLE Precompilers 1
  • RELEASE_CURSOR precompiler option 1
  • RELEASE option
    • COMMIT statement 1
    • omitting 1
    • restrictions 1
    • ROLLBACK statement 1
  • remote database
    • declaration of 1
  • restrictions
    • AT clause 1
    • CURRENT OF clause 1
    • cursor declaration 1
    • cursor variables 1
    • dynamic SQL 1
    • FOR clause 1
    • host tables 1 , 2 , 3 , 4
    • host variables
      • naming 1
      • referencing 1
    • input host variable 1
    • on host tables 1
    • REDEFINES clause 1
    • RELEASE option 1
    • separate precompilation 1
    • SET TRANSACTION statement 1
    • SQLGLM subroutine 1
    • SQLIEM subroutine 1
    • TO SAVEPOINT clause 1
    • use of CURRENT OF clause 1
  • retrieving rows from a table
    • embedded SQL 1
  • RETURN-CODE special register is unpredictable 1
  • returning clause
    • in INSERT 1
  • rollback
    • automatic 1
    • purpose 1
    • statement-level 1
  • roll back
    • to a savepoint 1
    • to the same savepoint multiple times 1
  • rollback segments 1
  • ROLLBACK statement
    • effects 1
    • ending a transaction 1
    • example 1
    • examples 1
    • RELEASE option 1
    • TO SAVEPOINT clause 1
    • using in a PL/SQL block 1
    • using in error-handling routines 1
    • where to place 1
  • rolling back
    • transactions 1
  • ROWID datatype
    • heap tables versus index-organized tables 1
    • Universal 1
    • use of 1
    • use of ALLOCATE 1
  • ROWID pseudocolumns
    • retrieving with SQLROWIDGET 1
    • universal ROWID 1
    • using to mimic CURRENT OF 1 , 2
  • row lock
    • acquiring with FOR UPDATE OF 1
    • using to improve performance 1
    • when acquired 1
    • when released 1
  • ROWNUM pseudocolumns 1
  • rows
    • fetching from cursors 1 , 2
    • inserting into tables and views 1
    • updating 1
  • rows-processed count 1
  • RR diagrams
    • see syntax diagrams 1

S

  • sample database table
    • DEPT table 1
    • EMP table 1
  • sample programs
    • calling a stored procedure 1
    • cursor operations 1
    • cursor variables
      • PL/SQL source 1
    • cursor variable use 1
    • datatype equivalencing 1
    • dynamic SQL Method 1 1
    • dynamic SQL method 2 1
    • dynamic SQL Method 3 1
    • dynamic SQL method 4 1
    • EXEC ORACLE scope 1
    • fetching in batches 1 , 2
    • LOBDEMO1.PCO 1
    • location of 1
    • PL/SQL examples 1
    • SAMPLE1.PCO 1
    • SAMPLE10.PCO 1
    • SAMPLE11.PCO 1
    • SAMPLE12.PCO 1
    • SAMPLE13.PCO 1
    • SAMPLE14.PCO 1
    • SAMPLE2.PCO 1
    • SAMPLE3.PCO 1
    • SAMPLE4.PCO 1
    • SAMPLE6.PCO 1
    • SAMPLE7.PCO 1
    • SAMPLE8.PCO 1
    • SAMPLE9.PCO 1
    • simple query 1
    • tables of group items 1
    • WHENEVER...DO CALL example 1
  • savepoint 1
  • savepoints
    • creating 1
    • when erased 1
  • SAVEPOINT statement
    • example 1
    • examples 1
  • scalar types 1
  • scale
    • definition of 1
    • using SQLPRC to extract 1
    • when negative 1
  • scope
    • cursor variables 1
    • of DECLARE STATEMENT directive 1
    • of precompiler options 1
    • of the EXEC ORACLE statement 1
    • WHENEVER directive 1
  • search condition
    • using in the WHERE clause 1
  • SELDFCLP variable (SQLDA) 1
  • SELDFCRCP variable (SQLDA) 1
  • SELDFMT variable (SQLDA) 1
  • SELDH-CUR-VNAMEL variable (SQLDA) 1
  • SELDH-MAX-VNAMEL variable (SQLDA) 1
  • SELDH-VNAME variable (SQLDA) 1
  • SELDI-CUR-VNAMEL variable (SQLDA) 1
  • SELDI-MAX-VNAMEL variable (SQLDA) 1
  • SELDI variable (SQLDA) 1
  • SELDI-VNAME variable (SQLDA) 1
  • SELDVLN variable (SQLDA) 1
  • SELDVTYP variable (SQLDA) 1
  • SELDV variable (SQLDA) 1
  • SELECT_ERROR option 1
  • SELECT_ERROR precompiler option 1
  • select descriptor 1
  • select descriptors
    • information in 1
  • select list 1
  • select-list items
    • naming 1
  • select SQLDA
    • purpose of 1
  • SELECT statement
    • available clauses 1
    • embedded SQL examples 1
    • example 1
    • INTO clause 1
    • using host tables 1
  • semantic checking
    • enabling 1
    • using the SQLCHECK option 1
  • separate precompilation
    • guidelines 1
    • restrictions 1
  • session 1
  • sessions
    • beginning 1
  • SET clause
    • using a subquery 1
  • SET DESCRIPTOR statement 1
  • SET TRANSACTION statement
    • example 1
    • READ ONLY parameter 1
    • restrictions 1
  • snapshot 1
  • SQL
    • summary of statements 1
  • SQL_CURSOR 1
  • SQL*Plus 1
  • SQLADR subroutine
    • example 1
    • parameters 1
    • storing buffer addresses 1
    • syntax 1
  • SQLCA
    • components set for a PL/SQL block 1
    • declaring EXTERNAL 1
    • fields 1
    • interaction with Oracle 1
    • overview 1
    • sharing 1
    • SQLCABC field 1
    • SQLCAID field 1
    • SQLCODE field 1
    • SQLERRD(3) field 1
    • SQLERRD(5) field 1
    • SQLERRMC field 1
    • SQLERRML field 1
    • SQLWARN(4) flag 1
    • using with Oracle Net Services 1
  • SQLCABC field 1
  • SQLCAID field 1
  • SQLCA status variable
    • data structure 1
    • declaring 1
    • effect of MODE option 1
    • explicit versus implicit checking 1
    • purpose 1
  • SQLCHECK option
    • using the DECLARE TABLE statement 1
    • using to check syntax/semantics 1
  • SQLCHECK precompiler option 1
  • SQLCODE field
    • interpreting its value 1
  • SQL codes
    • returned by SQLGLS routine 1
  • SQLCODE status variable
    • effect of MODE option 1
    • usage 1
  • SQL Communications Area 1
  • SQL-CONTEXT
    • host tables not allowed 1
    • variable declaration 1
  • SQLDA
    • bind versus select 1
    • BNDDFCLP variable 1
    • BNDDFCRCP variable 1
    • BNDDFMT variable 1
    • BNDDH-CUR-VNAMEL variable 1
    • BNDDH-MAX-VNAMEL variable 1
    • BNDDH-VNAME variable 1
    • BNDDI-CUR-VNAMEL variable 1
    • BNDDI-MAX-VNAMEL variable 1
    • BNDDI variable 1
    • BNDDI-VNAME variable 1
    • BNDDVLN variable 1
    • BNDDVTYP variable 1
    • BNDDV variable 1
    • declaring 1
    • example 1
    • information stored in 1
    • purpose 1
    • SELDFCLP variable 1
    • SELDFCRCP variable 1
    • SELDFMT variable 1
    • SELDH-CUR-VNAMEL variable 1
    • SELDH-MAX-VNAMEL variable 1
    • SELDH-VNAME variable 1
    • SELDI-CUR-VNAMEL variable 1
    • SELDI-MAX-VNAMEL variable 1
    • SELDI variable 1
    • SELDI-VNAME variable 1
    • SELDVLN variable 1
    • SELDVTYP variable 1
    • SELDV variable 1
    • SQLADR subroutine 1
    • SQLDFND variable 1
    • SQLDNUM variable 1
    • structure 1
  • SQL Descriptor Area 1 , 2
  • SQLDFND variable (SQLDA) 1
  • SQL directives
    • CONTEXT USE 1
    • DECLARE CURSOR 1
    • DECLARE DATABASE 1
    • DECLARE STATEMENT 1
    • DECLARE TABLE 1
    • VAR 1
    • WHENEVER 1
  • SQL directives CONTEXT USE 1
  • SQLDNUM variable (SQLDA) 1
  • SQLERRD(3) field
    • using with batch fetch 1
  • SQLERRD(3) variable 1
  • SQLERRD(5) field 1
  • SQLERRMC field 1
  • SQLERRMC variable 1
  • SQLERRML field 1
  • SQLERROR condition
    • of WHENEVER directive 1
    • WHENEVER directive 1
  • SQLFC parameter 1
  • SQLGLM subroutine
    • example 1
    • parameters 1
    • provides DSNTIAR support for DB2 conversions 1
    • purpose 1
    • restrictions 1
    • syntax 1
  • SQLGLS routine
    • parameters 1
    • SQL codes returned by 1
    • syntax 1
    • using to obtain SQL text 1
  • SQLIEM subroutine
    • restrictions 1
  • SQLNUL subroutine
    • example 1
    • parameters 1
    • purpose 1
    • syntax 1
  • SQLPRC subroutine
    • example 1
    • parameters 1
    • purpose 1
    • syntax 1
  • SQLROWIDGET
    • retrieving ROWID of last row inserted 1
  • SQLSTATE
    • declaring 1
  • SQL statements
    • ALLOCATE 1
    • ALLOCATE DESCRIPTOR 1
    • CALL 1
    • CLOSE 1
    • COMMIT 1
    • CONNECT 1
    • CONTEXT ALLOCATE 1
    • CONTEXT FREE 1
    • controlling transactions 1
    • DEALLOCATE DESCRIPTOR 1
    • DELETE 1
    • DESCRIBE 1
    • DESCRIBE DESCRIPTOR 1
    • ENABLE THREADS 1
    • EXECUTE 1
    • EXECUTE...END-EXEC 1
    • EXECUTE DESCRIPTOR 1
    • EXECUTE IMMEDIATE 1
    • FETCH 1 , 2
    • FETCH DESCRIPTOR 1
    • FREE 1
    • GET DESCRIPTOR 1
    • INSERT 1
    • LOB APPEND 1
    • LOB ASSIGN 1
    • LOB CLOSE 1
    • LOB COPY 1
    • LOB CREATE 1
    • LOB DESCRIBE 1
    • LOB DISABLE BUFFERING 1
    • LOB ENABLE BUFFERING 1
    • LOB ERASE 1
    • LOB FILE CLOSE 1
    • LOB FILE SET 1
    • LOB FLUSH BUFFER 1
    • LOB FREE TEMPORARY 1
    • LOB LOAD 1
    • LOB OPEN 1
    • LOB READ 1
    • LOB TRIM 1
    • LOB WRITE 1
    • OPEN 1 , 3
    • OPEN DESCRIPTOR 1
    • optimizing to improve performance 1
    • PREPARE 1
    • ROLLBACK 1
    • SAVEPOINT 1
    • SELECT 1
    • SET DESCRIPTOR 1
    • static versus dynamic 1
    • summary of 1
    • UPDATE 1
    • using to control a cursor 1 , 2
  • SQLSTATE status variable
    • class code 1
    • coding scheme 1
    • effect of MODE option 1
    • interpreting values 1
    • predefined classes 1
    • subclass code 1
    • usage 1
  • SQLSTM parameter 1
  • SQLSTM routine 1
  • SQLWARN(4) flag 1
  • SQLWARNING
    • condition WHENEVER directive 1
  • SQLWARNING condition
    • of WHENEVER directive 1
  • statement-level rollback
    • breaking deadlocks 1
  • status codes for error reporting 1
  • STMLEN parameter 1
  • STOP action
    • of WHENEVER directive 1 , 2
  • stored procedure
    • opening a cursor 1
    • sample programs 1
  • stored procedures
    • opening a cursor 1
    • sample programs 1
  • stored subprogram
    • calling 1
    • creating 1
    • packaged versus standalone 1
    • stored versus inline 1
    • using to improve performance 1
  • stored subprogram, calling 1
  • STRING datatype 1
  • string literals
    • continuing on the next line 1
  • subprogram, PL/SQL 1
  • subprogram, PL/SQL or Java 1
  • subquery
    • example 1 , 2
    • using in the SET clause 1
    • using in the VALUES clause 1
  • syntactic checking 1
  • syntax
    • continuation lines 1
    • embedded SQL statements 1
    • SQLADR subroutine 1
    • SQLGLM subroutine 1
    • SQLNUL subroutine 1
    • SQLPRC 1
  • syntax, embedded SQL 1
  • syntax diagrams
    • description of 1
    • how to read 1
    • how to use 1
    • symbols used in 1
  • SYSDATE function 1
  • SYSDBA privilege show to set 1
  • SYSOPER privilege
    • how to set 1
  • system failures
    • effect on transactions 1
  • System Global Area (SGA) 1

T

  • table (host) elements
    • maximum 1
  • table lock
    • acquiring with LOCK TABLE 1
    • row share 1
    • when released 1
  • tables
    • elements 1
    • index-organized 1
    • inserting rows into 1
    • updating rows in 1
  • tables, host 1
  • TERMINAL format
    • COBOL statements 1
  • terminator for embedded SQL statements 1
  • threads
    • allocating context 1 , 2
    • enabling 1 , 2
    • freeing context 1 , 2
    • use context 1 , 2
  • THREADS
    • precompiler option 1
  • TIMESTAMP datatype 1
  • TIMESTAMP WITH LOCAL TIME ZONE datatype 1
  • TIMESTAMP WITH TIME ZONE datatype 1
  • TO SAVEPOINT clause
    • restrictions 1
    • using in ROLLBACK statement 1
  • trace facility
    • using to improve performance 1
  • transaction 1
  • transactions
    • committing 1
    • contents 1
    • guidelines 1
    • how to begin 1
    • how to end 1
    • in-doubt 1
    • making permanent 1
    • read-only 1
    • rolling back 1
    • subdividing with savepoints 1
    • undoing 1
    • undoing parts of 1
    • when rolled back automatically 1 , 2
  • truncated values
    • detecting 1
    • indicator variables 1
  • truncation errors
    • when generated 1
  • tuning, performance 1
  • TYPE_CODE option
    • effect on functionality 1
  • TYPE_CODE precompiler option 1 , 2
  • TYPE statements
    • using the CHARF datatype specifier 1

U

  • UID function 1
  • undo a transaction 1
  • universal ROWID
    • ROWID pseudocolumns 1
  • UNSAFE_NULL precompiler option 1
  • UNSIGNED datatype 1
  • UPDATE statement
    • embedded SQL examples 1
    • example 1
    • SET clause 1
    • using host tables 1
  • updating
    • rows in tables and views 1
  • use
    • thread context 1
  • user-defined record 1
  • USER function 1
  • USERID option
    • using with the SQLCHECK option 1
  • USERID precompiler option 1
  • usernames
    • defining 1
    • hardcoding 1
  • user session 1
  • USING clause
    • CONNECT statement 1
    • of FETCH statement 1
    • of OPEN statement 1
    • using indicator variables 1
    • using in the EXECUTE statement 1
  • using dbstring
    • Oracle Net Services database id specification 1

V

  • V7
    • value of DBMS option 1
  • VALUE clause
    • initializing host variables 1
  • VALUES clause
    • INSERT statement 1
    • of embedded SQL INSERT statement 1
    • of INSERT statement 1
    • using a subquery 1
  • VARCHAR2 datatype
    • external 1
  • VARCHAR datatype 1
  • VARCHAR precompiler option 1
  • VARCHAR pseudotype
    • using with PL/SQL 1
  • VARCHAR variables
    • advantages 1
    • as input variables 1
    • as output variables 1
    • declaring 1
    • implicit group items 1
    • length element 1
    • maximum length 1
    • referencing 1
    • server handling 1 , 2
    • string element 1
    • structure 1
    • versus fixed-length strings 1
    • with PL/SQL 1
  • VAR directive
    • examples 1
  • VARNUM datatype 1
  • VARRAW datatype 1
  • VAR statement
    • CONVBUFSZ clause 1
    • syntax for 1
    • using the CHARF datatype specifier 1
  • VARYING keyword
    • versus VARYING phrase 1
  • versions of COBOL supported 1
  • views
    • inserting rows into 1
    • updating rows in 1

W

  • warning flags for error reporting 1
  • WHENEVER
    • DO CALL example 1
  • WHENEVER directive
    • careless usage 1
    • CONTINUE action 1
    • DO CALL action 1
    • DO PERFORM action 1
    • example 1
    • examples 1
    • GOTO action 1
    • overview 1
    • purpose 1
    • scope of 1
    • SQLERROR condition 1
    • SQLWARNING condition 1
    • STOP action 1
    • syntax 1
    • using to check SQLCA automatically 1
  • WHERE clause
    • DELETE statement 1
    • of DELETE statement 1
    • of UPDATE statement 1
    • search condition 1
    • SELECT statement 1
    • UPDATE statement 1
    • using host tables 1
  • WHERE CURRENT OF clause 1
  • WITH HOLD
    • clause of DECLARE CURSOR statement 1
  • WORK option
    • of COMMIT statement 1
    • of ROLLBACK statement 1

X

  • XREF precompiler option 1