Skip Headers
Oracle® Database Gateway for DRDA User's Guide
11g Release 1 (11.1)

B31046-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
PDF · Mobi · ePub

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