Index

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

A

accessing

gateway

main topic, 3.2

Advanced Security

function of the gateway, 1.3.3

purpose, 1.3.3

AIX

AIX_RS6K, default value for DRDA_LOCAL_NODE_NAME, B.3.27

alias

DB2, B.3.19

alias objects, DB2

known restrictions, 2.5

ALL_CATALOG view, A.2.1

ALL_COL_COMMENTS view, A.2.2

ALL_CON_COLUMNS view, A.2.3

ALL_CONSTRAINTS view, A.2.4

ALL_DB_LINKS data dictionary view, 3.1.3

ALL_INDEXES view, A.2.5

ALL_OBJECTS view, A.2.7

ALL_SYNONYMS view, A.2.8

ALL_TAB_COMMENTS view, A.2.11

ALL_TABLES view, A.2.9

ALL_USERS view, A.2.12

ALL_VIEWS view, A.2.13

ALTER session statement, 3.1.1

ANSI-standard SQL, 1.3.5, 1.9

APPEND command

supported by COPY, 3.8

application

portability, 1.9

server support, 1.3.3

application development on the gateway, 1.9

architecture of the gateway, 1.5

array size

fetch reblocking, 1.9

how determined, 4.1.1

AS/400

files and file members, accessing, 3.3

library name, DRDA_PACKAGE_COLLID, B.3.30

ASCII

code page, C.3

sort order, 4.6.2

tables, known restrictions, 1.9

translated from EBCDIC, 4.7.1

US7ASCII, C.3.2.1

US7ASCII, Globalization Support, C.2

autonomy, site, 1.3.14

B

binary data, non-character, 4.7.1

bind variables

known restrictions, SQL limitations, 2.5.2

SQL passthrough, 4.8

bug

debugging

debug library, 5.4.2

drc values in the DRDA software, 5.1.3

setting trace parameters, 5.4

SQL tracing, 3.10

number 205538, known restrictions, SQL limitations, 2.5.2

C

call

a CICS or IMS transaction, 4.3.2

DB2 stored procedure, 4.3, 4.3.1

empproc stored procedure, 4.3

Oracle Call Interfaces, 5.1

PL/SQL, 4.3.1

stored procedure

creating a synonym to maintain location transparency, 4.2

using standard Oracle PL/SQL, 4.2

to stored procedure

known restrictions, 2.5.1

capabilities of DRDA server, native semantics, 4.6

CCSID

65535 as the default for all tables created, B.3.18

CCSID (coded character set identifiers), defined, C.5

code page mapping facility, C.4

DRDA server, Globalization Support, C.1

external mapping to Oracle character sets supported, 1.9

changes in this release

IBM DB2 Version 5.1 EBCDIC and ASCII Tables, 1.9

IBM DB2/UDB supported, 1.9

read-only support, 1.9

CHARACTER SET

clause, client/server configuration, C.2

parameter description, C.1

character sets

and code page map facility, C.4

ASCII, 1.9

codepage, B.3.18

EBCDIC, 1.9

Heterogeneous Services, B.3.6.1

supported, 1.9

character string

converting datatypes, 4.7.2

performing operations, 4.7.2

CHECKSUM command

extended advanced networking, 1.3.3

CICS transaction, 4.3.2

clauses

CHARACTER SET, client/server configuration, C.2

CONNECT TO, 3.1.1

GROUP BY, SQL Set Clauses, 4.6.3

HAVING, SQL Set Clauses, 4.6.3

ORDER BY, SQL Set Clauses, 4.6.3

SQL

DELETE, 4.7.7

INSERT, 4.7.7

SELECT WHERE, 4.7.7

UPDATE, 4.7.7

USING, 3.1.1

VALUES

functions not allowed by DB2, 4.7.7

WHERE

known restrictions, SQL limitations, 2.5.2

SQL Set Clauses, 4.6.3

WHERE CURRENT OF CURSOR, known restrictions, SQL limitations, 2.5.2

code page map facility

for data translation, C.4

code tracing, B.3.46

codepage map facility

configuring support for character sets, known restrictions, 2.5.1

supported by gateway, 1.9

coercion

of data, 4.6

column

date columns, TO_DATE function, 4.7.7

Oracle ROWID

known restrictions, 2.5.2

supported in a result set, 1.9

commands

CHECKSUM, 1.3.3

COPY

known restrictions, 2.5

Oracle database to DRDA server, 3.8

SQL*Plus command, 3.8

EXECUTE, 1.3.9

EXPLAIN PLAN, 5.4.1

INSERT

known restrictions, 2.5

not supported, 3.8

commit confirm protocol, 1.3.13

compatible SQL set operators and clauses, 4.6.3

concatenation restrictions, string concatenation of numbers, 2.5.1

CONNECT BY not supported

known restrictions, SQL limitations, 2.5.2, 2.5.2

CONNECT TO clause, 3.1.1

convert

character string, 4.7.2

datatypes

DRDA to Oracle datatypes, 4.7

DATE, 4.7.4.2

floating point to integer, 4.7.8

into most suitable datatype, 4.7.10

SQL, 1.7

to the numeric datatype, 4.7.8

converter, protocol, 1.3.3

COPY command

Oracle database to DRDA server, 3.8

