1. Index

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
  • ALL_CATALOG view A.2
  • ALL_COL_COMMENTS view A.3
  • ALL_CON_COLUMNS view A.4
  • ALL_CONSTRAINTS view A.5
  • ALL_DB_LINKS data dictionary view 3.2.3
  • ALL_INDEXES view A.6
  • ALL_OBJECTS view A.8
  • ALL_SYNONYMS view A.9
  • ALL_TAB_COMMENTS view A.12
  • ALL_TABLES view A.10
  • ALL_USERS view A.13
  • ALL_VIEWS view A.14
  • ALTER SESSION statement 3.2.1
  • ANSI-standard SQL 1.2.5, 1.8
  • APPEND command
    • supported by COPY 3.8
  • application
  • application development on the gateway 1.8
  • architecture of the gateway 1.4
  • array size
    • fetch reblocking 1.8
    • how determined 4.1.1
  • AS/400
    • files and file members, accessing 3.4
    • library name, HS_FDS_PACKAGE_COLLID B.29
  • ASCII
  • autonomy, site 1.2.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.1

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
  • capabilities of DRDA server, native semantics 4.6
  • changes in this release
    • IBM DB2/UDB supported 1.8
    • read-only support 1.8
  • character sets
    • Heterogeneous Services B.8.1
  • character string
    • converting datatypes 4.7.2
    • performing operations 4.7.2
  • CHECKSUM command
    • extended advanced networking 1.2.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
    • USING 3.2.1
    • VALUES
      • functions not allowed by DB2 4.7.7
    • WHERE
      • known restrictions, SQL limitations 2.5.2.1
      • SQL Set Clauses 4.6.3
      • WHERE CURRENT OF CURSOR, known restrictions, SQL limitations 2.5.2.1
  • closing and opening again any session against db2 required with any change to
    • HS_FDS_PACKAGE_COLLID B.29
  • coercion
  • column
    • date columns, TO_DATE function 4.7.7
    • supported in a result set 1.8
  • commands
    • CHECKSUM 1.2.3
    • COPY
      • Oracle database to DRDA server 3.8
      • SQL*Plus command 3.8
    • EXECUTE 1.2.9
    • EXPLAIN PLAN 5.3.1
  • commit confirm protocol 1.2.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.6
    • to the numeric datatype 4.7.8
  • converter, protocol 1.2.3
  • COPY command
    • Oracle database to DRDA server 3.8
  • copying data
    • from the DRDA server 3.9
    • from the Oracle database to DRDA server 3.8
  • COPY SQL*Plus command 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.2.8
  • creating

D

  • database
  • data coercion 4.6
  • data control language (DCL) 1.2.7
  • DATA datatype 4.7.4.1
  • data definition language (DDL) 1.2.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
      • supported for DB2/OS390 and DB2/400 servers A.1
      • USER_DB_LINKS 3.2.3
  • datatype
    • character string 4.7.1
    • column (ALL_TAB_COLUMNS) A.11
    • column (USER_TAB_COLUMNS) A.27
    • 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
  • date arithmetic
  • DATE datatype 4.7.4
  • DB_DOMAIN parameter
  • DB2
    • data access 1.2.9
    • native SQL 1.2.8
    • native stored procedures 1.2.9
    • procedural feature considerations 4.3.2
    • SQL statements 4.8.2
    • statements
    • stored procedures 4.3.2
  • 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.8
  • DB2/UDB
    • catalog view 4.9.1
    • data dictionary views not supported A.1
    • supported 1.8
  • DB2 UDB for iSeries
    • HS_FDS_PACKAGE_COLLID B.29
  • DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function 4.8
  • DD basic tables, known restrictions 2.5.1.1
  • DDL
    • statement 4.8
  • debug
  • debugging
  • DELETE
    • known restrictions, SQL limitations 2.5.2.1
    • 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.7
  • dictionary
  • DICTIONARY view A.16
  • distributed
    • applications, support for 1.8
    • DRDA transactions 3.6.2
    • queries
    • transaction, HS_FDS_RECOVERY_ACCOUNT B.16
  • DRDA
  • DRDA server
    • architecture 1.4
    • 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.2.4

