Index
A
B
C
D
E
F
G
H
L
M
N
O
P
Q
R
S
T
U
V
A
- agents
- generic connectivity, 1-4
- Heterogeneous Services, 1-3
- disabling self-registration, 2-6
- registering, 2-5, 2-6, 2-7
- specifying initialization parameters for, 2-4
- application development
- Heterogeneous Services, 4-1, 4-2
- controlling array fetches between non-Oracle server and agent, 4-11
- controlling array fetches between Oracle server and agent, 4-11
- controlling reblocking of array fetches, 4-11
- DBMS_HS_PASSTHROUGH package, 4-2
- pass-through SQL, 4-2
- using bulk fetches, 4-9
- using OCI for bulk fetches, 4-10
- using Heterogeneous Services, 4-1
- Architecture of the Heterogenous Services Data Dictionary, 1-6
- array fetches, 4-10
- agents, 4-11
B
- bind queries
- executing using pass-through SQL, 4-7
- BIND_INOUT_VARIABLE procedure, 4-3, 4-7
- BIND_OUT_VARIABLE procedure, 4-3, 4-6
- BIND_VARIABLE procedure, 4-3
- buffers
- multiple rows, 4-8
- bulk fetches
- optimizing data transfers using, 4-9
C
- CATHO.SQL script
- installing data dictionary for Heterogeneous Services, 2-2
- character sets
- Heterogeneous Services, A-7
- CLOSE_CURSOR function, 4-3
- commit point site
- commit point strength, A-3
- configuring generic connectivity, 3-8
- configuring transparent gateways, 2-2
- CREATE_INST_INIT procedure, 2-19
D
- data dictionary
- contents with generic connectivity, D-3
- installing for Heterogeneous Services, 2-2
- mapping for generic connectivity, D-4
- Oracle server name/SQL Server name, D-4
- tables, 1-5
- translation support for generic connectivity, D-2
- data dictionary views
- generic connectivity, D-3
- Heterogeneous Services, 2-9, B-1
- database links
- heterogeneous systems, 1-5, 2-4
- datatypes
- mapping, 1-5
- ODBC, E-2
- ODBC to Oracle, E-2
- OLE DB, E-3
- OLE DB to Oracle, E-3
- date formats
- Heterogeneous Services, A-8
- DBMS_HS package
- specifying HS parameters, 2-18
- DBMS_HS_PASSTHROUGH package, 4-2
- list of functions and procedures, 4-3
- DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, C-15
- describe cache high water mark
- definition, A-4
- drivers
- ODBC, 3-13
- OLEFS, 3-16
- OLESQL, 3-15
- dynamic performance views
- Heterogeneous Services, 2-16
- determining open sessions, 2-17
- determining which agents are on host, 2-16
E
- EXECUTE_IMMEDIATE procedure, 4-3
- restrictions, 4-4
- EXECUTE_NON_QUERY procedure, 4-3
F
- FDS_CLASS, 2-8
- FDS_CLASS_VERSION, 2-8
- FDS_INST_NAME, 2-8
- FETCH_ROW procedure, 4-3
- executing queries using pass-through SQL, 4-7
- fetches
- bulk, 4-9
- optimizing round-trips, 4-8
G
- generic connectivity
- architecture, 3-3
- Oracle and non-Oracle on same machine, 3-4
- Oracle and non-Oracle on separate machines, 3-3
- configuration, 3-8
- creating initialization file, 3-8
- data dictionary
- translation support, D-2
- definition, 3-2
- DELETE statement, 3-7
- editing initialization file, 3-9
- error tracing, A-6
- Heterogeneous Services, 1-4
- INSERT statement, 3-7
- non-Oracle data dictionary access, D-2
- ODBC connectivity requirements, 3-13
- OLE DB (FS) connectivity requirements, 3-16
- OLE DB (SQL) connectivity requirements, 3-15
- restrictions, 3-6
- setting parameters for ODBC source, 3-10
- UNIX, 3-11
- Windows NT, 3-10
- setting parameters for OLE DB source, 3-12
- SQL execution, 3-6
- supported functions, 3-7
- supported SQL syntax, 3-7
- types of agents, 3-2
- UPDATE statement, 3-7
- GET_VALUE procedure, 4-3, 4-6, 4-7
H
- heterogeneous distributed systems
- accessing, 2-2
- Heterogeneous Services
- agent registration, 2-5
- avoiding configuration mismatches, 2-6
- disabling, 2-6
- enabling, 2-5
- agents
- self-registration, 2-7
- application development, 4-1, 4-2
- controlling array fetches between non-Oracle server and agent, 4-11
- controlling array fetches between Oracle server and agent, 4-11
- controlling reblocking of array fetches, 4-11
- DBMS_HS_PASSTHOUGH package, 4-2
- locking behavior of non-Oracle systems, 4-12
- pass-through SQL, 4-2
- using bulk fetches, 4-9
- using OCI for bulk fetches, 4-10
- creating database links, 2-4
- data dictionary, 1-6
- classes and instances, 1-7
- data dictionary views, 2-9, B-1
- types, 2-10
- understanding sources, 2-12
- using general views, 2-12
- using SQL service views, 2-14
- using transaction service views, 2-13
- database links to non-Oracle systems, 1-5
- DBMS_HS package
- using to specify initialization parameters, 2-19
- using to unspecify initialization parameters, 2-20
- defining maximum number of open cursors, A-9
- dynamic performance views, 2-16
- V$HS_AGENT view, 2-16
- V$HS_SESSION view, 2-17
- generic connectivity
- architecture, 3-3
- creating initialization file, 3-8
- definition, 3-2
- editing initialization file, 3-9
- non-Oracle data dictionary access, D-2
- ODBC connectivity requirements, 3-13
- OLE DB (FS) connectivity requirements, 3-16
- OLE DB (SQL) connectivity requirements, 3-15
- restrictions, 3-6
- setting parameters for ODBC source, 3-10
- setting parameters for OLE DB source, 3-12
- SQL execution, 3-6
- supported functions, 3-7
- supported SQL syntax, 3-7
- supported tables, D-3
- types of agents, 3-2
- initialization parameters
- specifying, 2-19
- unspecifying, 2-20
- installing data dictionary, 2-2
- locking behavior of non-Oracle systems, 4-12
- optimizing data transfer, A-10
- overview, 1-2
- setting global name, A-4
- setting up access using transparent gateway, 2-2
- setting up environment, 2-2
- specifying cache high water mark, A-4
- specifying cache size, A-10
- specifying commit point strength, A-3
- specifying domain, A-3
- specifying instance identifier, A-4
- SQL service, 1-5
- testing connections, 2-4
- transaction service, 1-4
- tuning internal data buffering, A-11
- types, 1-4
- HS_AUTOREGISTER initialization parameter, 2-18
- using to enable agent self-registration, 2-9
- HS_BASE_CAPS view, 2-11
- HS_BASE_DD view, 2-11
- HS_CLASS_CAPS view, 2-11
- HS_CLASS_DD view, 2-11
- HS_CLASS_INIT view, 2-11
- HS_COMMIT_POINT_STRENGTH initialization parameter, A-3
- HS_DB_DOMAIN initialization parameter, 2-20, A-3
- HS_DB_INTERNAL_NAME initialization parameter, A-4
- HS_DB_NAME initialization parameter, A-4
- HS_DESCRIBE_CACHE_HWM initialization parameter, A-4
- HS_FDS_CLASS view, 2-11
- HS_FDS_CONNECT_INFO initialization parameter, A-5
- specifying connection information, 3-9
- HS_FDS_FETCH_ROWS initialization parameter, 4-11
- HS_FDS_INST view, 2-11
- HS_FDS_SHAREABLE_NAME initialization parameter, A-6
- HS_FDS_TRACE initialization parameter, A-6
- HS_FDS_TRACE_FILE_NAME initialization parameter, A-6
- HS_FDS_TRACE_LEVEL initialization parameter
- enabling agent tracing, 3-10
- HS_INST_CAPS view, 2-11
- HS_INST_DD view, 2-11
- HS_INST_INIT view, 2-11
- HS_LANGUAGE initialization parameter, A-7
- HS_NLS_DATE_FORMAT initialization parameter, A-8
- HS_NLS_DATE_LANGUAGE initialization parameter, A-8
- HS_NLS_NCHAR initialization parameter, A-9
- HS_OPEN_CURSORS initialization parameter, A-9
- HS_ROWID_CACHE_SIZE initialization parameter, A-10
- HS_RPC_FETCH_REBLOCKING initialization parameter, 4-11, A-10
- HS_RPC_FETCH_SIZE initialization parameter, 4-11, A-11
L
- Limitations to Heterogeneous Services, 4-12
- listeners, 2-2
- locks
- in non-Oracle systems, 4-12
M
- multiple rows
- buffering, 4-8
N
- National Language Support (NLS)
- Heterogeneous Services, A-7
- character set of non-Oracle source, A-9
- date format, A-8
- languages in character date values, A-8
- Net8 listener, 1-3, 2-2
O
- OCI
- optimizing data transfers using, 4-10
- ODBC agents
- connectivity requirements, 3-13
- functions, 3-14
- ODBC connectivity
- data dictionary mapping, D-4
- mapping OBDC datatypes, E-2
- mapping Oracle datatypes, E-2
- ODBC driver, 3-13
- requirements, 3-13
- specifying connection information
- UNIX, A-5
- Windows NT, A-5
- specifying path to library, A-6
- OLE DB agents
- connectivity requirements, 3-15, 3-16
- OLE DB connectivity
- data dictionary mapping, D-4
- mapping to Oracle datatypes, E-3
- setting connection information, A-5
- OLEFS drivers, 3-16
- data provider requirements, 3-16
- initialization properties, 3-18
- rowset properties, 3-18
- OLESQL drivers, 3-15
- security, 3-15
- OPEN_CURSOR procedure, 4-3
- operating system dependencies, C-1
- Oracle precompiler
- optimizing data transfers using, 4-10
- OUT bind variables, 4-6
P
- PARSE procedure, 4-3
- pass-through SQL, 4-2
- avoiding SQL interpretation, 4-2
- executing statements, 4-3
- non-queries, 4-4
- queries, 4-7
- with bind variables, 4-4
- with IN bind variables, 4-5
- with IN OUT bind variables, 4-6
- with OUT bind variables, 4-6
- implications of using, 4-3
- overview, 4-2
- restrictions, 4-3
- PL/SQL
- development environment, 4-2
Q
- queries
- pass-through SQL, 4-7
R
- reblocking, 4-11
- Researching, 4-12
- rows
- buffering multiple, 4-8
S
- security
- OLESQL driver, 3-15
- SELECT statement
- accessing non-Oracle system, D-2
- service names
- specifying in database links, 2-4
- SQL capabilities
- data dictionary tables, 2-15
- SQL dialect
- understood by non-Oracle system, 1-5
- SQL service
- capabilities, 1-5
- data dictionary views, 1-8, 2-10
- Heterogeneous Services, 1-5
- views
- Heterogeneous Services, 2-14
- SQL statements
- mapping to non-Oracle datastores, 4-2
T
- transaction service
- Heterogeneous Services, 1-4
- views
- Heterogeneous Services, 2-13
- transparent gateways
- accessing Heterogeneous Services agents, 2-2
- creating database links, 2-4
- Heterogeneous Services, 1-3
- installing Heterogeneous Services data dictionary, 2-2
- testing connections, 2-4
U
- unsupported functions
- generic connectivity, 3-7
V
- V$HS_AGENT view
- determining which agents are on host, 2-16
- V$HS_PARAMETER view
- listing HS parameters, 2-18
- V$HS_SESSION view
- determining open sessions, 2-17
- variables
- BIND, 4-4