Index

A

accessing
- gateway
  - main topic 1
Advanced Security
- function of the gateway 1
- purpose 1
ALL_CATALOG view 1
ALL_COL_COMMENTS view 1
ALL_CON_COLUMNS view 1
ALL_CONSTRAINTS view 1
ALL_DB_LINKS data dictionary view 1
ALL_INDEXES view 1
ALL_OBJECTS view 1
ALL_SYNONYMS view 1
ALL_TAB_COMMENTS view 1
ALL_TABLES view 1
ALL_USERS view 1
ALL_VIEWS view 1
ALTER SESSION statement 1
ANSI-standard SQL 1, 2
APPEND command
- supported by COPY 1
application
- portability 1
- server support 1
application development on the gateway 1
architecture of the gateway 1
array size
- fetch reblocking 1
- how determined 1
AS/400
- files and file members, accessing 1
- library name, HS_FDS_PACKAGE_COLLID 1
ASCII
- sort order 1
- translated from EBCDIC 1
autonomy, site 1

B

binary data, non-character 1
bind variables
- SQL passthrough 1
bug
- debugging
  - drc values in the DRDA software 1
  - setting trace parameters 1
  - SQL tracing 1
- number 205538, known restrictions, SQL limitations 1

C

call
- DB2 stored procedure 1, 2
- empproc stored procedure 1
- Oracle Call Interfaces 1
- PL/SQL 1
- stored procedure
  - creating a synonym to maintain location transparency 1
  - using standard Oracle PL/SQL 1
- to stored procedure
  - known restrictions 1
capabilities of DRDA server, native semantics 1
changes in this release
- IBM DB2/UDB supported 1
- read-only support 1
character sets
- Heterogeneous Services 1
character string
- converting datatypes 1
- performing operations 1
CHECKSUM command
- extended advanced networking 1
clauses
- CONNECT TO 1
- GROUP BY, SQL Set Clauses 1
- HAVING, SQL Set Clauses 1
- ORDER BY, SQL Set Clauses 1
- SQL
  - DELETE 1
  - INSERT 1
  - SELECT WHERE 1
  - UPDATE 1
- USING 1
- VALUES
  - functions not allowed by DB2 1
- WHERE
  - known restrictions, SQL limitations 1
  - SQL Set Clauses 1
  - WHERE CURRENT OF CURSOR, known restrictions, SQL limitations 1
closing and opening again any session against db2 required with any change to
- HS_FDS_PACKAGE_COLLID 1
coercion
- of data 1
column
- date columns, TO_DATE function 1
- supported in a result set 1
commands
- CHECKSUM 1
- COPY
  - Oracle database to DRDA server 1
  - SQL*Plus command 1
- EXECUTE 1
- EXPLAIN PLAN 1
commit confirm protocol 1
compatible SQL set operators and clauses 1
CONNECT TO clause 1
convert
- character string 1
- datatypes
  - DRDA to Oracle datatypes 1
- DATE 1
- floating point to integer 1
- into most suitable datatype 1
- SQL 1
- to the numeric datatype 1
converter, protocol 1
COPY command
- Oracle database to DRDA server 1
copying data
- from the DRDA server 1
- from the Oracle database to DRDA server 1
COPY SQL*Plus command 1
COS SQL function 1
COUNT function 1
CREATE command
- supported by COPY 1
CREATE DATABASE LINK command 1
CREATE TABLE statement 1
creating
- database link 1

D

database
- catalogs 1
- link
  - behavior 1
  - creating 1
  - dropping links 1
  - examining 1
  - guidelines 1
  - limits 1
  - processing 1
  - suffix 1
  - to identify the gateway 1
- triggers 1
data coercion 1
data control language (DCL) 1
DATA datatype 1
data definition language (DDL) 1
data dictionary
- using 1
- views
  - ALL_DB_LINKS 1
  - emulation on DRDA server 1
  - for DB2/UDB not supported 1
  - supported for DB2/OS390 and DB2/400 servers 1
  - USER_DB_LINKS 1
datatype
- character string 1
- column (ALL_TAB_COLUMNS) 1
- column (USER_TAB_COLUMNS) 1
- conversion
  - DRDA to Oracle datatypes 1
  - no control over 1