E

  • EBCDIC
  • EMP
    • system-wide synonym 3.5
  • environment
    • heterogeneous 3.7
  • errmc
    • errmc field lists any error tokens 5.1.2
  • error
    • basic description 5.1
    • detected
    • interpreting error messages 5.1
    • messages
      • Oracle LONG datatype is too long 4.7.2
    • messages ((amp)) codes 5
    • ORA-02019 5.1.1
    • ORA-28500 (was ORA-09100) 5.1.2
    • Oracle mapped error codes 5.2
    • tokens 5.1.2
    • translation 4.7.1
    • with Native Semantics 4.6
  • Error messages
    • error tracing B.19
  • EXCEPT set operator, SQL Set Clauses 4.6.3
  • EXECUTE command 1.2.9
  • exits
    • gateway local date 4.7.6
  • EXPLAIN PLAN command 5.3.1

F

  • features of the gateway
    • application development and end-user tools 1.8
    • application portability 1.8
    • columns supported in a result set 1.8
    • distributed applications supported 1.8
    • EXPLAIN_PLAN improvement 1.8
    • fetch reblocking 1.8
    • heterogeneous database integration 1.8
    • heterogeneous services architecture 1.8
    • main topic 1.8
    • minimum impact on existing systems 1.8
    • Native Semantics 1.8
    • Oracle database passthrough supported 1.8
    • Oracle snapshots 3.7
    • performance enhancements 1.8
    • remote data access 1.8
    • retrieving result sets through passthrough 1.8
    • support for TCP/IP 1.8
  • fetch array size, with HS_FDS_FETCH_ROWS B.18
  • fetch reblocking
    • controlled by two Heterogeneous Services initialization parameters 1.8
    • supported by Oracle database 4.1.1
  • fields
    • errmc, lists any error tokens 5.1.2
  • file member
    • accessing AS/400 files 3.4
    • name 3.4
  • FOR BIT DATA
  • functions

G

  • gateway
    • accessing
      • main topic 3.3
    • advantages
    • and Oracle tools 1.7
    • and stored procedures (Oracle and non-Oracle) 1.2.9
    • application tools 1.8
    • architecture 1.4
    • benefits of integration with Oracle database 1.2.3
    • components 1.5
    • definition of terms 1.3
    • features, main topic 1.8
    • how to access 3.3
    • interface 1.6
    • local date exit 4.7.6
    • performance enhancements 1.8
    • performance versus transparency 4.6
    • performing distributed queries 3.6
    • SQL differences 1.6
    • tracing
      • SQL statements 3.10
    • using 3
    • with other Oracle products, SQL*Plus 1.2.12
  • GENERAL and DB2SQL linkage convention
  • GLOBAL_NAMES
  • globalization support
    • Heterogeneous Services B.8
  • GRAPHIC datatype 4.7.3
  • graphic string operations
  • GROUP BY clause

H

  • HAVING clause
  • heterogeneous database integration 1.8
  • Heterogeneous Services
    • defining maximum number of open cursors B.10
    • optimizing data transfer B.11
    • setting global name B.6
    • specifying cache high water mark B.7
    • tuning internal data buffering B.12
    • tuning LONG data transfer B.9
  • Heterogeneous Services (HS), see HS 1.1
  • host
    • performing character string operations on 4.7.1
    • relationship to gateway and Oracle database 1.4
    • variable 4.7
  • HS_CALL_NAME initialization parameter B.3
  • HS_DB_DOMAIN parameter
  • HS_DB_NAME initialization parameter B.6
  • HS_DESCRIBE_CACHE_HWM initialization parameter B.7
  • HS_FDS_CONNECT_INFO B.15
  • HS_FDS_FETCH_ROWS parameter B.18
  • HS_FDS_PACKAGE_COLLID parameter
  • HS_FDS_TRACE_LEVEL initialization parameter B.19
    • enabling agent tracing B.1
  • HS_FDS_TRANSACTION_ISOLATIONparameter B.28
  • HS_FDS_TRANSACTION_LOG initialization parameter B.20
  • HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter B.31
  • HS_LANGUAGE initialization parameter B.8
  • HS_LONG_PIECE_TRANSFER_SIZE initialization parameter B.9
  • HS_NLS_DATE_FORMAT
    • four date patterns 4.7.6
  • HS_OPEN_CURSORS initialization parameter B.10
  • HS_RPC_FETCH_REBLOCKING initialization parameter B.11
  • HS_RPC_FETCH_REBLOCKING parameter
    • Oracle database support 4.1.1
  • HS_RPC_FETCH_SIZE initialization parameter B.12
  • HS_RPC_FETCH_SIZE parameter
    • specified in the Gateway Initialization File 1.8
    • value determines array size 4.1.1
  • HS (Heterogeneous Services)
    • architecture features 1.8

