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

Part Number E12014-02
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
View PDF

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.3
Advanced Security
function of the gateway, 1.3.3
purpose, 1.3.3
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.2.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.2.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.4
library name, HS_FDS_PACKAGE_COLLID, B.3.27
ASCII
sort order, 4.6.2
translated from EBCDIC, 4.7.1
autonomy, site, 1.3.14

B

binary data, non-character, 4.7.1
bind variables
SQL passthrough, 4.8
bug
debugging
drc values in the DRDA software, 5.1.2
setting trace parameters, 5.3
SQL tracing, 3.10
number 205538, known restrictions, SQL limitations, 2.5.2.2

C

call
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.4
capabilities of DRDA server, native semantics, 4.6
changes in this release
IBM DB2/UDB supported, 1.9
read-only support, 1.9
character sets
Heterogeneous Services, B.3.6.1
character string
converting datatypes, 4.7.2
performing operations, 4.7.2
CHECKSUM command
extended advanced networking, 1.3.3
clauses
CONNECT TO, 3.2.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.2.1
VALUES
functions not allowed by DB2, 4.7.7
WHERE
known restrictions, SQL limitations, 2.5.2.2
SQL Set Clauses, 4.6.3
WHERE CURRENT OF CURSOR, known restrictions, SQL limitations, 2.5.2.2
closing and opening again any session against db2 required with any change to
HS_FDS_PACKAGE_COLLID, B.3.27
coercion
of data, 4.6
column
date columns, TO_DATE function, 4.7.7
supported in a result set, 1.9
commands
CHECKSUM, 1.3.3
COPY
known restrictions, 2.5.2.1
Oracle database to DRDA server, 3.8
SQL*Plus command, 3.8
EXECUTE, 1.3.9
EXPLAIN PLAN, 5.3.1
INSERT
known restrictions, 2.5.2.1
not supported, 3.8
commit confirm protocol, 1.3.13
compatible SQL set operators and clauses, 4.6.3
CONNECT TO clause, 3.2.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.2.1
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.2.1
CREATE TABLE statement, 1.3.8
creating
database link, 3.2.1
cursor
stability, HS_FDS_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.2.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.2.3
database
catalogs, 4.9
link
behavior, 4.4
creating, 3.2.1
dropping links, 3.2.2
examining, 3.2.3
guidelines, 3.2.1
limits, 3.2.4
processing, 3.2
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.7
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
TIME, 4.7.4
TIMESTAMP, 4.7.4
VARCHAR, 4.7.2
date
date columns, TO_DATE function, 4.7.7
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.8
DATE datatype, 4.7.4
DB_DOMAIN parameter
known restrictions, 2.5.1.6
DB2
data access, 1.3.9
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 UDB for iSeries
HS_FDS_ISOLATION_LEVEL, B.3.26
HS_FDS_PACKAGE_COLLID, B.3.27
DB2 UDB for Linux, Unix, and Windows
HS_FDS_ISOLATION_LEVEL, B.3.26
DB2 UDB for z/OS
HS_FDS_ISOLATION_LEVEL, B.3.26
DB2/400
catalog view, 4.9.1
data dictionary views supported by gateway, A.1
DB2/OS390
catalog view, 4.9.1
data dictionary views supported by gateway, A.1
V6, V7 and V8 stored procedures supported, 1.9
DB2/UDB
catalog view, 4.9.1
data dictionary views not supported, A.1
supported, 1.9
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function, 4.8
DD basic tables, known restrictions, 2.5.1.1
DDL
statement, 4.8
debug
gateway, 5.3
debugging
error codes, 5.1.2
SQL tracing, 5.3
your application, 3.10
DELETE
known restrictions, SQL limitations, 2.5.2.2
operation, 4.1
SQL clause, 4.7.7
statement, 4.8
DESCRIBE
character string operations, 4.7.1
describe cache high water mark
definition, B.3.5
dictionary
mapping, 1.3.4
tables, 4.9
DICTIONARY view, A.2.15
distributed
applications, support for, 1.9
DRDA transactions, 3.6.2
queries
two-phase commit, 3.6.1
transaction, HS_FDS_RECOVERY_ACCOUNT, B.3.14
drc error code, 5.1.2
DRDA
catalog, 4.9.2
DRDA server
architecture, 1.5
capabilities, native semantics, 4.6
functions, 4.6
stored procedures, 4.3
DRDA server error, 5.1.3
DROP DATABASE LINK statement, 3.2.2
dynamic dictionary mapping, 1.3.4

E