COPY SQL*Plus command, 3.8

substituted for INSERT, known restrictions, 2.5

copying data

from the DRDA server, 3.9

from the Oracle database to DRDA server, 3.8

COS SQL function, 4.5.3.1

COUNT function, 4.7.9

CREATE command

supported by COPY, 3.8

CREATE DATABASE LINK command, 3.1.1

CREATE DATABASE statement, client/server configuration, C.2

CREATE TABLE statement, 1.3.8

creating

database link, 3.1.1

cursor

defining the number of, 4.10

number of cursors, DRDA_PACKAGE_SECTIONS, B.3.34

stability, DRDA_ISOLATION_LEVEL, B.3.26

D

data coercion, 4.6

data control language (DCL), 1.3.7

DATA datatype, 4.7.4.1

data definition language (DDL), 1.3.6

data dictionary

using, 4.9.1

views

ALL_DB_LINKS, 3.1.3

emulation on DRDA server, 4.9

for DB2/UDB not supported, A.1

list and descriptions, A.2

supported for DB2/OS390 and DB2/400 servers, A.1

USER_DB_LINKS, 3.1.3

database

catalogs, 4.9

link

behavior, 4.4

creating, 3.1.1

dropping links, 3.1.2

examining, 3.1.3

guidelines, 3.1.1

limits, 3.1.4

processing, 3.1

suffix, 4.1

to identify the gateway, 1.7

triggers, 1.3.2

datatype

character string, 4.7.1

column (ALL_TAB_COLUMNS), A.2.10

column (USER_TAB_COLUMNS), A.2.26

conversion

DRDA to Oracle datatypes, 4.7

no control over, 4.7.8

converting character string, 4.7.1, 4.7.2

data and time, 4.7.4

differences between Oracle database and DRDA databases, 4

DRDA server datatypes list, 4.7

mapping, 4.7

numeric, 4.7.10

operations, numeric, 4.7.8

Oracle datatypes RAW and LONG RAW, 4.7.1

restrictions, 4.7

size and value limitations, 4.7

datatypes

DATE, 4.7.4

GRAPHIC, 4.7.3

LONG, 4.7.2

LONG RAW, 4.7.1

Oracle and IBM DATE, 4.7.4.2

Oracle DATE, 4.7.4.1

RAW

character string operations, 4.7.1

DRDA_DEFAULT_CCSID, B.3.18

TIME, 4.7.4

TIMESTAMP, 4.7.4

VARCHAR, 4.7.2

date

date columns, TO_DATE function, 4.7.7

DELETE

statement, 4.7.5

HS_NLS_DATE_FORMAT parameter, 4.7.5, 4.7.6

INSERT

statement, 4.7.5

operations, 4.7.4

SELECT statement, 4.7.5

TO_DATE function, 4.7.5

UPDATE

statement, 4.7.5

date arithmetic

known restrictions, 2.5.1

DATE datatype, 4.7.4

date formats

Heterogeneous Services, B.3.47

DB_DOMAIN parameter

known restrictions, 2.5.1

DB2

alias objects

known restrictions, 2.5

aliases, B.3.19

CICS, 4.3.2

data access, 1.3.9

DRDA_DESCRIBE_TABLE compatibility, B.3.19

IBM DB2 Version 5.1 ASCII Tables, 1.9

IMS, 4.3.2

native SQL, 1.3.8

native stored procedures, 1.3.9

procedural feature considerations, 4.3.2

SQL statements, 4.8.2

statements

CREATE TABLE, 1.3.8

stored procedures, 4.3.2

DB2/400

catalog view, 4.9.1

data dictionary views supported by gateway, A.1

DRDA_DEFAULT_CCSID, B.3.18

DRDA_ISOLATION_LEVEL, B.3.26

DRDA_OPTIMIZE_QUERY, B.3.29

DRDA_PACKAGE_COLLID, B.3.30

DB2/OS390

catalog view, 4.9.1

data dictionary views supported by gateway, A.1

DRDA_ISOLATION_LEVEL, B.3.26

DRDA_OPTIMIZE_QUERY, B.3.29

V6, V7 and V8 stored procedures supported, 1.9

DB2/UDB

catalog view, 4.9.1

data dictionary views not supported, A.1

DRDA_ISOLATION_LEVEL, B.3.26

DRDA_OPTIMIZE_QUERY, B.3.29

known restrictions, 2.5.1

supported, 1.9

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 4.8

DD basic tables, known restrictions, 2.5.1

DDL

statement, 4.8

debug

gateway, 5.4

library, 5.4.2

debugging

error codes, 5.1.3

SQL tracing, 5.4

your application, 3.10

DELETE

known restrictions, SQL limitations, 2.5.2

operation, 4.1

read-only gateway, 3.6

SQL clause, 4.7.7

statement, 4.8

DESCRIBE

character string operations, 4.7.1

describe cache high water mark

definition, B.3.5

diagnostic parameter, B.3.44

dictionary

mapping, 1.3.4

tables, 4.9

DICTIONARY view, A.2.15

distributed

applications, support for, 1.9

distributed query optimizer (DQO)

DRDA-specific parameters, B.3.29

performing distributed queries, 3.5

DRDA transactions, 3.5.2