I

  • IFILE initialization parameter B.14
  • implementation 1.5
  • implicit data conversion 4.6
  • implicit protocol conversion 1.2.3
  • Initialization parameter file
    • customizing B
  • input bind variables 4.7.4.2
  • INSERT
    • operation 4.1
    • SQL clause 4.7.7
    • statement
      • passthrough SQL feature 4.8
  • INSERT command
    • supported by COPY 3.8
  • Internet support 1.2.3
  • INTERSECT, SQL set operators and clauses 4.6.3
  • isolation level, HS_FDS_TRANSACTION_ISOLATION B.28
  • ISO standard 1.2.5

J

  • JOIN capability 1.2.2
  • JOIN SQL statement 4.1

K

L

  • languages
  • link, also see Database Link 4.4
  • literal
  • LONG RAW datatype 4.7.1

M

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

N

  • Native Semantics
    • gateway architecture 1.8
    • 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

O

  • o2pc.sql
    • two-phase commit transactions 3.6.1
  • OPEN_LINKS parameter 3.2.4
  • operations
  • operators
    • UNION, SQL Set Clauses 4.6.3
    • UNION ALL, 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.4
    • read-only
      • gateway configuration 1.2.13
    • replicating 3.7
    • SQL*Plus COPY command 3.8
    • SQL functions 4.6.1
  • ORA-02019 error 5.1.1
  • ORA1 Oracle instance 4.2
  • ORA-28500 error
  • Oracle
    • mapped error codes 5.2
    • products compatibility 1.7
    • snapshots 3.7
  • Oracle database
    • accessing the gateway 3.3
    • architecture 1.4
    • copying data
      • from DRDA server 3.9
      • to DRDA server 3.8
    • definition 1.3
    • relationship to host 1.4
    • services
      • database triggers 1.2.2
      • distributed capabilities 1.2.2
      • distributed query optimization 1.2.2
      • extended database services 1.2.2
      • stored procedures 1.2.2
      • two-phase commit protection 1.2.2
    • stored procedure, defined 4.2
    • triggers 3.7
    • using, in application development 4.1
  • Oracle Net
    • and application development 1.8
    • and remote data access 1.8
    • and server coexistence 1.4
    • integrated with Oracle database 1.2.11
    • purpose 1.5
    • TNS connect descriptor specification 3.2.1
  • ORARECOV user ID
    • HS_FDS_RECOVERY_ACCOUNT B.16
  • ORDER BY clause

P

  • package
    • collection id, HS_FDS_PACKAGE_COLLID B.29
  • packed decimal 4.7.10
  • parameter
    • Native Semantics, SQL Set Clauses 4.6.3
    • setting up trace parameters 5.3
  • parameters
    • DB_DOMAIN
    • gateway initialization file
      • HS_FDS_CAPABILITY B.27
      • HS_FDS_FETCH_ROWS B.18
      • HS_FDS_PACKAGE_COLLID B.29
      • HS_FDS_TRANSACTION_ISOLATION B.28
    • HS_DB_DOMAIN
    • HS_NLS_DATE_FORMAT 4.7.5, 4.7.6
    • HS_RPC_FETCH_REBLOCKING 4.1.1
    • HS_RPC_FETCH_SIZE 1.8, 4.1.1
    • OPEN_LINKS 3.2.4
  • passthrough
    • gateway features 1.8
    • native DB2 SQL 1.2.8
    • send SQL statement directly to DRDA server 4.8
  • performance 4.6
  • performance enhancements
    • with fetch reblocking 4.1.1
  • PL/SQL
  • post-processed SQL functions
  • 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.2.13
    • converter 1.2.3
    • implicit protocol conversion 1.2.3
    • network 3.5
    • protocol-independent encryption 1.2.3
    • two-phase commit 3.6.1
  • protocols
    • TCP/IP
      • gateway transparency 1.2.1
      • implicit protocol conversion 1.2.3