- converting character string 1, 2
- data and time 1
- differences between Oracle database and DRDA databases 1
- DRDA server datatypes list 1
- mapping 1
- numeric 1
- operations, numeric 1
- Oracle datatypes RAW and LONG RAW 1
- restrictions 1
- size and value limitations 1
datatypes
- DATE 1
- GRAPHIC 1
- LONG RAW 1
- Oracle and IBM DATE 1
- Oracle DATE 1
- RAW
  - character string operations 1
- TIME 1
- TIMESTAMP 1
date
- date columns, TO_DATE function 1
- HS_NLS_DATE_FORMAT parameter 1, 2
- INSERT
  - statement 1
- operations 1
- SELECT statement 1
- TO_DATE function 1
- UPDATE
  - statement 1
date arithmetic
- known restrictions 1
DATE datatype 1
DB_DOMAIN parameter
- known restrictions 1
DB2
- data access 1
- native SQL 1
- native stored procedures 1
- procedural feature considerations 1
- SQL statements 1
- statements
  - CREATE TABLE 1
- stored procedures 1
DB2/400
- catalog view 1
- data dictionary views supported by gateway 1
DB2/OS390
- catalog view 1
- data dictionary views supported by gateway 1
- V6, V7 and V8 stored procedures supported 1
DB2/UDB
- catalog view 1
- data dictionary views not supported 1
- supported 1
DB2 UDB for iSeries
- HS_FDS_PACKAGE_COLLID 1
DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function 1
DD basic tables, known restrictions 1
DDL
- statement 1
debug
- gateway 1
debugging
- error codes 1
- SQL tracing 1
- your application 1
DELETE
- known restrictions, SQL limitations 1
- operation 1
- SQL clause 1
- statement 1
DESCRIBE
- character string operations 1
describe cache high water mark
- definition 1
dictionary
- mapping 1
- tables 1
DICTIONARY view 1
distributed
- applications, support for 1
- DRDA transactions 1
- queries
  - two-phase commit 1
- transaction, HS_FDS_RECOVERY_ACCOUNT 1
DRDA
- catalog 1
DRDA server
- architecture 1
- capabilities, native semantics 1
- functions 1
- stored procedures 1
DRDA server error 1
DROP DATABASE LINK statement 1
dynamic dictionary mapping 1

E

EBCDIC
- sort order 1
- translated to ASCII 1
EMP
- system-wide synonym 1
environment
- heterogeneous 1
errmc
- errmc field lists any error tokens 1
error
- basic description 1
- detected
  - by Oracle database 1
  - by server database 1
  - in DRDA software 1
- interpreting error messages 1
- messages
  - Oracle LONG datatype is too long 1
- messages ((amp)) codes 1
- ORA-02019 1
- ORA-28500 (was ORA-09100) 1
- Oracle mapped error codes 1
- tokens 1
- translation 1
- with Native Semantics 1
Error messages
- error tracing 1
EXCEPT set operator, SQL Set Clauses 1
EXECUTE command 1
exits
- gateway local date 1
EXPLAIN PLAN command 1

F

features of the gateway
- application development and end-user tools 1
- application portability 1
- columns supported in a result set 1
- distributed applications supported 1
- EXPLAIN_PLAN improvement 1
- fetch reblocking 1
- heterogeneous database integration 1
- heterogeneous services architecture 1
- main topic 1
- minimum impact on existing systems 1
- Native Semantics 1
- Oracle database passthrough supported 1
- Oracle snapshots 1
- performance enhancements 1
- remote data access 1
- retrieving result sets through passthrough 1
- support for TCP/IP 1
fetch array size, with HS_FDS_FETCH_ROWS 1
fetch reblocking
- controlled by two Heterogeneous Services initialization parameters 1
- supported by Oracle database 1
fields
- errmc, lists any error tokens 1
file member
- accessing AS/400 files 1
- name 1
FOR BIT DATA
- option 1
functions
- COS 1
- COUNT 1
- DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE 1
- DRDA server 1
- SQL
  - SUBSTR 1
- SUBSTR
  - known restrictions 1
