Database Access

Index

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

A

Additional data types, DB2 8.1.2
ALTER TABLE statement
dBASE C.3.7
text C.8.7
Arrays
host arrays 2.2
indicator arrays 2.3.3

BEGIN DECLARE SECTION ApD
BEGIN TRAN ApD
bigint data type 3.2.4
binary data type
COBSQL - Informix 3.7.2.3
COBSQL - Oracle 3.7.2.1
COBSQL - Sybase 3.7.2.2
OpenESQL 3.7.1
OpenESQL - DB2 3.7.1.1
Binding, DB2 8.8
Building an application 7.6

C

CALL ApD
char data type 3.3.1
Character data types 3.3
Character sets C.1.3
CLOSE ApD
cobol.dir 9.2.1
COBSQL Ch9
and Informix 9.6.4
and Oracle 9.6.2
and Oracle 1.8 9.6.2.1
and Sybase 9.6.3
COBOL directives 9.2.3
cobol.dir 9.2.1
cobsql.dir 9.2.1
common problems 9.6.1
converting data types 3.1.1
CP 9.3
directives 9.2.2
END-C 9.2
ENDP 9.2
error messages ApB
examples 9.5
operation 9.2
Oracle and Micro Focus COBOL 9.6.2.2.3
Oracle 8 Directives 9.6.2.2.1
Oracle migrating versions 9.6.2.2.2
Oracle Pro*COBOL 8.x 9.6.2.2
overview 9.1
specifying directives 9.2.1
troubleshooting 9.6
cobsql.dir 9.2.1
COMMIT ApD
Compiler directive, DB2 8.5.1
Compiling 7.6
DB2 8.5
Compound SQL, DB2 8.2
Concat operator, DB2 8.3.7
CONCURRENCY 4.5
CONFIRM (C) E.4
CONNECT 7.4 , ApD
Connect ODBC
DB2 C.2
dBASE C.3
INFORMIX C.4
OpenIngres C.5
Oracle C.6
Sybase C.7
Text C.8
Connecting to a database 7.4
Connection string attributes C.3.3
DB2 C.2.3
INFORMIX C.4.2
OpenIngres C.5.2
Oracle C.6.2.1
Sybase C.7.2
text C.8.2
Connections supported
DB2 C.2.7
dBASE C.3.14
INFORMIX C.4.6
OpenIngres C.5.6
Oracle C.6.7
Sybase C.7.6
text C.8.9
Converting data types 3.1
COBSQL 3.1.1
CP preprocessor ApE
COPY statement E.2 , E.2.1
copyfile expansion E.2
CP directives E.4
CP error messages E.5
limitations E.1.1
REPLACE notification E.3
CREATE INDEX statement, dBASE C.3.8
Cursors Ch4
closing 4.4
CONCURRENCY 4.5
declaring 4.1
dynamic SQL 6.4
opening 4.2
positioned DELETE 4.6
positioned UPDATE 4.6
retrieving data 4.3
SCROLLOPTION 4.5
using 4.7

D

Data source configuration
DB2 C.2.3
dBASE C.3.3
INFORMIX C.4.2
OpenIngres C.5.2
Oracle C.6.2
Sybase C.7.2
text C.8.4
Data truncation 2.3.2
Data types Ch3
bigint 3.2.4
binary 3.7
char 3.3.1
character 3.3
converting 3.1
date 3.6
DB2 8.1 , C.2.4
dBASE C.3.4
decimal 3.5
double 3.4
float 3.4
INFORMIX C.4.3
int 3.2.3
integers 3.2
numeric 3.5
OpenESQL 7.9
OpenIngres C.5.3
Oracle C.6.3
real 3.4
smallint 3.2.2
Sybase C.7.3
text C.8.5
time 3.6
timestamp 3.6
tinyint 3.2.1
varbinary 3.7
varchar 3.3.2
Database, connecting 7.4
DataDirect OEM ANSI translator C.1.4
date data type 3.6
COBSQL - Informix 3.6.2.3
COBSQL - Oracle 3.6.2.1
COBSQL - Sybase 3.6.2.2
DB2 3.6.1.1
OpenESQL 3.6.1
DB2 Ch8
additional data types 8.1.2
binding to database 8.8 , C.2.2
Compiler directive 8.5.1
compiling 8.5
Compound SQL 8.2
concat operator 8.3.7
configuring data source C.2.3
connecting to data source C.2.3
connection string attributes C.2.3
connections supported C.2.7
data types 8.1 , C.2.4
DECIMAL data type 8.1.1
DECLARE TABLE statement 8.3.2
default values 8.5.1.1
DRDA 8.5.1.1 , 8.5.1.2
error codes 8.6
INCLUDE statement 8.3.1
INIT directive 8.4
isolation levels C.2.5
linking 8.7
locking levels C.2.5
nested COBOL programs 8.3.10
NOT operator 8.3.6
object-oriented COBOL syntax 8.3.9
ODBC conformance C.2.6
running 8.7
SQLCA 8.3.8
statements supported C.2.7
system requirements C.2.1
WHENEVER statement 8.3.9
dBASE
ALTER TABLE statement C.3.7
column names C.3.5
configuring data source C.3.3
connecting to data source C.3.3
connection string attributes C.3.3
connections supported C.3.14
CREATE INDEX statement C.3.8
data types C.3.4
defining index attributes C.3.2
DROP INDEX statement C.3.9
isolation levels C.3.12
locking C.3.11
locking levels C.3.11.1 , C.3.12
ODBC conformance C.3.13
PACK statement C.3.10
Rowid pseudo-column C.3.6.1
SELECT statement C.3.6
statements supported C.3.14
system requirements C.3.1
DECIMAL data type, DB2 8.1.1
decimal data type 3.5
DECLARE CURSOR 4.1 , ApD
object oriented COBOL syntax 4.1.1
DECLARE DATABASE ApD
DECLARE TABLE statement, DB2 8.3.2
DELETE (POSITIONED) ApD
DELETE (SEARCHED) ApD
Demonstration applications 7.7
DESCRIBE 5.2.4.4 , ApD
DISCONNECT ApD
double data type 3.4
DRDA
DB2 8.5.1.1 , 8.5.1.2
DROP INDEX statement, dBASE C.3.9
Dynamic SQL Ch6
CALL statements 6.4.1
cursors 6.4
EXECUTE IMMEDIATE 6.3.1
executing 6.3
FREE 6.3.2
preparing statements 6.2

