Oracle9i Heterogeneous Connectivity Administrator's Guide -- Index

agents

generic connectivity, 2-4

Heterogeneous Services

disabling self-registration, 4-15

registering, 4-11, 4-12, 4-13

specifying initialization parameters for, 4-4

application development

Heterogeneous Services

controlling array fetches between non-Oracle server and agent, 4-9

controlling array fetches between Oracle server and agent, 4-9

controlling reblocking of array fetches, 4-9

DBMS_HS_PASSTHROUGH package, 3-5

pass-through SQL, 3-5

using bulk fetches, 4-8

using OCI for bulk fetches, 4-9

array fetches, 4-9

agents, 4-9

bind queries

executing using pass-through SQL, 3-11

BIND_INOUT_VARIABLE procedure, 3-6, 3-10

BIND_OUT_VARIABLE procedure, 3-6, 3-10

BIND_VARIABLE procedure, 3-6

buffers

multiple rows, 3-12

bulk fetches

optimizing data transfers using, 4-8

CATHO.SQL script

installing data dictionary for Heterogeneous Services, 4-2

character sets

Heterogeneous Services, A-7

CLOSE_CURSOR function, 3-6

commit point site

commit point strength, A-3

configuring

generic connectivity, 7-8

transparent gateways, 4-2

Copying data

COPY command, 4-19

from Oracle database server to SQL Server, 4-19

from SQL Server to Oracle database server, 4-21

INSERT statement, 4-20

CREATE TABLE command, 4-21

data dictionary

contents with generic connectivity, D-5

installing for Heterogeneous Services, 4-2

mapping for generic connectivity, D-7

Oracle server name/SQL Server name, D-7

translation support for generic connectivity, D-1

data dictionary views

generic connectivity, D-5

Heterogeneous Services, 4-22, D-2

database links

heterogeneous systems, 4-4

date formats

Heterogeneous Services, A-8, A-9

DBMS_HS_PASSTHROUGH package, 3-5

list of functions and procedures, 3-6

DBMS_HS_PASSTHROUGH.EXECUTE_IMMEDIATE, C-18

describe cache high water mark

definition, A-4

drivers

ODBC, 7-13

OLE DB (FS), 7-16

OLE DB (SQL), 7-15

dynamic performance views

Heterogeneous Services, 4-28

determining open sessions, 4-28

determining which agents are on host, 4-28

EXECUTE_IMMEDIATE procedure, 3-6

restrictions, 3-7

EXECUTE_NON_QUERY procedure, 3-6

FDS_CLASS, 4-13

FDS_CLASS_VERSION, 4-13

FDS_INST_NAME, 4-14

FETCH_ROW procedure, 3-7

executing queries using pass-through SQL, 3-11

fetches

bulk, 4-8

optimizing round-trips, 3-12

Gateway

how it works, 2-8

remote data access, 1-5

two-phase commit, 1-6

generic connectivity

architecture, 7-3

Oracle and non-Oracle on same machine, 7-4

Oracle and non-Oracle on separate machines, 7-3

configuration, 7-8

creating initialization file, 7-8

data dictionary

translation support, D-1

definition, 7-2

DELETE statement, 7-7

editing initialization file, 7-8

error tracing, A-6

Heterogeneous Services, 2-4

INSERT statement, 7-7

non-Oracle data dictionary access, D-1

ODBC connectivity requirements, 7-13

OLE DB (FS) connectivity requirements, 7-16

OLE DB (SQL) connectivity requirements, 7-15

restrictions, 7-6

setting parameters for ODBC source, 7-10

UNIX, 7-11

Windows NT, 7-10

setting parameters for OLE DB source, 7-12

SQL execution, 7-6

supported functions, 7-7

supported SQL syntax, 7-7

types of agents, 7-2

UPDATE statement, 7-7

GET_VALUE procedure, 3-7, 3-10

heterogeneous distributed systems

accessing, 4-2

Heterogeneous Services

agent registration, 4-11

avoiding configuration mismatches, 4-12

disabling, 4-15

enabling, 4-11

agents

self-registration, 4-13

application development

controlling array fetches between non-Oracle server and agent, 4-9

controlling array fetches between Oracle server and agent, 4-9

controlling reblocking of array fetches, 4-9

DBMS_HS_PASSTHOUGH package, 3-5

pass-through SQL, 3-5

using bulk fetches, 4-8

using OCI for bulk fetches, 4-9

creating database links, 4-4

data dictionary views, 4-22, D-2

types, 4-22

understanding sources, 4-23

using general views, 4-24

using SQL service views, 4-26

using transaction service views, 4-25

defining maximum number of open cursors, A-10

dynamic performance views, 4-28

V$HS_AGENT view, 4-28

V$HS_SESSION view, 4-28

generic connectivity