queries

two-phase commit, 3.5.1

transaction, DRDA_RECOVERY_USERID, B.3.37

double-byte support, C.5

DQO

also see distributed query optimizer, 3.5

DRDA-specific parameters, B.3.29

drc error code, 5.1.3

DRDA

catalog, 4.9.2

defining number of cursors, 4.10

DRDA Application Server Function, 1.9

DRDA server

architecture, 1.5

capabilities, native semantics, 4.6

CCSID

character set to store data in DRDA database, C.1

gateway code page map facility, C.4

parameters needed for Globalization Support, C.1

character sets

known restrictions, 2.5.1

functions, 4.6

stored procedures, 4.3

DRDA_CODEPAGE_MAP parameter, C.4

DRDA_COMM_BUFLEN parameter, B.3.16

DRDA_CONNECT_PARM (TCP/IP format) parameter, B.3.17

DRDA_CONNECT_PARM parameter

communication errors, 5.1.4

DRDA_DEFAULT_CCSID parameter, B.3.18

DRDA_DESCRIBE_TABLE parameter

defined, B.3.19

known restrictions, 2.5

DRDA_DESCRIBE_TABLE=FALSE initialization parameter

known restrictions, 2.5

DRDA_DISABLE_CALL parameter

defined, B.3.20

DRDA_FLUSH_CACHE parameter, B.3.21

DRDA_GRAPHIC_LIT_CHECK parameter, B.3.24

DRDA_GRAPHIC_PAD_SIZE parameter, B.3.23

DRDA_GRAPHIC_TO_MBCS parameter, B.3.25

DRDA_ISOLATION_LEVEL parameter, B.3.26

DRDA_LOCAL_NODE_NAME parameter, B.3.27

DRDA_MBCS_TO_GRAPHIC parameter, B.3.28

DRDA_OPTIMIZE_QUERY parameter

defined, B.3.29

DQO capability turned on and off, 3.5

DRDA_PACKAGE_COLLID parameter

defined, B.3.30

errors detected by the server database, 5.1.5

DRDA_PACKAGE_CONSTOKEN parameter, B.3.31

DRDA_PACKAGE_NAME parameter

defined, B.3.32

errors detected by the server database, 5.1.5

DRDA_PACKAGE_OWNER parameter, B.3.33

DRDA_PACKAGE_SECTIONS parameter

defined, B.3.34

defining the number of DRDA cursors, 4.10

DRDA_READ_ONLY parameter, 3.6

defined, B.3.35

DRDA_RECOVERY_PASSWORD parameter

defined, B.3.36

DRDA_RECOVERY_USERID parameter

defined, B.3.37

DRDA_REMOTE_DB_NAME parameter, B.3.38

DROP DATABASE LINK statement, 3.1.2

dynamic dictionary mapping, 1.3.4

E

EBCDIC

character set support, C.3.2.1

code page, C.3

DRDA server CCSID, C.7

sort order, 4.6.2

tables, known restrictions, 1.9

translated to ASCII, 4.7.1

EMP

system-wide synonym, 3.4

table, 3.8

empproc

stored procedure, 4.3

environment

heterogeneous, 3.7

variable, NLS_LANG, C.2

environmental variable

NLS_LANG, C.1

ORA_NLS11, C.1

errd

mapped error example, 5.2

errmc

errmc field lists any error tokens, 5.1.3

error tokens, 5.1.5

mapped error example, 5.2

error

array (errd), 5.1.5

basic description, 5.1

change, ORA-09100 to ORA-28500, 5.1.3

change, ORA-09101 to ORA-28501, 5.1.3

codes

drc, 5.1.3

grc, 5.1.3

date, C.3.2.3

detected

by Oracle database, 5.1.1

by server database, 5.1.5

by the gateway, 5.1.2

in DRDA software, 5.1.3

drc= field

-300xx, 5.3

-7xx, 5.3

HGO-00706, 5.1.2

interpreting error messages, 5.1

mapped sqlstate, 5.2

messages

Oracle LONG datatype is too long, 4.7.2

messages & codes, 5

ORA-00001, index constraint violated, 5.2

ORA-00942

mapped error example, 5.2

object name too long, 5.2

ORA-01017, logon denied, 5.2

ORA-01031, insufficient privileges, 5.2

ORA-01460, invalid CCSID, 5.2

ORA-01476, divide by zero, 5.2

ORA-02019, 5.1.1

ORA-2025, when using INSERT command, 3.8

ORA-28500 (was ORA-09100), 5.1.3

ORA-9100 to ORA-9199, 5.1.1

Oracle mapped error codes, 5.2

specific gateway error codes, 5.3

tokens, 5.1.3

translation, 4.7.1

with Native Semantics, 4.6

errp

errp field indicates program that detected error, 5.1.3

mapped error example, 5.2

EXCEPT set operator, SQL Set Clauses, 4.6.3

EXECUTE command, 1.3.9

exits

gateway local date, 4.7.6

EXPLAIN PLAN command, 5.4.1

EXPLAIN_PLAN table, 1.9

F

FDS_CLASS parameter, B.3.39

features of the gateway

application development and end-user tools, 1.9

application portability, 1.9

columns supported in a result set, 1.9

distributed applications supported, 1.9