E

ECM Ch8
Embedded SQL Ch8
END DECLARE SECTION ApD
Environment variables C.1.2
Error codes, DB2 8.6
Error messages
COBSQL ApB
CP preprocessor E.5
EXECSP ApD
EXECUTE 5.2.4.3 , ApD
EXECUTE IMMEDIATE 6.3.1 , ApD
External Checker Module Ch8

F

FETCH 4.3 , 5.2.4.2 , ApD
File, system information C.1.1
float data type 3.4
FOR clause 2.2.1
Formats for text files C.8.1
FREE 6.3.2

G

No entries

H

Host variables
data truncation 2.3.2
declaring 2.1
groups and indicator arrays 8.3.5
host arrays 2.2
indicator variables 2.3
integer 8.3.3
null values 2.3.1
overview Ch2
qualified 8.3.4

I

INCLUDE statement ApD
DB2 8.3.1
Indicator variables 2.3
INFORMIX
configuring data source C.4.2
connecting to data source C.4.2
connection string attributes C.4.2
connections supported C.4.6
data types C.4.3
INFORMIXDIR C.4.1
isolation levels C.4.4
locking levels C.4.4
ODBC conformance C.4.5
statements supported C.4.6
system requirements C.4.1
INIT directive, DB2 8.4
INSERT ApD
int data type 3.2.3
Integer data types 3.2
Isolation levels
DB2 C.2.5
dBASE C.3.12
INFORMIX C.4.4
OpenIngres C.5.4
Oracle C.6.5
Sybase C.7.4
ivtestlib C.1.3.1

J

No entries

K

Keywords
ODBC A.2
OpenESQL 7.5 , A.1

L

LIMITED-SEARCH (LS) E.4
Linking, DB2 8.7
Locking levels
DB2 C.2.5
dBASE C.3.12
INFORMIX C.4.4
OpenIngres C.5.4
Oracle C.6.5
Sybase C.7.4

M

MFSQLMESSAGETEXT, DB2 8.3.8

N

National Language Support 9.4
Nested COBOL programs, DB2 8.3.10
NLS 9.4
NOT operator, DB2 8.3.6
Null values 2.3.1
numeric data type 3.5

O

Object-oriented COBOL Syntax, DB2 8.3.9
ODBC
data source name 7.1
drivers 7.1
DSN 7.1
reserved keywords A.2
ODBC conformance
DB2 C.2.6
dBASE C.3.13
INFORMIX C.4.5
OpenIngres C.5.5
Oracle C.6.6
Sybase C.7.5
text C.8.8
ODBC connection, system requirements C.1
.odbc.ini C.1.1
OPEN 5.2.4.3 , ApD
OpenESQL
keywords 7.5
reserved keywords A.1
stored procedures 7.11
OpenIngres
configuring data source C.5.2
connecting to data source C.5.2
connection string attributes C.5.2
connections supported C.5.6
data types C.5.3
isolation levels C.5.4
locking levels C.5.4
ODBC conformance C.5.5
statements supported C.5.6
system requirements C.5.1
Oracle
configuring data source C.6.2
connecting to data source C.6.2
connection string attributes C.6.2.1
connections supported C.6.7
data types C.6.3
isolation levels C.6.5
locking levels C.6.5
ODBC conformance C.6.6
statements supported C.6.7
stored procedure results C.6.4
system requirements C.6.1
Oracle OCI support 7.1.1