EBCDIC
sort order, 4.6.2
translated to ASCII, 4.7.1
EMP
system-wide synonym, 3.5
table, 3.8
empproc
stored procedure, 4.3
environment
heterogeneous, 3.7
errmc
errmc field lists any error tokens, 5.1.2
error
basic description, 5.1
change, ORA-09100 to ORA-28500, 5.1.2
change, ORA-09101 to ORA-28501, 5.1.2
codes
drc, 5.1.2
grc, 5.1.2
detected
by Oracle database, 5.1.1
by server database, 5.1.3
in DRDA software, 5.1.2
interpreting error messages, 5.1
messages
Oracle LONG datatype is too long, 4.7.2
messages & codes, 5
ORA-02019, 5.1.1
ORA-2025, when using INSERT command, 3.8
ORA-28500 (was ORA-09100), 5.1.2
ORA-9100 to ORA-9199, 5.1.1
Oracle mapped error codes, 5.2
tokens, 5.1.2
translation, 4.7.1
with Native Semantics, 4.6
Error messages
error tracing, B.3.18
errp
errp field indicates program that detected error, 5.1.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.3.1
EXPLAIN_PLAN table, 1.9

F

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
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.17
fetch reblocking
controlled by two Heterogeneous Services initialization parameters, 1.9
supported by Oracle database, 4.1.1
fields
errmc, lists any error tokens, 5.1.2
errp, indicates program that detected error, 5.1.2
file member
accessing AS/400 files, 3.4
name, 3.4
FOR BIT DATA
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.2
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.3
advantages
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
features, main topic, 1.9
how to access, 3.3
interface, 1.7
local date exit, 4.7.6
performance enhancements, 1.9
performance versus transparency, 4.6
performing distributed queries, 3.6
SQL differences, 1.7
tracing
SQL statements, 3.10
using, 3
with other Oracle products, SQL*Plus, 1.3.12
GENERAL and DB2SQL linkage convention
gateway support, 4.3.2
GLOBAL_NAMES
known restrictions, 2.5.1.6
globalization support
Heterogeneous Services, B.3.6
GRAPHIC datatype, 4.7.3
graphic string operations
unsupported, 4.7.3
grc error code, 5.1.2
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.8
optimizing data transfer, B.3.9
setting global name, B.3.4
specifying cache high water mark, B.3.5
tuning internal data buffering, B.3.10
tuning LONG data transfer, B.3.7
Heterogeneous Services (HS), see HS, 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.6
HS_DB_NAME initialization parameter, B.3.4
HS_DESCRIBE_CACHE_HWM initialization parameter, B.3.5
HS_FDS_CONNECT_INFO, B.3.13
HS_FDS_DEFAULT_OWNER initialization parameter, B.3.16
HS_FDS_FETCH_ROWS parameter, B.3.17
HS_FDS_ISOLATION_LEVEL parameter, B.3.26
HS_FDS_PACKAGE_COLLID parameter
defined, B.3.27
HS_FDS_TRACE_LEVEL initialization parameter, B.3.18
enabling agent tracing, B.1
HS_FDS_TRANSACTION_LOG initialization parameter, B.3.19
HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter, B.3.29
HS_LANGUAGE initialization parameter, B.3.6
HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, B.3.7
HS_NLS_DATE_FORMAT
four date patterns, 4.7.6
HS_OPEN_CURSORS initialization parameter, B.3.8
HS_RPC_FETCH_REBLOCKING initialization parameter, B.3.9
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.10
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
Initialization parameter file
customizing, B
input bind variables, 4.7.4.2
INSERT
operation, 4.1
Oracle SQL command, known restrictions, 2.5.2.1
SQL clause, 4.7.7
statement
passthrough SQL feature, 4.8
INSERT command
known restrictions, 2.5.2.1
not supported, 3.8
supported by COPY, 3.8
Internet support, 1.3.3
INTERSECT, SQL set operators and clauses, 4.6.3
ISO standard, 1.3.5
isolation level, HS_FDS_ISOLATION_LEVEL, B.3.26

J

JOIN capability, 1.3.2
JOIN SQL statement, 4.1

K

known restrictions
datatype limitations, 2.5.1.3
date arithmetic, 2.5.1.8
DD basic tables and views, 2.5.1.1
GLOBAL_NAMES parameter, 2.5.1.6
LONG datatype in SQL*Plus, 2.5.1.10
null values and stored procedures, 2.5.1.4
row length limitation, 2.5.1.9
SUBSTR function post-processed, 2.5.1.2

L

languages
access through the gateway, 1.3.10
SQL*Plus, 1.3.12
link, also see Database Link, 4.4
literal
character literals, 4.7.4.1
date, 4.7.4.2
specific datatype, 4.7
TO_DATE, format support, 4.7.7
LONG datatype, 4.7.2
LONG RAW datatype, 4.7.1, 4.7.1

M