EXPLAIN_PLAN improvement, 1.9

fetch reblocking, 1.9

heterogeneous database integration, 1.9

heterogeneous services architecture, 1.9

large base of data access, 1.9

main topic, 1.9

minimum impact on existing systems, 1.9

Native Semantics, 1.9

Oracle database passthrough supported, 1.9

Oracle snapshots, 3.7

performance enhancements, 1.9

remote data access, 1.9

retrieving result sets through passthrough, 1.9

support for TCP/IP, 1.9

fetch array size, with HS_FDS_FETCH_ROWS, B.3.11

fetch reblocking

controlled by two Heterogeneous Services initialization parameters, 1.9

supported by Oracle database, 4.1.1

fetched date, B.3.42

fields

errmc, lists any error tokens, 5.1.3

errp, indicates program that detected error, 5.1.3

file member

accessing AS/400 files, 3.3

name, 3.3

files

initsid.ora

communication errors, 5.1.5

gateway error -700, 5.3

VSAM, 4.3.2

FOR BIT DATA

DRDA_DEFAULT_CCSID, B.3.18

option, 4.7.1

functions

COS, 4.5.3.1

COUNT, 4.7.9

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, 4.8

DRDA server, 4.6

SQL

SUBSTR, 4.6

SUBSTR

known restrictions, 2.5.1

TO_DATE

DB2 ISO format, 4.7.6

processing DATE data, 4.7.4.2

twenty-first century dates, 4.7.5

TO_DATE, main topic, 4.7.7

G

gateway

accessing

main topic, 3.2

advantages

main topic, 1.2

migration and coexistence, 1.3.15

multi-site transactions, 1.3.13

security, 1.3.16

server technology and tools, 1.3.11

site autonomy, 1.3.14

two-phase commit, 1.3.13

and Oracle tools, 1.8

and stored procedures (Oracle and non-Oracle), 1.3.9

application tools, 1.9

architecture, 1.5

benefits of integration with Oracle database, 1.3.3

components, 1.6

definition of terms, 1.4

error codes, 5.3

errors detected, 5.1.2

features, main topic, 1.9

how to access, 3.2

interface, 1.7

local date exit, 4.7.6

logging, LOG_DESTINATION, B.3.41

performance enhancements, 1.9

performance versus transparency, 4.6

performing distributed queries, 3.5

read-only option, 3.6

SQL differences, 1.7

supported languages

CCSID, C.1

codepage map facility, C.4

tracing

LOG_DESTINATION, B.3.41

SQL statements, 3.10

using, 3

with other Oracle products, SQL*Plus, 1.3.12

Gateway Initialization File

parameters

DRDA_READ_ONLY, 3.6

LOG_DESTINATION, 5.4.2

ORACLE_DRDA_TCTL, 5.4.2

TRACE_LEVEL, 5.4.2

GLOBAL_NAMES

known restrictions, 2.5.1

Globalization Support

DRDA server character sets

codepage map facility, C.4

parameters needed for Globalization Support processing, C.1

initsid.ora parameters, C.3.2

overview, C

globalization support

Heterogeneous Services, B.3.6

date format, B.3.47

languages in character date values, B.3.48

Globalization Support parameters, configuration on client and Oracle database, C.2

GRAPHIC datatype, 4.7.3

graphic string operations

unsupported, 4.7.3

grc error code, 5.1.3

GROUP BY clause

SQL Set Clauses, 4.6.3

H

HAVING clause

SQL Set Clauses, 4.6.3

heterogeneous database integration, 1.9

Heterogeneous Services

defining maximum number of open cursors, B.3.7

optimizing data transfer, B.3.8

setting global name, B.3.4

specifying cache high water mark, B.3.5

tuning internal data buffering, B.3.9

Heterogeneous Services (HS), see HS, 1.2

HGO-00706 error, 5.1.2

host

performing character string operations on, 4.7.1

relationship to gateway and Oracle database, 1.5

variable, 4.7

HS (Heterogeneous Services)

architecture features, 1.9

HS_CALL_NAME initialization parameter, B.3.1

HS_DB_DOMAIN parameter

known restrictions, 2.5.1

HS_DB_NAME initialization parameter, B.3.4

HS_DESCRIBE_CACHE_HWM initialization parameter, B.3.5

HS_FDS_FETCH_ROWS parameter, B.3.11

HS_FDS_TRACE_LEVEL initialization parameter

enabling agent tracing, B.1

HS_LANGUAGE initialization parameter, B.3.6

HS_NLS_DATE_FORMAT

four date patterns, 4.7.6

Globalization Support parameters for initsid.ora file, C.3.2.3

HS_NLS_DATE_FORMAT initialization parameter, B.3.47

HS_NLS_DATE_LANGUAGE, C.3.2.4

HS_NLS_DATE_LANGUAGE initialization parameter, B.3.48

HS_NLS_NCHAR

defined, B.3.40

parameters in the Gateway Initialization File, C.3.2.2

HS_NLS_NUMERIC_CHARACTER initialization parameter, B.3.49

HS_OPEN_CURSORS initialization parameter, B.3.7

HS_RPC_FETCH_REBLOCKING initialization parameter, B.3.8

HS_RPC_FETCH_REBLOCKING parameter

