Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Related Documents

Conventions

1 Introduction

Overview

Heterogeneous Services Technology

Oracle Transparent Gateways

2 Configuring the Gateway

Configuring the Gateway

Task 1: Choose a System Identifier for the Gateway

Task 2: Customize the Initialization Parameter File

Configuring Oracle Net Services Listener for the Gateway

Task 1: Configure Oracle Net Services TNS Listener for the Gateway

Example of Address to Listen On in listener.ora File

Example of Gateway to Start in listener.ora File

Task 2: Stop and Start the TNS Listener for the Gateway

Configuring the Oracle Database Server for Gateway Access

Configuring Oracle Net Services for the Oracle Database Server

Configuring tnsnames.ora

Creating Database Links

Gateway Password Encryption Tool

Configuring the Gateway for Multiple Sybase Databases

Multiple Databases Example: Configuring the Gateway

Multiple Databases Example: Configuring the Sybase Environment

Multiple Databases Example: Configuring Oracle Net Services Listener

Multiple Databases Example: Stopping and Starting the TNS Listener

Multiple Databases Example: Configuring the Oracle Database Server for Gateway Access

Configuring Oracle Net Services on the Oracle Database Server for Multiple Gateway Instances

Multiple Databases Example: Accessing Sybase Data

Performing Configuration Tasks

Configuring for Two-Phase Commit

Task 1: Create a Recovery Account and Password

Task 2: Create the Transaction Log Table

Specifying an Owner

3 Sybase Gateway Features and Restrictions

Using the Pass-Through Feature

Executing Stored Procedures and Functions

Return Values and Stored Procedures

Result Sets and Stored Procedures

OCI Program Fetching from Result Sets in Sequential Mode

PL/SQL Program Fetching from Result Sets in Sequential Mode

Database Compatibility Issues for Sybase

Chained Mode

Column Definitions

Naming Rules

Rules for Naming Objects

Case Sensitivity

Data Types

Binary Literal Notation

Data Type Conversion

Queries

Row Selection

Empty Strings

Empty Bind Variables

Locking

Known Restrictions

Transactional Integrity

Transaction Capability

COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors

Stored Procedures

Pass-Through Feature

Sybase NCHAR and NVARCHAR Data Types

SQL Syntax

WHERE CURRENT OF Clause

CONNECT BY Clause

ROWID

Subqueries in INSERT Statement

EXPLAIN PLAN Statement

SQL*Plus COPY Command with Lowercase Table Names

Database Links

Known Problems

FLOAT Data Type

VARBINARY Data Type

Encrypted Format Login

Date Arithmetic

Sybase IMAGE and TEXT Data Type

String Functions

Schema Names and PL/SQL

Data Dictionary Views and PL/SQL

Stored Procedures

4 Case Studies

Case Descriptions

CD-ROM Contents

Demonstration Files

Demonstration Requirements

Creating Demonstration Tables

Demonstration Table Definitions

Demonstration Table Contents

Case 1: Simple Queries

Case 2: A More Complex Query

Case 3: Joining Sybase Tables

Case 4: Write Capabilities

DELETE Statement

UPDATE Statement

INSERT Statement

Case 5: Data Dictionary Query

Case 6: The Pass-Through Feature

UPDATE Statement

SELECT Statement

Case 7: Executing Stored Procedures

A Data Type Conversion

Data Type Conversion

B Supported SQL Syntax and Functions

Supported SQL Statements

DELETE

INSERT

SELECT

UPDATE

Oracle Functions

Functions Not Supported by Sybase

Functions Supported by Sybase

Arithmetic Operators

Comparison Operators

Group Functions

String Functions

Other Functions

C Data Dictionary

Data Dictionary Support

Sybase System Tables

Accessing the Gateway Data Dictionary

Direct Queries to Sybase Tables

Supported Views and Tables

Data Dictionary Mapping

Default Column Values

Gateway Data Dictionary Descriptions

D Heterogeneous Services Initialization Parameters

HS Initialization Parameter File Syntax

HS_FDS_CONNECT_INFO

HS_FDS_DEFAULT_OWNER

HS_FDS_PARSER_TOKEN_SIZE

HS_FDS_PROC_IS_FUNC

HS_FDS_RECOVERY_ACCOUNT

HS_FDS_RECOVERY_PWD

HS_FDS_RESULTSET_SUPPORT

HS_FDS_TRACE_LEVEL

HS_FDS_TRANSACTION_LOG

HS_FDS_TRANSACTION_MODEL

Index