Index
A
- accessing
- gateway
- main topic 3.3
- gateway
- Advanced Security
- ALL_CATALOG view A.1
- ALL_COL_COMMENTS view A.2
- ALL_CON_COLUMNS view A.3
- ALL_CONSTRAINTS view A.4
- ALL_DB_LINKS data dictionary view 3.2.3
- ALL_IND_COLUMNS view A.6
- ALL_INDEXES view A.5
- ALL_OBJECTS view A.7
- ALL_SYNONYMS view A.8
- ALL_TAB_COMMENTS view A.11
- ALL_TABLES view A.9
- ALL_USERS view A.12
- ALL_VIEWS view A.13
- 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
- AS/400
- ASCII
- autonomy, site 1.2.14
C
- call
- capabilities of DRDA server, native semantics 4.9
- changes in this release
- character sets
- Heterogeneous Services B.35.1
- character string
- CHECKSUM command
- extended advanced networking 1.2.3
- clauses
- closing and opening again any session against DB2 required with any change to
- HS_FDS_PACKAGE_COLLID B.17
- coercion
- of data 4.9
- column
- COLUMN PRIVILEGES view A.14
- commands
- commit confirm protocol 1.2.13
- compatible SQL set operators and clauses 4.9.3
- CONNECT TO clause 3.2.1
- convert
- converter, protocol 1.2.3
- COPY command
- Oracle database to DRDA server 3.8
- copying data
- COPY SQL*Plus command 3.8
- COS SQL function 4.5.3.1
- COUNT function 4.10.9
- CREATE command
- supported by COPY 3.8
- CREATE DATABASE LINK command 3.2.1
- CREATE TABLE statement 1.2.8
- creating
- database link 3.2.1
D
- database
- data coercion 4.9
- data control language (DCL) 1.2.7
- DATA data type 4.10.4.1
- data definition language (DDL) 1.2.6
- data dictionary
- datatype
- data type
- character string 4.10.1
- column (USER_TAB_COLUMNS) A.26
- conversion
- converting character string 4.10.1, 4.10.2
- data and time 4.10.4
- differences between Oracle database and DRDA databases 4.10
- DRDA server data types list 4.10
- mapping 4.10
- operations, numeric 4.10.8
- Oracle data types RAW and LONG RAW 4.10.1
- restrictions 4.10
- size and value limitations 4.10
- data types
- date
- date arithmetic
- known restrictions 2.5.1.8
- DATE data type 4.10.4
- DB_DOMAIN parameter
- known restrictions 2.5.1.6
- DB2
- DB2/400
- DB2/OS390
- DB2/UDB
- DB2 UDB for iSeries
- HS_FDS_PACKAGE_COLLID B.17
- DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE function 4.11
- DD basic tables, known restrictions 2.5.1.1
- DDL
- statement 4.11
- debug
- gateway 5.3
- debugging
- DELETE
- DESCRIBE
- character string operations 4.10.1
- describe cache high water mark
- definition B.7
- dictionary
- DICTIONARY view A.15
- distributed
- DRDA
- catalog 4.12.2
- DRDA server
- DRDA server error 5.1.3
- DROP DATABASE LINK statement 3.2.2
- DUAL view A.16
- 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
- Error messages
- error tracing B.27
- EXCEPT set operator, SQL Set Clauses 4.9.3
- EXECUTE command 1.2.9
- exits
- gateway local date 4.10.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.14
- fetch reblocking
- fields
- errmc, lists any error tokens 5.1.2
- file member
- FOR BIT DATA
- option 4.10.1
- 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.10.6
- performance enhancements 1.8
- performance versus transparency 4.9
- 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
- accessing
- GENERAL and DB2SQL linkage convention
- gateway support 4.3.2
- GLOBAL_NAMES
- known restrictions 2.5.1.6
- globalization support
- Heterogeneous Services B.35
- GRAPHIC data type 4.10.3
- graphic string operations
- unsupported 4.10.3
- GROUP BY clause
- SQL Set Clauses 4.9.3
H
- HAVING clause
- SQL Set Clauses 4.9.3
- heterogeneous database integration 1.8
- Heterogeneous Services
- Heterogeneous Services (HS), see HS 1.1
- host
- HS_CALL_NAME initialization parameter B.3
- HS_DB_DOMAIN initialization parameter B.4
- HS_DB_DOMAIN parameter
- known restrictions 2.5.1.6
- HS_DB_INTERNAL_NAME initialization parameter B.5
- HS_DB_NAME initialization parameter B.6
- HS_DESCRIBE_CACHE_HWM initialization parameter B.7
- HS_FDS_ARRAY_EXEC initialization parameter B.8
- HS_FDS_AUTHENTICATE_USER initialization parameter B.9
- HS_FDS_CAPABILITY initialization parameter B.10
- HS_FDS_CONNECT_INFO initialization parameter B.11
- HS_FDS_DATE_MAPPING initialization parameter B.12
- HS_FDS_ENCRYPT_SESSION initialization parameter B.13
- HS_FDS_FETCH_ROWS initialization parameter B.14
- HS_FDS_GRAPHIC_TO_MBCS initialization parameter B.15
- HS_FDS_MBCS_TO_GRAPHIC initialization parameter B.16
- HS_FDS_PACKAGE_COLLID initialization parameter
- defined B.17
- HS_FDS_QUOTE_IDENTIFIER initialization parameter B.18
- HS_FDS_RECOVERY_ACCOUNT initialization parameter B.19
- HS_FDS_RECOVERY_PWD initialization parameter B.20
- HS_FDS_REMOTE_DB_CHARSET initialization parameter B.21
- HS_FDS_RESULTSET_SUPPORT initialization parameter B.22
- HS_FDS_RSET_RETURN_ROWCOUNT initialization parameter B.23
- HS_FDS_SQLLEN_INTERPRETATION initialization parameter B.24
- HS_FDS_SUPPORT_STATISTICS initialization parameter B.25
- HS_FDS_TIMESTAMP_MAPPING initialization parameter B.26
- HS_FDS_TRACE_LEVEL initialization parameter B.27
- enabling agent tracing B.1
- HS_FDS_TRANSACTION_ISOLATION initialization parameter B.28
- HS_FDS_TRANSACTION_LOG initialization parameter B.29
- HS_FDS_TRUSTSTORE_FILE initialization parameter B.30
- HS_FDS_TRUSTSTORE_PASSWORD initialization parameter B.31
- HS_FDS_VALIDATE_SERVER_CERT initialization parameter B.32
- HS_IDLE_TIMEOUT initialization parameter B.33
- HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter B.34
- HS_LANGUAGE initialization parameter B.35
- HS_LONG_PIECE_TRANSFER_SIZE initialization parameter B.36
- HS_NLS_DATE_FORMAT
- four date patterns 4.10.6
- HS_NLS_LENGTH_SEMANTICS initialization parameter B.37
- HS_OPEN_CURSORS initialization parameter B.38
- HS_RPC_FETCH_REBLOCKING initialization parameter B.39
- HS_RPC_FETCH_REBLOCKING parameter
- Oracle database support 4.1.1
- HS_RPC_FETCH_SIZE initialization parameter B.40
- HS_RPC_FETCH_SIZE parameter
- HS (Heterogeneous Services)
- architecture features 1.8
I
- IFILE initialization parameter B.42
- implementation 1.5
- implicit data conversion 4.9
- implicit protocol conversion 1.2.3
- Initialization parameter file
- customizing B
- input bind variables 4.10.4.2
- INSERT
- INSERT command
- supported by COPY 3.8
- Internet support 1.2.3
- INTERSECT, SQL set operators and clauses 4.9.3
- isolation level, HS_FDS_TRANSACTION_ISOLATION B.28
- ISO standard 1.2.5
O
- o2pc.sql
- two-phase commit transactions 3.6.1
- OPEN_LINKS parameter 3.2.4
- operations
- operators
- option
- ORA-02019 error 5.1.1
- ORA1 Oracle instance 4.2
- ORA-28500 error
- was ORA-09100 5.1.2
- Oracle
- Oracle database
- Oracle Net
- ORARECOV user ID
- HS_FDS_RECOVERY_ACCOUNT B.19
- ORDER BY clause
- SQL Set Clauses 4.9.3
P
- package
- collection ID, HS_FDS_PACKAGE_COLLID B.17
- packed decimal 4.10.10
- parameter
- setting up trace parameters 5.3
- parameters
- passthrough
- performance 4.9
- performance enhancements
- with fetch reblocking 4.1.1
- PL/SQL
- post-processed SQL functions
- overview 4.5.3.1
- post-processing
- PREPARE TRANSACTION statement 3.6.1
- privileges
- data dictionary emulation 4.12
- procedure
- stored
- using DRDA server 4.3
- stored
- processing time, with GROUPBY, HAVING, WHERE 4.9.2
- protocol
- protocols
R
- RAW data type
- performing character string operations 4.10.1
- read-only support 1.8
- remote
- remote functions
- referenced in SQL statements B.3
- REPLACE command, supported by COPY 3.8
- replication 3.7
- RESULT 4.3.1
- result sets
- REVISE_SALARY
- stored procedure 4.3.1
S
- security
- SELECT and array size 1.8
- SELECT operation 4.1
- SELECT statement
- SELECT WHERE
- SQL clause 4.10.7
- semantics 4.9
- session
- connection 4.4
- set operators
- site autonomy 1.2.14
- snapshots
- sort order
- with ORDERBY 4.9.2
- SQL
- ANSI standard 1.2.5
- clause compatibility 4.9.3
- clauses
- constructs
- Oracle processing 4.5
- differences in the gateway 1.6
- errors mapped to Oracle error codes 5.2
- functions
- SUBSTR 4.9
- functions and Native Semantics 4.9
- gateway transparency 1.2.5
- ISO standard 1.2.5
- native DB2 1.2.8
- passthrough 4.11, 4.11.2, 4.11.3, 4.11.3.1
- statements 4.1
- statements, HS_FDS_TRANSACTION_ISOLATION B.28
- syntax 4.10.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
- string index, with Native Semantics 4.9
- SUBSTR SQL function 4.9
- synonym
T
- table
- TABLE_PRIVILEGES view A.17
- TCP/IP
- terminology defined 1.3
- TIME data type 4.10.4.1
- time operations 4.10.4
- TIMESTAMP data type 4.10.4.1
- tnsnames.ora
- connect descriptor 3.2.1
- TO_DATE function, main topic 4.10.7
- tools and the gateway 1.7
- trace parameters
- setting 5.3
- tracing
- SQL statements 3.10
- trade-off, Native Semantics 4.9
- transparency
- triggers for Oracle database 3.7
- two-phase commit
U
- UNION
- UNION ALL
- UPDATE
- USER_CATALOG view A.18
- USER_COL_COMMENTS view A.19
- USER_CONS_COLUMNS view A.20
- USER_CONSTRAINTS view A.21
- USER_DB_LINKS data dictionary view 3.2.3
- USER_INDEXES view A.22
- USER_OBJECTS view A.23
- USER_SYNONYMS view A.24
- USER_TAB_COLUMNS view A.26
- USER_TAB_COMMENTS view A.27
- USER_TABLES view A.25
- USER_USERS view A.28
- USER_VIEWS view A.29
- user privileges 4.12
- USING clause 3.2.1
- using the gateway 3