controlling array blocksize and the block fetch, 1.9

Oracle database support, 4.1.1

HS_RPC_FETCH_SIZE initialization parameter, B.3.9

HS_RPC_FETCH_SIZE parameter

specified in the Gateway Initialization File, 1.9

value determines array size, 4.1.1

I

IFILE initialization parameter, B.3.12

implementation, 1.6

implicit data conversion, 4.6

implicit protocol conversion, 1.3.3

IMS transaction, 4.3.2

IN and OUT columns, multi-byte support, C.5

Initialization parameter file

customizing, B

initsid.ora file

communication errors, 5.1.5

Globalization Support parameters, C.3.2

input bind variables, 4.7.4.2

INSERT

known restrictions, 2.5

operation, 4.1

Oracle SQL command, known restrictions, 2.5

read-only gateway, 3.6

SQL clause, 4.7.7

statement

dates, 4.7.5

passthrough SQL feature, 4.8

INSERT command

known restrictions, 2.5

not supported, 3.8

supported by COPY, 3.8

internal tracing, B.3.45

Internet support, 1.3.3

INTERSECT, SQL set operators and clauses, 4.6.3

ISO standard, 1.3.5

isolation level, DRDA_ISOLATION_LEVEL, B.3.26

J

JOIN capability, 1.3.2

JOIN SQL statement, 4.1

K

known restrictions

accessing DB2 alias objects, 2.5

bind variables become SQL parameter markers, 2.5.2

binding the DRDA gateway package on DB2/UDB, 2.5.1

CONNECT BY not supported, SQL limitations, 2.5.2, 2.5.2

datatype limitations, 2.5.1

date arithmetic, 2.5.1

DD basic tables and views, 2.5.1

DRDA server character sets, 2.5.1

GLOBAL_NAMES parameter, 2.5.1

INSERT (Oracle SQL command), 2.5

LONG datatype in SQL*Plus, 2.5.1

null values and stored procedures, 2.5.1

Oracle ROWID column, 2.5.2

row length limitation, 2.5.1

SAVEPOINT, 2.5.1

single gateway instances per DRDA network interface, 2.5.1

string concatenation, 2.5.1

SUBSTR function post-processed, 2.5.1

L

LANGUAGE parameter, C.3.2.1

languages

access through the gateway, 1.3.10

SQL*Plus, 1.3.12

link, also see Database Link, 4.4

linkage conventions

SIMPLE WITH NULLS, 4.3.2

literal

character literals, 4.7.4.1

date, 4.7.4.2

specific datatype, 4.7

TO_DATE, format support, 4.7.7

LOG_DESTINATION parameter

defined, B.3.41

file name or path name, 5.4.2

SQL tracing, 5.4.2

with ORACLE_DRDA_TRACE, B.3.45

logging, LOG_DESTINATION, B.3.41

LONG datatype, 4.7.2

LONG RAW datatype, 4.7.1, 4.7.1

M

mapped sqlstate errors, 5.2

MINUS

set operator, SQL Set Clauses, 4.6.3

SQL set operators and clauses, 4.6.3

Mobile Agents, 1.3.3

multi-byte support, C.5

N

Native Semantics

gateway architecture, 1.9

parameters, SQL Set Clauses, 4.6.3

with SUBSTR function, known restrictions, 2.5.1

NLS

also see Globalization Support, C

NLS_LANG

environment variable

client-server configuration, C.2

parameters needed for Globalization Support processing, C.1

server-side parameter, C.1

non-character binary data, 4.7.1

null

rows, mapping the COUNT function, 4.7.9

values

mapping the COUNT function, 4.7.9

number of cursors, DRDA_PACKAGE_SECTIONS, B.3.34

numbers

concatenation restrictions, 2.5.1

numeric datatype

zoned decimal column, 4.7.10

O

o2pc.sql

two-phase commit transactions, 3.5.1

open cursors, at the IBM database, 4.10

OPEN_LINKS parameter, 3.1.4

operations

DELETE, 4.1

INSERT, 4.1

SELECT, 4.1

UPDATE, 4.1

operators

UNION ALL, SQL Set Clauses, 4.6.3

UNION, SQL Set Clauses, 4.6.3

option

data dictionary views, 4.9

date format string, 4.7.5

FOR BIT DATA, 4.7.1

Oracle database, 1.5

read-only

gateway configuration, 1.3.13

replicating, 3.7

service port number, DRDA_CONNECT_PARM, B.3.17

SQL functions, 4.6.1

SQL*Plus COPY command, 3.8

ORA_MAX_DATE parameter, B.3.42

ORA_NLS11 parameter, B.3.43

needed in system environment, C.1

ORA-00001 error, index constraint violated, 5.2

ORA-00942 error

mapped error example, 5.2

object name too long, 5.2

ORA-01017 error, logon denied, 5.2

ORA-01031 error, insufficient privileges, 5.2

ORA-01460 error, invalid CCSID, 5.2

ORA-01476 error, divide by zero, 5.2

ORA-02019 error, 5.1.1

ORA1 Oracle instance, 4.2

ORA2 Oracle instance, 4.2

ORA-2025

error when using INSERT command, 3.8

ORA-28500 error