MINUS
set operator, SQL Set Clauses, 4.6.3
SQL set operators and clauses, 4.6.3
Mobile Agents, 1.3.3

N

Native Semantics
gateway architecture, 1.9
parameters, SQL Set Clauses, 4.6.3
with SUBSTR function, known restrictions, 2.5.1.2
non-character binary data, 4.7.1
null
rows, mapping the COUNT function, 4.7.9
values
mapping the COUNT function, 4.7.9
numeric datatype
zoned decimal column, 4.7.10

O

o2pc.sql
two-phase commit transactions, 3.6.1
OPEN_LINKS parameter, 3.2.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
SQL functions, 4.6.1
SQL*Plus COPY command, 3.8
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.2
ORA-9100 to ORA-9199 errors, 5.1.1
Oracle
mapped error codes, 5.2
products compatibility, 1.8
snapshots, 3.7
Oracle database
accessing the gateway, 3.3
architecture, 1.5
copying data
from DRDA server, 3.9
to DRDA server, 3.8
definition, 1.4
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
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.2.1
oraproc1, stored procedure, 4.2
oraproc2, stored procedure, 4.2
ORARECOV user ID
HS_FDS_RECOVERY_ACCOUNT, B.3.14
ORDER BY clause
SQL Set Clauses, 4.6.3

P

package
collection id, HS_FDS_PACKAGE_COLLID, B.3.27
packed decimal, 4.7.10
parameter
Native Semantics, SQL Set Clauses, 4.6.3
setting up trace parameters, 5.3
parameters
DB_DOMAIN
known restrictions, 2.5.1.6
gateway initialization file
HS_FDS_CAPABILITY, B.3.25
HS_FDS_FETCH_ROWS, B.3.17
HS_FDS_ISOLATION_LEVEL, B.3.26
HS_FDS_PACKAGE_COLLID, B.3.27
HS_DB_DOMAIN
known restrictions, 2.5.1.6
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
OPEN_LINKS, 3.2.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.3.1
PREPARE TRANSACTION statement, 3.6.1
privileges
data dictionary emulation, 4.9
procedure
stored
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.5
protocol-independent encryption, 1.3.3
two-phase commit, 3.6.1
protocols
TCP/IP
gateway transparency, 1.3.1
implicit protocol conversion, 1.3.3

Q

queries, distributed, 3.6

R

RAW datatype
performing character string operations, 4.7.1
read-only support, 1.9
remote
connections, 3.2.4
data, 1.3.2
data access, 1.9
database
copying data, 3.8
creating database links, 3.2.1
defining a path, 3.2.1
errors detected by the Oracle database, 5.1.1
DRDA database, HS_FDS_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
user ID and password, 3.2.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

S

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
retrieving results sets, 4.8.3
SELECT WHERE
SQL clause, 4.7.7
semantics, 4.6
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
site autonomy, 1.3.14
snapshots
known restrictions, SQL limitations, 2.5.2.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 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, HS_FDS_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.3.1
SQL*Plus
COPY command, 3.8
extending gateway uses, 1.8.1
moving data, 1.3.12
stability, of cursor, HS_FDS_ISOLATION_LEVEL, B.3.26
statements
CREATE DATABASE LINK, 3.2.1
DB2 CREATE TABLE, 1.3.8
DDL, 4.8, 4.8.2
DELETE, 4.7.5, 4.8
DROP DATABASE LINK, 3.2.2
INSERT, 4.8
PREPARE TRANSACTION, 3.6.1
SELECT, 4.1.1, 4.1.1, 4.8.3
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.4
using DRDA server, 4.3
stored procedures, 1.3.2
DB2, 4.3
REVISE_SALARY, 4.3.1
using with the gateway, 4.2
string index, with Native Semantics, 4.6
SUBSTR SQL function, 4.6
known restrictions, 2.5.1.2
with Native Semantics, known restrictions, 2.5.1.2
synonym
feature, 3.5
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
TCP/IP
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.2.1
TO_DATE function, main topic, 4.7.7
tools and the gateway, 1.8
trace parameters
setting, 5.3
tracing
SQL statements, 3.10
trade-off, Native Semantics, 4.6
transparency
main topic, gateway transparency, 1.3.1
native semantics, 4.6
triggers for Oracle database, 3.7
two-phase commit
processing transactions, 3.6.1
protection, 1.3.2
unsupported statement, 3.6.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.2
operation, 4.1
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.2.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.2.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

W

WHERE clause
known restrictions, SQL limitations, 2.5.2.2
SQL Set Clauses, 4.6.3
WHERE CURRENT OF CURSOR clause
known restrictions, SQL limitations, 2.5.2.2
wireless communication, 1.3.3

Z

zoned decimal operations, 4.7.10