Oracle Heterogeneous Services Release 8.1.7 Part Number A88714-01 |
Library | Service | Contents

# 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

| Copyright © 1996-2001 Oracle Corporation. All Rights Reserved. |
Library | Service | Contents