was ORA-09100, 5.1.3

ORA-9100 to ORA-9199 errors, 5.1.1

Oracle

mapped error codes, 5.2

products compatibility, 1.8

RAW datatype, B.3.18

snapshots, 3.7

Oracle database

accessing the gateway, 3.2

architecture, 1.5

copying data

from DRDA server, 3.9

to DRDA server, 3.8

definition, 1.4

errors detected, 5.1.1

relationship to host, 1.5

services

database triggers, 1.3.2

distributed capabilities, 1.3.2

distributed query optimization, 1.3.2

extended database services, 1.3.2

SQL, 1.3.2

stored procedures, 1.3.2

two-phase commit protection, 1.3.2

stored procedure, defined, 4.2

triggers, 3.7

using, in application development, 4.1

Oracle Net

and application development, 1.9

and remote data access, 1.9

and server coexistence, 1.5

integrated with Oracle database, 1.3.11

purpose, 1.6

TNS connect descriptor specification, 3.1.1

Oracle ROWID column

known restrictions, 2.5.2

ORACLE_DRDA_TCTL parameter

defined, B.3.44

SQL tracing in the gateway, 5.4.2

ORACLE_DRDA_TRACE parameter, defined, B.3.45

ORACLE2PC table

distributed DRDA transactions, 3.5.2

DRDA_PACKAGE_OWNER, B.3.33

ORADRDA.ORACLE2PC table, 3.5.1

oraproc1, stored procedure, 4.2

oraproc2, stored procedure, 4.2

ORARECOV user ID

DRDA_RECOVERY_USERID, B.3.37

ORDER BY clause

SQL Set Clauses, 4.6.3

P

package

collection id, DRDA_PACKAGE_COLLID, B.3.30

consistency token, DRDA_PACKAGE_CONSTOKEN, B.3.31

packed decimal, 4.7.10

parameter

diagnostic, B.3.44

Native Semantics, SQL Set Clauses, 4.6.3

setting up trace parameters, 5.4

parameters

DB_DOMAIN

known restrictions, 2.5.1

DRDA_CODEPAGE_MAP

defined, B.3.15

mapping IBM CCSID, C.4

DRDA_DESCRIBE_TABLE

known restrictions, 2.5

DRDA_PACKAGE_SECTIONS, 4.10

DRDA_READ_ONLY, 3.6

FDS_CLASS, B.3.39

Gateway Initialization File

DRDA_CONNECT_PARM, 5.1.4

DRDA_OPTIMIZE_QUERY, 3.5

DRDA_PACKAGE_COLLID, 5.1.5

DRDA_PACKAGE_NAME, 5.1.5

gateway initialization file

DRDA_CACHE_TABLE_DESC, B.3.13

DRDA_CAPABILITY, B.3.14

DRDA_CODEPAGE_MAP, B.3.15

DRDA_COMM_BUFLEN, B.3.16

DRDA_CONNECT_PARM (TCP/IP format), B.3.17

DRDA_DEFAULT_CCSID, B.3.18

DRDA_DESCRIBE_TABLE, B.3.19

DRDA_DISABLE_CALL, B.3.20

DRDA_FLUSH_CACHE, B.3.21

DRDA_GRAPHIC_LIT_CHECK, B.3.24

DRDA_GRAPHIC_PAD_SIZE, B.3.23

DRDA_GRAPHIC_TO_MBCS, B.3.25

DRDA_ISOLATION_LEVEL, B.3.26

DRDA_LOCAL_NODE_NAME, B.3.27

DRDA_MBCS_TO_GRAPHIC, B.3.28

DRDA_OPTIMIZE_QUERY, B.3.29

DRDA_PACKAGE_COLLID, B.3.30

DRDA_PACKAGE_CONSTOKEN, B.3.31

DRDA_PACKAGE_NAME, B.3.32

DRDA_PACKAGE_OWNER, B.3.33

DRDA_PACKAGE_SECTIONS, B.3.34

DRDA_READ_ONLY, B.3.35

DRDA_RECOVERY_PASSWORD, B.3.36

DRDA_RECOVERY_USERID, B.3.37

DRDA_REMOTE_DB_NAME, B.3.38

HS_FDS_FETCH_ROWS, B.3.11

HS_NLS_NCHAR, B.3.40

LOG_DESTINATION, B.3.41

ORA_MAX_DATE, B.3.42

ORA_NLS11, B.3.43

ORACLE_DRDA_TCTL, B.3.44

ORACLE_DRDA_TRACE, B.3.45

TRACE_LEVEL, B.3.46

HS_DB_DOMAIN

known restrictions, 2.5.1

HS_NLS_DATE_FORMAT, 4.7.5, 4.7.6

HS_RPC_FETCH_REBLOCKING, 1.9, 4.1.1, 4.1.1

HS_RPC_FETCH_SIZE, 1.9, 4.1.1, 4.1.1

LOG_DESTINATION, B.3.45

LOG_DESTINATON, 5.4.2

OPEN_LINKS, 3.1.4

passthrough

gateway features, 1.9

native DB2 SQL, 1.3.8

send SQL statement directly to DRDA server, 4.8

performance, 4.6

performance enhancements

with fetch reblocking, 4.1.1

PL/SQL