Q

  • queries, distributed 3.6

R

  • RAW datatype
    • performing character string operations 4.7.1
  • read-only support 1.8
  • remote
    • connections 3.2.4
    • data 1.2.2
    • data access 1.8
    • database
      • 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_TRANSACTION_ISOLATION B.28
    • 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.2.9
    • table 1.2.4
    • user ID and password 3.2.1
  • remote functions
    • referenced in SQL statements B.3
  • REPLACE command, supported by COPY 3.8
  • replication 3.7
  • RESULT 4.3.1
  • result sets
    • columns in 1.8
    • retrieving result sets through passthrough 1.8
  • REVISE_SALARY

S

  • security
  • SELECT and array size 1.8
  • SELECT operation 4.1
  • SELECT statement
    • fetch reblocking 4.1.1
    • retrieving results sets 4.8.3
  • SELECT WHERE
  • 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.2.14
  • snapshots
    • known restrictions, SQL limitations 2.5.2.1
    • Oracle Snapshot feature 3.7
  • sort order
  • SQL
    • ANSI standard 1.2.5
    • clause compatibility 4.6.3
    • clauses
    • constructs
      • Oracle processing 4.5
    • differences in the gateway 1.6
    • errors mapped to Oracle error codes 5.2
    • functions
    • functions and Native Semantics 4.6
    • gateway transparency 1.2.5
    • ISO standard 1.2.5
    • native DB2 1.2.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_TRANSACTION_ISOLATION B.28
    • syntax 4.7.9
    • tracing, not to be used in production environment 3.10
  • SQL*Plus
  • SQL functions
  • SQL tracing
    • in Oracle database 5.3.1
  • statements
  • stored procedure
  • stored procedures 1.2.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.6

T

  • table
  • TABLE_PRIVILEGES view A.18
  • TCP/IP
    • facilities 1.8
    • functions 1.5
    • protocol
      • gateway transparency 1.2.1
      • implicit protocol conversion 1.2.3
    • support 1.8
  • terminology defined 1.3
  • 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.7
  • trace parameters
  • tracing
    • SQL statements 3.10
  • trade-off, Native Semantics 4.6
  • transparency
    • main topic, gateway transparency 1.2.1
    • native semantics 4.6
  • triggers for Oracle database 3.7
  • two-phase commit
    • processing transactions 3.6.1
    • protection 1.2.2
    • unsupported statement 3.6.1

U

  • UNION
    • capability 1.2.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.1
    • operation 4.1
    • SQL clause 4.7.7
    • statement 4.8
  • USER_CATALOG view A.19
  • USER_COL_COMMENTS view A.20
  • USER_CONS_COLUMNS view A.22
  • USER_CONSTRAINTS view A.21
  • USER_DB_LINKS data dictionary view 3.2.3
  • USER_INDEXES view A.23
  • USER_OBJECTS view A.24
  • USER_SYNONYMS view A.25
  • USER_TAB_COLUMNS view A.27
  • USER_TAB_COMMENTS view A.28
  • USER_TABLES view A.26
  • USER_USERS view A.30
  • USER_VIEWS view A.29
  • user privileges 4.9
  • USING clause 3.2.1
  • Using the gateway 3

V

  • VALUES clause
    • functions not allowed by DB2 4.7.7
  • variable
  • view
    • catalog
    • data dictionary
      • emulation on DRDA server 4.9

W

  • WHERE clause
    • known restrictions, SQL limitations 2.5.2.1
    • SQL Set Clauses 4.6.3
  • WHERE CURRENT OF CURSOR clause
    • known restrictions, SQL limitations 2.5.2.1
  • wireless communication 1.2.3

Z

  • zoned decimal operations 4.7.10