Index
A B C D E F G H I L M O P Q R S T U V
A
- agent control utility. See agtctl.
- agents
-
- Generic Connectivity, 2.3.2
- Heterogeneous Services
-
- architecture, 2.1
- disabling self-registration, 4.4.2
- registering, 4.4, 4.4.1, 4.4.1.1, 4.4.1.2
- types of agents, 2.3
- multithreaded Heterogeneous Services, 5
- specifying initialization parameters for, 4.1.2
- Transparent Gateways, 2.3.1
- agtctl, 5.2, 5.3
-
- commands, 5.3.1
- shell mode commands, 5.3.3
- single-line command mode, 5.3.2
- application development
-
- Heterogeneous Services
-
- controlling array fetches between non-Oracle server and agent, 4.3.3
- controlling array fetches between Oracle server and agent, 4.3.2
- controlling reblocking of array fetches, 4.3.4
- DBMS_HS_PASSTHROUGH package, 3.3
- pass-through SQL, 3.3
- using bulk fetches, 4.3
- using OCI for bulk fetches, 4.3.1
- array fetches, 4.3.1
-
- agents, 4.3.3
B
- bind queries
-
- executing using pass-through SQL, 3.3.3.2
- BIND_INOUT_VARIABLE procedure, 3.3.3, 3.3.3.1.4
- BIND_OUT_VARIABLE procedure, 3.3.3, 3.3.3.1.3
- BIND_VARIABLE procedure, 3.3.3
- buffers
-
- multiple rows, 3.3.3.2
- bulk fetches
-
- optimizing data transfers using, 4.3
C
- callback link, 3.10.2
- character sets
-
- Heterogeneous Services, A.11.1
- CLOSE_CURSOR function, 3.3.3
- commit point site
-
- commit point strength, A.2
- configuring
-
- Generic Connectivity, 7.3
- Transparent Gateways, 4.1
- copying data
-
- from Oracle database server to SQL Server, 4.8
- from SQL Server to Oracle database server, 4.9
- INSERT statement, 4.9
D
- data dictionary
-
- contents with Generic Connectivity, C.3
- mapping for Generic Connectivity, C.3.1
- Oracle server name/SQL Server name, C.3.1
- translation support for Generic Connectivity, C
- data dictionary views
-
- Generic Connectivity, C.3
- Heterogeneous Services, 4.10, C.2
- data type checking support
-
- for remote-mapped statements, 4.5.1
- database links
-
- heterogeneous systems, 4.1.2
- date formats
-
- Heterogeneous Services, A.13, A.17
- DBMS_HS_PASSTHROUGH package, 3.3.1
-
- list of functions and procedures, 3.3.3
- describe cache high water mark
-
- definition, A.6
- dispatcher threads
-
- multithreaded Heterogeneous Services agents, 5.2, 5.2.2
- distributed queries
-
- optimizing performance, 6.2
- drivers
-
- ODBC, 7.4
- OLE DB (FS), 7.6
- OLE DB (SQL), 7.5
- dynamic performance views
-
- Heterogeneous Services, 4.11
-
- determining open sessions, 4.11.2
- determining which agents are on host, 4.11.1
E
- EXECUTE_IMMEDIATE procedure, 3.3.3
-
- restrictions, 3.3.3.1
- EXECUTE_NON_QUERY procedure, 3.3.3
F
- FDS_CLASS, 4.4.1.2.1
- FDS_CLASS_VERSION, 4.4.1.2.1
- FDS_INST_NAME, 4.4.1.2.2
- features
-
- new, Preface
- FETCH_ROW procedure, 3.3.3
-
- executing queries using pass-through SQL, 3.3.3.2
- fetches
-
- bulk, 4.3
- optimizing round-trips, 3.3.3.2
G
- gateways
-
- how they work, 2.7
- Generic Connectivity
-
- architecture, 7.1.2
-
- Oracle and non-Oracle on same machine, 7.1.2.2
- Oracle and non-Oracle on separate machines, 7.1.2.1
- configuration, 7.3
- creating initialization file, 7.3.1
- data dictionary
-
- translation support, C
- defined, 1.2
- definition, 7.1
- DELETE statement, 7.2
- editing initialization file, 7.3.2
- Heterogeneous Services, 2.3.2
- INSERT statement, 7.2
- non-Oracle data dictionary access, C.1
- ODBC connectivity requirements, 7.4
- OLE DB (FS) connectivity requirements, 7.6
- OLE DB (SQL) connectivity requirements, 7.5
- restrictions, 7.1.5
- setting parameters for ODBC source, 7.3.3
-
- UNIX, 7.3.3.2
- Windows NT, 7.3.3.1
- setting parameters for OLE DB source, 7.3.4
- SQL execution, 7.1.3
- supported functions, 7.2
- supported SQL syntax, 7.2
- types of agents, 7.1.1
- UPDATE statement, 7.2
- generic connectivity
-
- error tracing, A.10
- GET_VALUE procedure, 3.3.3, 3.3.3.1.3, 3.3.3.1.4
- globalization support
-
- Heterogeneous Services, A.11
-
- character set of non-Oracle source, A.15
- date format, A.13
- languages in character date values, A.14
H
- heterogeneous distributed systems
-
- accessing, 4.1
- Heterogeneous Services
-
- agent control utility (agtctl), 5.3.1
- agent registration, 4.4
-
- avoiding configuration mismatches, 4.4.1.1
- disabling, 4.4.2
- enabling, 4.4.1
- self-registration, 4.4.1.2
- application development
-
- controlling array fetches between non-Oracle server and agent, 4.3.3
- controlling array fetches between Oracle server and agent, 4.3.2
- controlling reblocking of array fetches, 4.3.4
- DBMS_HS_PASSTHROUGH package, 3.3
- pass-through SQL, 3.3
- using bulk fetches, 4.3
- using OCI for bulk fetches, 4.3.1
- creating database links, 4.1.2
- data dictionary views, 4.10, C.2
-
- types, 4.10.1
- understanding sources, 4.10.2
- using general views, 4.10.3
- using SQL service views, 4.10.5
- using transaction service views, 4.10.4
- defining maximum number of open cursors, A.19
- dynamic performance views, 4.11
-
- V$HS_AGENT view, 4.11.1
- V$HS_SESSION view, 4.11.2
- Generic Connectivity
-
- architecture, 7.1.2
- creating initialization file, 7.3.1
- definition, 7.1
- editing initialization file, 7.3.2
- non-Oracle data dictionary access, C.1
- ODBC connectivity requirements, 7.4
- OLE DB (FS) connectivity requirements, 7.6
- OLE DB (SQL) connectivity requirements, 7.5
- restrictions, 7.1.5
- setting parameters for ODBC source, 7.3.3
- setting parameters for OLE DB source, 7.3.4
- SQL execution, 7.1.3
- supported functions, 7.2
- supported SQL syntax, 7.2
- supported tables, C.3
- types of agents, 7.1.1
- initialization parameters, 2.5.2, 4.2, 7.3.1, A
- multithreaded agents, 5
- optimizing data transfer, A.21
- setting global name, A.5
- setting up access using Transparent Gateway, 4.1
- setting up environment, 4.1.1
- specifying cache high water mark, A.6
- specifying cache size, A.20
- specifying commit point strength, A.2
- SQL service, 2.4.2
- testing connections, 4.1.3
- transaction service, 2.4.1
- tuning internal data buffering, A.22
- tuning LONG data transfer, A.12
- HS_AUTOREGISTER initialization parameter
-
- using to enable agent self-registration, 4.4.1.3
- HS_BASE_CAPS view, 4.10.1
- HS_BASE_DD view, 4.10.1
- HS_CALL_NAME initialization parameter, A.1
- HS_CLASS_CAPS view, 4.10.1
- HS_CLASS_DD view, 4.10.1
- HS_CLASS_INIT view, 4.10.1
- HS_COMMIT_POINT_STRENGTH initialization parameter, A.2
- HS_DB_NAME initialization parameter, A.5
- HS_DESCRIBE_CACHE_HWM initialization parameter, A.6
- HS_FDS_CLASS view, 4.10.1
- HS_FDS_CONNECT_INFO initialization parameter, A.7
-
- specifying connection information, 7.3.2
- HS_FDS_DEFAULT_SCHEMA_NAME initialization parameter, A.8
- HS_FDS_FETCH_ROWS initialization parameter, 4.3.3
- HS_FDS_INST view, 4.10.1
- HS_FDS_SHAREABLE_NAME initialization parameter, A.9
- HS_FDS_TRACE_LEVEL initialization parameter, A.10
-
- enabling agent tracing, 7.3.2
- HS_INST_CAPS view, 4.10.1
- HS_INST_DD view, 4.10.1
- HS_INST_INIT view, 4.10.1
- HS_LANGUAGE initialization parameter, A.11
- HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, A.12
- HS_NLS_DATE_FORMAT initialization parameter, A.13
- HS_NLS_DATE_LANGUAGE initialization parameter, A.14
- HS_NLS_NCHAR initialization parameter, A.15
- HS_NLS_NUMERIC_CHARACTER initialization parameter, A.16
- HS_NLS_TIMESTAMP_FORMAT initialization parameter, A.17
- HS_NLS_TIMESTAMP_TZ_FORMAT initialization parameter, A.18
- HS_OPEN_CURSORS initialization parameter, A.19
- HS_ROWID_CACHE_SIZE initialization parameter, A.20
- HS_RPC_FETCH_REBLOCKING initialization parameter, 4.3.4, A.21
- HS_RPC_FETCH_SIZE initialization parameter, 4.3.2, 4.3.4, A.22
- HS_TIME_ZONE initialization parameter, A.23
I
- IFILE initialization parameter, A.24
- information integration
-
- benefits of Oracle solutions, 1.3
- challenges, 1.1
- Generic Connectivity, 1.2
- how Oracle addresses, 1.2
- Messaging Gateway, 1.2
- Open System Interfaces, 1.2
- Oracle Streams, 1.2
- Oracle Transparent Gateways, 1.2
- initialization parameters
-
- Heterogeneous Services (HS), 2.5.2, 4.2, 7.3.1, A
- initialization parameters (HS)
-
- common to all gateways, 4.2
- descriptions, A
- Generic Connectivity, 7.3.1
- purpose, 2.5.2
L
- listeners, 4.1.1
M
- Messaging Gateway
-
- defined, 1.2
- monitor thread
-
- multithreaded Heterogeneous Services agents, 5.2, 5.2.1
- multiple rows
-
- buffering, 3.3.3.2
- multithreaded Heterogeneous Services agents
-
- administering, 5.3
- advantages, 5.1.2
- agent control utility (agtctl), 5.3.1
- architecture, 5.2
- configuration parameters, 5.3.4
- dispatcher threads, 5.2, 5.2.2
- monitor thread, 5.2, 5.2.1
- task threads, 5.2, 5.2.3
O
- OCI
-
- optimizing data transfers using, 4.3.1
- ODBC agents
-
- connectivity requirements, 7.4
- functions, 7.4
- ODBC connectivity
-
- data dictionary mapping, C.3.1
- ODBC driver, 7.4
- requirements, 7.4
- specifying connection information
-
- UNIX, A.7.2
- Windows NT, A.7.1
- specifying path to library, A.9
- OLE DB (FS) drivers, 7.6
- OLE DB (SQL) drivers, 7.5
- OLE DB agents
-
- connectivity requirements, 7.5, 7.6
- OLE DB connectivity
-
- data dictionary mapping, C.3.1
- setting connection information, A.7.3
- OLE DB drivers
-
- data provider requirements, 7.6.1
- initialization properties, 7.6.2
- rowset properties, 7.6.2
- Open System Interfaces
-
- defined, 1.2
- OPEN_CURSOR procedure, 3.3.3
- Oracle database server
-
- SQL construct processing, 4.5
- Oracle Net Services listener, 2.2, 4.1.1
- Oracle precompiler
-
- optimizing data transfers using, 4.3.1
- Oracle Streams
-
- defined, 1.2
- Oracle Transparent Gateways
-
- defined, 1.2
- optimizing SQL statements, 6.1
- OUT bind variables, 3.3.3.1.3
P
- PARSE procedure, 3.3.3
- pass-through SQL
-
- avoiding SQL interpretation, 3.3
- executing statements, 3.3.3
-
- non-queries, 3.3.3.1
- queries, 3.3.3.2
- with bind variables, 3.3.3.1.1
- with IN bind variables, 3.3.3.1.2
- with IN OUT bind variables, 3.3.3.1.4
- with OUT bind variables, 3.3.3.1.3
- implications of using, 3.3.2
- overview, 3.3
- restrictions, 3.3.2
Q
- queries
-
- pass-through SQL, 3.3.3.2
R
- reblocking, 4.3.4
- remote functions
-
- referenced in SQL statements, A.1
- remote-mapped statements
-
- and data type checking support, 4.5.1
- rows
-
- buffering multiple, 3.3.3.2
S
- SELECT statement
-
- accessing non-Oracle system, C.1
- service names
-
- specifying in database links, 4.1.2
- SQL capabilities
-
- data dictionary tables, 4.10.5.1
- SQL service
-
- data dictionary views, 2.6.2, 4.10.1
- Heterogeneous Services, 2.4.2
- views
-
- Heterogeneous Services, 4.10.5
- SQL statements
-
- optimizing distributed, 6.1
- Streams
-
- using for heterogeneous connectivity, 3.2
- Synonyms, 4.7
T
- task threads
-
- multithreaded Heterogeneous Services agents, 5.2, 5.2.3
- transaction service
-
- Heterogeneous Services, 2.4.1
- views
-
- Heterogeneous Services, 4.10.4
- transparent gateways
-
- accessing Heterogeneous Services agents, 4.1.1
- creating database links, 4.1.2
- testing connections, 4.1.3
U
- unsupported functions
-
- Generic Connectivity, 7.2
- user-defined functions
-
- executing on non-Oracle database, 4.6
V
- variables
-
- bind, 3.3.3.1.1