call, 4.3.1

DRDA stored procedures, 4.3

records, 4.3.2

routine, 1.3.9

standard Oracle, 1.3.9

stored procedure, 4.2

post-processed SQL functions

overview, 4.5.3.1

post-processing

native semantics, 4.6

SQL tracing in the gateway, 5.4.1

PREPARE TRANSACTION statement, 3.5.1

privileges

data dictionary emulation, 4.9

procedure

stored

read only gateway, 3.6

using DRDA server, 4.3

processing time, with GROUPBY, HAVING, WHERE, 4.6.2

protocol

commit confirm, 1.3.13

converter, 1.3.3

implicit protocol conversion, 1.3.3

network, 3.4

protocol-independent encryption, 1.3.3

two-phase commit, 3.5.1

protocols

TCP/IP

gateway transparency, 1.3.1

implicit protocol conversion, 1.3.3

Q

queries, distributed, 3.5

R

RAW datatype

caution with DRDA_DEFAULT_CCSID, B.3.18

performing character string operations, 4.7.1

read-only gateway option

improved performance and security, 3.6

set with DRDA_READ_ONLY, B.3.35

read-only support, 1.9

rebind required with any change to

DRDA_DISABLE_CALL, B.3.20

DRDA_ISOLATION_LEVEL, B.3.26

DRDA_PACKAGE_COLLID, B.3.30

DRDA_PACKAGE_CONSTOKEN, B.3.31

DRDA_PACKAGE_NAME, B.3.32

DRDA_PACKAGE_OWNER, B.3.33

DRDA_PACKAGE_SECTIONS, B.3.34

remote

connections, 3.1.4

data, 1.3.2

data access, 1.9

database

copying data, 3.8

creating database links, 3.1.1

defining a path, 3.1.1

DRDA_PACKAGE_SECTIONS, B.3.34

errors detected by the Oracle database, 5.1.1

gateway error code 30061, 5.3

DB2 system, 2.5

DRDA database, DRDA_ISOLATION_LEVEL, B.3.26

instance, and Oracle stored procedures, 4.2

Oracle instance

using DRDA server stored procedures with the gateway, 4.3

using Oracle stored procedures with the gateway, 4.2

procedure, 1.3.9

table, 1.3.4

userid and password, 3.1.1

remote functions

referenced in SQL statements, B.3.1

REPLACE command, supported by COPY, 3.8

replication, 3.7

RESULT, 4.3.1

result sets

columns in, 1.9

retrieving result sets through passthrough, 1.9

REVISE_SALARY

stored procedure, 4.3.1

ROWID

Oracle column

known restrictions, 2.5.2

S

SAVEPOINT

known restrictions, 2.5.1

security

Advanced Security, 1.3.3

site autonomy, 1.3.14

SELECT and array size, 1.9

SELECT operation, 4.1

SELECT statement

fetch reblocking, 4.1.1

read-only gateway, 3.6

retrieving results sets, 4.8.3

SELECT WHERE

SQL clause, 4.7.7

semantics, 4.6

server database error, 5.1.5

service port number, DRDA_CONNECT_PARM, B.3.17

session

connection, 4.4

set operators

compatibility, SQL Set Clauses, 4.6.3

EXCEPT, SQL Set Clauses, 4.6.3

INTERSECT, SQL Set Clauses, 4.6.3

MINUS, SQL Set Clauses, 4.6.3

shift attribute, multi-byte support, C.5

side information profile

communication errors, 5.1.4

SIMPLE linkage convention

gateway support, 4.3.2

site autonomy, 1.3.14

snapshots

known restrictions, SQL limitations, 2.5.2

Oracle Snapshot feature, 3.7

sort order

with ORDERBY, 4.6.2

SQL

ANSI standard, 1.3.5

clause compatibility, 4.6.3

clauses

DELETE, 4.7.7

INSERT, 4.7.7

SELECT WHERE, 4.7.7

UPDATE, 4.7.7

constructs

Oracle processing, 4.5

differences in the gateway, 1.7

errors mapped to Oracle error codes, 5.2

functions

SUBSTR, 4.6

functions and Native Semantics, 4.6

gateway architecture, 1.2

gateway transparency, 1.3.5

ISO standard, 1.3.5

native DB2, 1.3.8

passthrough, 4.8, 4.8.2, 4.8.3, 4.8.3.1

statements, 4.1

DB2, 4.8.2

issued through the gateway, 3.10

passing through gateway, 4.8

statements, DRDA_ISOLATION_LEVEL, B.3.26

syntax, 4.7.9

tracing, not to be used in production environment, 3.10

SQL functions

column functions, 4.5.1

compatible, defined, 4.5.1

compensated, defined, 4.5.3

DB2/400, 4.5.7

DB2/OS390, 4.5.5

DB2/UDB, 4.5.6

post-processing, defined, 4.5.3.1

that can be disabled, 4.6.2

that can be enabled, 4.6.1

translated, defined, 4.5.2

with Native Semantics, 4.6.1

SQL tracing

in Oracle database, 5.4.1

in the gateway, 5.4.2

LOG_DESTINATION, 5.4.2

ORACLE_DRDA_TCTL parameter, 5.4.2

TRACE_LEVEL parameter, 5.4.2