- TO_DATE
  - DB2 ISO format 1
  - processing DATE data 1
  - twenty-first century dates 1
- TO_DATE, main topic 1

G

gateway
- accessing
  - main topic 1
- advantages
  - migration and coexistence 1
  - multi-site transactions 1
  - security 1
  - server technology and tools 1
  - site autonomy 1
  - two-phase commit 1
- and Oracle tools 1
- and stored procedures (Oracle and non-Oracle) 1
- application tools 1
- architecture 1
- benefits of integration with Oracle database 1
- components 1
- definition of terms 1
- features, main topic 1
- how to access 1
- interface 1
- local date exit 1
- performance enhancements 1
- performance versus transparency 1
- performing distributed queries 1
- SQL differences 1
- tracing
  - SQL statements 1
- using 1
- with other Oracle products, SQL*Plus 1
GENERAL and DB2SQL linkage convention
- gateway support 1
GLOBAL_NAMES
- known restrictions 1
globalization support
- Heterogeneous Services 1
GRAPHIC datatype 1
graphic string operations
- unsupported 1
GROUP BY clause
- SQL Set Clauses 1

H

HAVING clause
- SQL Set Clauses 1
heterogeneous database integration 1
Heterogeneous Services
- defining maximum number of open cursors 1
- optimizing data transfer 1
- setting global name 1
- specifying cache high water mark 1
- tuning internal data buffering 1
- tuning LONG data transfer 1
Heterogeneous Services (HS), see HS 1
host
- performing character string operations on 1
- relationship to gateway and Oracle database 1
- variable 1
HS_CALL_NAME initialization parameter 1
HS_DB_DOMAIN parameter
- known restrictions 1
HS_DB_NAME initialization parameter 1
HS_DESCRIBE_CACHE_HWM initialization parameter 1
HS_FDS_CONNECT_INFO 1
HS_FDS_FETCH_ROWS parameter 1
HS_FDS_PACKAGE_COLLID parameter
- defined 1
HS_FDS_TRACE_LEVEL initialization parameter 1
- enabling agent tracing 1
HS_FDS_TRANSACTION_ISOLATIONparameter 1
HS_FDS_TRANSACTION_LOG initialization parameter 1
HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter 1
HS_LANGUAGE initialization parameter 1
HS_LONG_PIECE_TRANSFER_SIZE initialization parameter 1
HS_NLS_DATE_FORMAT
- four date patterns 1
HS_OPEN_CURSORS initialization parameter 1
HS_RPC_FETCH_REBLOCKING initialization parameter 1
HS_RPC_FETCH_REBLOCKING parameter
- Oracle database support 1
HS_RPC_FETCH_SIZE initialization parameter 1
HS_RPC_FETCH_SIZE parameter
- specified in the Gateway Initialization File 1
- value determines array size 1
HS (Heterogeneous Services)
- architecture features 1

I

IFILE initialization parameter 1
implementation 1
implicit data conversion 1
implicit protocol conversion 1
Initialization parameter file
- customizing 1
input bind variables 1
INSERT
- operation 1
- SQL clause 1
- statement
  - passthrough SQL feature 1
INSERT command
- supported by COPY 1
Internet support 1
INTERSECT, SQL set operators and clauses 1
isolation level, HS_FDS_TRANSACTION_ISOLATION 1
ISO standard 1

J

JOIN capability 1
JOIN SQL statement 1

K

known restrictions
- datatype limitations 1
- date arithmetic 1
- DD basic tables and views 1
- GLOBAL_NAMES parameter 1
- LONG datatype in SQL*Plus 1
- null values and stored procedures 1
- row length limitation 1
- SUBSTR function post-processed 1

L

languages
- access through the gateway 1
- SQL*Plus 1
link, also see Database Link 1
literal
- character literals 1
- date 1
- specific datatype 1
LONG RAW datatype 1

M

MINUS
- set operator, SQL Set Clauses 1
- SQL set operators and clauses 1
Mobile Agents 1

N

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

O

o2pc.sql
- two-phase commit transactions 1
OPEN_LINKS parameter 1
operations
- DELETE 1
- INSERT 1
- SELECT 1
- UPDATE 1
operators
- UNION, SQL Set Clauses 1
- UNION ALL, SQL Set Clauses 1
option
- data dictionary views 1
- date format string 1
- FOR BIT DATA 1
- Oracle database 1
- read-only
  - gateway configuration 1