P

PACK statement, dBASE C.3.10
Place holders, COBSQL - Oracle 6.2.1.1
Positioned
DELETE 4.6
UPDATE 4.6
PREPARE 5.2.4.1 , 6.2 , ApD
Oracle 6.2.1.2
PREPROCESS (P) E.4

Q

QUERY ODBC ApD

R

real data type 3.4
ROLLBACK ApD
Rowid pseudo-column, dBASE C.3.6.1
Running, DB2 8.7

S

SCROLLOPTION 4.5
SELECT DISTINCT (using DECLARE CURSOR) ApD
SELECT INTO ApD
SELECT statement
dBASE C.3.6
text C.8.6
SET AUTOCOMMIT ApD
SET CONCURRENCY ApD
SET CONNECTION ApD
SET OPTION ApD
SET SCROLLOPTION ApD
SET TRANSACTION ISOLATION ApD
smallint data type 3.2.2
SQL
SQL Communications Area 8.3.8
SQLCA 8.3.8
SQL (S) E.4
SQL Communications Area 5.1
SQL compiler directive 7.2
SQL Descriptor Area 5.2
COBSQL 5.2.1
COBSQL - Informix 5.2.1.3
COBSQL - Oracle 5.2.1.1
COBSQL - Sybase 5.2.1.2
OpenESQL 5.2.2
SQL statements ApD
case 1.2
overview 1.2
SQLCA 5.1
DB2 8.3.8
using 7.10
sqlca.cbl 8.3.8
sqlca.cpy 7.6 , 7.10
SQLCODE 5.1 , 5.1.1
SQLDA 5.2
COBSQL 5.2.1
COBSQL - Informix 5.2.1.3
COBSQL - Oracle 5.2.1.1
COBSQL - Sybase 5.2.1.2
OpenESQL 5.2.2
using 5.2.4
sqlda.cpy 5.2.2 , 7.6
SQLERRD data area 5.1.6
COBSQL 5.1.6.1
DB2 5.1.6.2
SQLERRM data area 5.1.5
SQLERRML 5.1.5 , 5.1.5
SQLSTATE 5.1 , 5.1.2
SQLTYPE, valid values 5.2.3
SQLWARN 5.1.3
SQLWARN flags 5.1
Statements supported
DB2 C.2.7
dBASE C.3.14
INFORMIX C.4.6
OpenIngres C.5.6
Oracle C.6.7
Sybase C.7.6
text C.8.9
Stored procedures, OpenESQL 7.11
SY E.4
Sybase
configuring data source C.7.2
connecting to data source C.7.2
connection string attributes C.7.2
connections supported C.7.6
data types C.7.3
isolation levels C.7.4
locking levels C.7.4
ODBC conformance C.7.5
statements supported C.7.6
system requirements C.7.1
System information file C.1.1
System requirements
DB2 C.2.1
dBASE C.3.1
INFORMIX C.4.1
OpenIngres C.5.1
Oracle C.6.1
Sybase C.7.1

T

Table structure, defining C.8.2
Text
ALTER TABLE statement C.8.7
configuring data source C.8.4
connecting to data source C.8.4
connection string attributes C.8.2
connections supported C.8.9
data types C.8.5
date masks C.8.3
formats C.8.1
ODBC conformance C.8.8
SELECT statement C.8.6
statements supported C.8.9
under UNIX C.8.2
time data type 3.6
COBSQL - Informix 3.6.2.3
COBSQL - Oracle 3.6.2.1
COBSQL - Sybase 3.6.2.2
DB2 3.6.1.1
OpenESQL 3.6.1
timestamp data type 3.6
tinyint data type 3.2.1
TRACE (T) E.4
Transactions 7.8
Translators C.1.4
Troubleshooting C.1.3.1
Truncation 2.3.2

U

UNIX, supported platforms for ODBC connection C.1
UNIX environment
double-byte character sets C.1.3
environment variables C.1.2
ivtestlib tool C.1.3.1
system information file C.1.1
system requirements C.1
translators C.1.4
UPDATE (POSITIONED) ApD
UPDATE (SEARCHED) ApD

V

varbinary data type
COBSQL - Informix 3.7.2.3
COBSQL - Oracle 3.7.2.1
COBSQL - Sybase 3.7.2.2
OpenESQL 3.7.1
OpenESQL - DB2 3.7.1.1
varchar data type 3.3.2
COBSQL - Informix 3.3.2.5
COBSQL - Oracle 3.3.2.3
COBSQL - Sybase 3.3.2.4
OpenESQL 3.3.2.1
OpenESQL - DB2 3.3.2.2
Variables
host arrays 2.2
host variables Ch2
indicator variables 2.3.1