SQL*Plus

COPY command, 3.8

extending gateway uses, 1.8.1

moving data, 1.3.12

sqlstate, mapped errors, 5.2

stability, of cursor, DRDA_ISOLATION_LEVEL, B.3.26

statements

CREATE DATABASE LINK, 3.1.1

CREATE DATABASE, client/server configuration, C.2

DB2 CREATE TABLE, 1.3.8

DDL, 4.8, 4.8.2

DELETE, 4.7.5, 4.8

DROP DATABASE LINK, 3.1.2

INSERT, 4.8

PREPARE TRANSACTION, 3.5.1

SELECT, 4.1.1, 4.1.1, 4.8.3

read-only gateway, 3.6

SQL

DB2, 4.8.2

JOIN, 4.1

SELECT, 4.8.3

UPDATE, 4.7.5, 4.8

stored procedure

creating on DB2, 4.3.1

DB2, 4.3.2

native DB2, 1.3.9

Oracle and non-Oracle, 1.3.9

Oracle database

local instance, 4.2

PL/SQL, 4.2

remote instance, 4.2

using, 4.2

Oracle, description, 1.3.9

restriction, 2.5.1

usage, B.3.20

using DRDA server, 4.3

stored procedures, 1.3.2

DB2, 3.6, 4.3

REVISE_SALARY, 4.3.1

using with the gateway, 4.2

string concatenation

known restrictions, 2.5.1

string index, with Native Semantics, 4.6

Structured Query Language, also see SQL, 1.2

SUBSTR SQL function, 4.6

known restrictions, 2.5.1

with Native Semantics, known restrictions, 2.5.1

synonym

feature, 3.4

for location transparency, 4.2

how the gateway works, 1.7

T

table

create a table in DB2, 4.8.2.1

insert a row into a DB2 table, 4.8.2.1

TABLE_PRIVILEGES view, A.2.17

tables

EXPLAIN_PLAN, 1.9

ORACLE2PC, 3.5.2

ORADRDA.ORACLE2PC, 3.5.1

TCP/IP

DRDA_CONNECT_PARM, B.3.17

facilities, 1.9

functions, 1.6

protocol

gateway transparency, 1.3.1

implicit protocol conversion, 1.3.3

support, 1.9

terminology defined, 1.4

TIME datatype, 4.7.4.1

time operations, 4.7.4

TIMESTAMP datatype, 4.7.4.1

tnsnames.ora

connect descriptor, 3.1.1

TO_DATE function, main topic, 4.7.7

token, package consistency, DRDA_PACKAGE_CONSTOKEN, B.3.31

tools and the gateway, 1.8

trace control, B.3.44

trace parameters

setting, 5.4

TRACE_LEVEL parameter

defined, B.3.46

SQL tracing in the gateway, 5.4.2

tracing

code, B.3.46

LOG_DESTINATION, B.3.41

ORACLE_DRDA_TRACE, B.3.45

SQL statements, 3.10

trade-off, Native Semantics, 4.6

transaction mode, read-only, DRDA_READ_ONLY, B.3.35

transactions

CICS, 4.3.2

IMS, 4.3.2

transform

character set transforms with multi-byte support, C.5

not required for DRDA server, C.5

transparency

main topic, gateway transparency, 1.3.1

native semantics, 4.6

triggers for Oracle database, 3.7

two-phase commit

processing transactions, 3.5.1

protection, 1.3.2

unsupported statement, 3.5.1

U

UNION

capability, 1.3.2

operator, SQL Set Clauses, 4.6.3

SQL set operators and clauses, 4.6.3

UNION ALL

operator, SQL Set Clauses, 4.6.3

SQL set operators and clauses, 4.6.3

UPDATE

known restrictions, SQL limitations, 2.5.2

operation, 4.1

read-only gateway, 3.6

SQL clause, 4.7.7

statement, 4.8

user privileges, 4.9

USER_CATALOG view, A.2.18

USER_COL_COMMENTS view, A.2.19

USER_CONS_COLUMNS view, A.2.21

USER_CONSTRAINTS view, A.2.20

USER_DB_LINKS data dictionary view, 3.1.3

USER_INDEXES view, A.2.22

USER_OBJECTS view, A.2.23

USER_SYNONYMS view, A.2.24

USER_TAB_COLUMNS view, A.2.26

USER_TAB_COMMENTS view, A.2.27

USER_TABLES view, A.2.25

USER_USERS view, A.2.28

USER_VIEWS view, A.2.29

USING clause, 3.1.1

Using the gateway, 3

V

VALUES clause

functions not allowed by DB2, 4.7.7

VARCHAR datatype, 4.7.2

variable

bind, SQL passthrough, 4.8

input bind, 4.7.4.2

view

catalog

DB2/400, 4.9.1

DB2/OS390, 4.9.1

DB2/UDB, 4.9.1

data dictionary

emulation on DRDA server, 4.9

VSAM

file, 4.3.2

W

WHERE clause

known restrictions, SQL limitations, 2.5.2

SQL Set Clauses, 4.6.3

WHERE CURRENT OF CURSOR clause

known restrictions, SQL limitations, 2.5.2

wireless communication, 1.3.3

Z

zoned decimal operations, 4.7.10