architecture, 7-3

creating initialization file, 7-8

definition, 7-2

editing initialization file, 7-8

non-Oracle data dictionary access, D-1

ODBC connectivity requirements, 7-13

OLE DB (FS) connectivity requirements, 7-16

OLE DB (SQL) connectivity requirements, 7-15

restrictions, 7-6

setting parameters for ODBC source, 7-10

setting parameters for OLE DB source, 7-12

SQL execution, 7-6

supported functions, 7-7

supported SQL syntax, 7-7

supported tables, D-5

types of agents, 7-2

installing data dictionary, 4-2

optimizing data transfer, A-11

setting global name, A-4

setting up access using transparent gateway, 4-2

setting up environment, 4-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-3

SQL service, 2-5

testing connections, 4-4

transaction service, 2-4

tuning internal data buffering, A-11

HS_AUTOREGISTER initialization parameter

using to enable agent self-registration, 4-14

HS_BASE_CAPS view, 4-23

HS_BASE_DD view, 4-23

HS_CLASS_CAPS view, 4-23

HS_CLASS_DD view, 4-23

HS_CLASS_INIT view, 4-23

HS_COMMIT_POINT_STRENGTH initialization parameter, A-3

HS_DB_DOMAIN initialization parameter, A-3

HS_DB_INTERNAL_NAME initialization parameter, A-3

HS_DB_NAME initialization parameter, A-4

HS_DESCRIBE_CACHE_HWM initialization parameter, A-4

HS_FDS_CLASS view, 4-23

HS_FDS_CONNECT_INFO initialization parameter, A-4

specifying connection information, 7-9

HS_FDS_FETCH_ROWS initialization parameter, 4-9

HS_FDS_INST view, 4-23

HS_FDS_SHAREABLE_NAME initialization parameter, A-6

HS_FDS_TRACE initialization parameter, A-6

HS_FDS_TRACE_LEVEL initialization parameter

enabling agent tracing, 7-9

HS_LANGUAGE initialization parameter, A-6

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-10

HS_ROWID_CACHE_SIZE initialization parameter, A-10

HS_RPC_FETCH_REBLOCKING initialization parameter, 4-10, A-11

HS_RPC_FETCH_SIZE initialization parameter, 4-9, A-11

IFILE, A-12

listeners, 4-2

multiple rows

buffering, 3-12

National Language Support (NLS)

Heterogeneous Services, A-6

character set of non-Oracle source, A-9

date format, A-8

languages in character date values, A-8

OCI

optimizing data transfers using, 4-9

ODBC agents

connectivity requirements, 7-13

functions, 7-13

ODBC connectivity

data dictionary mapping, D-7

ODBC driver, 7-13

requirements, 7-13

specifying connection information

UNIX, A-5

Windows NT, A-5

specifying path to library, A-6

OLE DB (FS) drivers, 7-16

OLE DB (SQL) drivers, 7-15

OLE DB agents

connectivity requirements, 7-15, 7-16

OLE DB connectivity

data dictionary mapping, D-7

setting connection information, A-5

OLE DB drivers

data provider requirements, 7-16

initialization properties, 7-18

rowset properties, 7-18

OPEN_CURSOR procedure, 3-6

operating system dependencies, C-1

Oracle database server

SQL construct processing, 4-16

Oracle Net Services listener, 2-3, 4-2

Oracle precompiler

optimizing data transfers using, 4-9

OUT bind variables, 3-10

PARSE procedure, 3-6

pass-through SQL

avoiding SQL interpretation, 3-5

executing statements, 3-6

non-queries, 3-7

queries, 3-11

with bind variables, 3-8

with IN bind variables, 3-9

with IN OUT bind variables, 3-10

with OUT bind variables, 3-10

implications of using, 3-6

overview, 3-5

restrictions, 3-6

queries

pass-through SQL, 3-11

reblocking, 4-9

rows

buffering multiple, 3-12

SELECT statement

accessing non-Oracle system, D-1

service names

specifying in database links, 4-4

SQL capabilities

data dictionary tables, 4-26

SQL service

data dictionary views, 2-8, 4-22

Heterogeneous Services, 2-5

views

Heterogeneous Services, 4-26

Synonyms, 4-17

transaction service

Heterogeneous Services, 2-4

views

Heterogeneous Services, 4-25

transparent gateways

accessing Heterogeneous Services agents, 4-2

creating database links, 4-4

installing Heterogeneous Services data dictionary, 4-2

testing connections, 4-4

Two-phase commit, 1-6

unsupported functions

generic connectivity, 7-7

V$HS_AGENT view

determining which agents are on host, 4-28

V$HS_PARAMETER view

listing HS parameters, 4-29

V$HS_SESSION view

determining open sessions, 4-29

variables

bind, 3-7