- replicating 1
- SQL*Plus COPY command 1
- SQL functions 1
ORA-02019 error 1
ORA1 Oracle instance 1
ORA-28500 error
- was ORA-09100 1
Oracle
- mapped error codes 1
- products compatibility 1
- snapshots 1
Oracle database
- accessing the gateway 1
- architecture 1
- copying data
  - from DRDA server 1
  - to DRDA server 1
- definition 1
- relationship to host 1
- services
  - database triggers 1
  - distributed capabilities 1
  - distributed query optimization 1
  - extended database services 1
  - stored procedures 1
  - two-phase commit protection 1
- stored procedure, defined 1
- triggers 1
- using, in application development 1
Oracle Net
- and application development 1
- and remote data access 1
- and server coexistence 1
- integrated with Oracle database 1
- purpose 1
- TNS connect descriptor specification 1
ORARECOV user ID
- HS_FDS_RECOVERY_ACCOUNT 1
ORDER BY clause
- SQL Set Clauses 1

P

package
- collection id, HS_FDS_PACKAGE_COLLID 1
packed decimal 1
parameter
- Native Semantics, SQL Set Clauses 1
- setting up trace parameters 1
parameters
- DB_DOMAIN
  - known restrictions 1
- gateway initialization file
  - HS_FDS_CAPABILITY 1
  - HS_FDS_FETCH_ROWS 1
  - HS_FDS_PACKAGE_COLLID 1
  - HS_FDS_TRANSACTION_ISOLATION 1
- HS_DB_DOMAIN
  - known restrictions 1
- HS_NLS_DATE_FORMAT 1, 2
- HS_RPC_FETCH_REBLOCKING 1
- HS_RPC_FETCH_SIZE 1, 2
- OPEN_LINKS 1
passthrough
- gateway features 1
- native DB2 SQL 1
- send SQL statement directly to DRDA server 1
performance 1
performance enhancements
- with fetch reblocking 1
PL/SQL
- call 1
- DRDA stored procedures 1
- records 1
- routine 1
- standard Oracle 1
- stored procedure 1
post-processed SQL functions
- overview 1
post-processing
- native semantics 1
- SQL tracing in the gateway 1
PREPARE TRANSACTION statement 1
privileges
- data dictionary emulation 1
procedure
- stored
  - using DRDA server 1
processing time, with GROUPBY, HAVING, WHERE 1
protocol
- commit confirm 1
- converter 1
- implicit protocol conversion 1
- network 1
- protocol-independent encryption 1
- two-phase commit 1
protocols
- TCP/IP
  - gateway transparency 1
  - implicit protocol conversion 1

Q

queries, distributed 1

R

RAW datatype
- performing character string operations 1
read-only support 1
remote
- connections 1
- data 1
- data access 1
- database
  - creating database links 1
  - defining a path 1
  - errors detected by the Oracle database 1
- DRDA database, HS_FDS_TRANSACTION_ISOLATION 1
- instance, and Oracle stored procedures 1
- Oracle instance
  - using DRDA server stored procedures with the gateway 1
  - using Oracle stored procedures with the gateway 1
- procedure 1
- table 1
- user ID and password 1
remote functions
- referenced in SQL statements 1
REPLACE command, supported by COPY 1
replication 1
RESULT 1
result sets
- columns in 1
- retrieving result sets through passthrough 1
REVISE_SALARY
- stored procedure 1

S

security
- Advanced Security 1
- site autonomy 1
SELECT and array size 1
SELECT operation 1
SELECT statement
- fetch reblocking 1
- retrieving results sets 1
SELECT WHERE
- SQL clause 1
semantics 1
session
- connection 1
set operators
- compatibility, SQL Set Clauses 1
- EXCEPT, SQL Set Clauses 1
- INTERSECT, SQL Set Clauses 1
- MINUS, SQL Set Clauses 1
site autonomy 1
snapshots
- known restrictions, SQL limitations 1
- Oracle Snapshot feature 1
sort order
- with ORDERBY 1
SQL
- ANSI standard 1
- clause compatibility 1
- clauses
  - DELETE 1
  - INSERT 1
  - SELECT WHERE 1
  - UPDATE 1
