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