- constructs
  - Oracle processing 1
- differences in the gateway 1
- errors mapped to Oracle error codes 1
- functions
  - SUBSTR 1
- functions and Native Semantics 1
- gateway transparency 1
- ISO standard 1
- native DB2 1
- passthrough 1, 2, 3, 4
- statements 1
  - DB2 1
  - issued through the gateway 1
  - passing through gateway 1
- statements, HS_FDS_TRANSACTION_ISOLATION 1
- syntax 1
- tracing, not to be used in production environment 1
SQL*Plus
- COPY command 1
- moving data 1
SQL functions
- column functions 1
- compatible, defined 1
- compensated, defined 1
- DB2/400 1
- DB2/OS390 1
- DB2/UDB 1
- post-processing, defined 1
- that can be disabled 1
- that can be enabled 1
- translated, defined 1
- with Native Semantics 1
SQL tracing
- in Oracle database 1
statements
- CREATE DATABASE LINK 1
- DB2 CREATE TABLE 1
- DDL 1, 2
- DELETE 1, 2
- DROP DATABASE LINK 1
- INSERT 1
- PREPARE TRANSACTION 1
- SELECT 1, 3
- SQL
  - DB2 1
  - JOIN 1
  - SELECT 1
- UPDATE 1, 2
stored procedure
- creating on DB2 1
- DB2 1
- native DB2 1
- Oracle, description 1
- Oracle and non-Oracle 1
- Oracle database
  - local instance 1
  - PL/SQL 1
  - remote instance 1
  - using 1
- restriction 1
- using DRDA server 1
stored procedures 1
- DB2 1
- REVISE_SALARY 1
- using with the gateway 1
string index, with Native Semantics 1
SUBSTR SQL function 1
- known restrictions 1
- with Native Semantics, known restrictions 1
synonym
- feature 1
- for location transparency 1
- how the gateway works 1

T

table
- create a table in DB2 1
- insert a row into a DB2 table 1
TABLE_PRIVILEGES view 1
TCP/IP
- facilities 1
- functions 1
- protocol
  - gateway transparency 1
  - implicit protocol conversion 1
- support 1
terminology defined 1
TIME datatype 1
time operations 1
TIMESTAMP datatype 1
tnsnames.ora
- connect descriptor 1
TO_DATE function, main topic 1
tools and the gateway 1
trace parameters
- setting 1
tracing
- SQL statements 1
trade-off, Native Semantics 1
transparency
- main topic, gateway transparency 1
- native semantics 1
triggers for Oracle database 1
two-phase commit
- processing transactions 1
- protection 1
- unsupported statement 1

U

UNION
- capability 1
- operator, SQL Set Clauses 1
- SQL set operators and clauses 1
UNION ALL
- operator, SQL Set Clauses 1
- SQL set operators and clauses 1
UPDATE
- known restrictions, SQL limitations 1
- operation 1
- SQL clause 1
- statement 1
USER_CATALOG view 1
USER_COL_COMMENTS view 1
USER_CONS_COLUMNS view 1
USER_CONSTRAINTS view 1
USER_DB_LINKS data dictionary view 1
USER_INDEXES view 1
USER_OBJECTS view 1
USER_SYNONYMS view 1
USER_TAB_COLUMNS view 1
USER_TAB_COMMENTS view 1
USER_TABLES view 1
USER_USERS view 1
USER_VIEWS view 1
user privileges 1
USING clause 1
Using the gateway 1

V

VALUES clause
- functions not allowed by DB2 1
variable
- bind, SQL passthrough 1
- input bind 1
view
- catalog
  - DB2/400 1
  - DB2/OS390 1
  - DB2/UDB 1
- data dictionary
  - emulation on DRDA server 1

W

WHERE clause
- known restrictions, SQL limitations 1
- SQL Set Clauses 1
WHERE CURRENT OF CURSOR clause
- known restrictions, SQL limitations 1
wireless communication 1

Z

zoned decimal operations 1