Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Related Documentation

Conventions

1 Introduction

1.1 Overview

1.2 Heterogeneous Services Technology

1.3 Oracle Transparent Gateways

2 Configuring the Gateway

2.1 Configuring the Gateway

2.1.1 Task 1: Choose a System Identifier for the Gateway

2.1.2 Task 2: Customize the Initialization Parameter File

2.2 Configuring Oracle Net Services Listener for the Gateway

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

2.2.1.1 Example of Address to Listen On in listener.ora File

2.2.1.2 Example of Gateway to Start in listener.ora File

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

2.3 Configuring the Oracle Database Server for Gateway Access

2.3.1 Configuring Oracle Net Services for the Oracle Database Server

2.3.1.1 Configuring tnsnames.ora

2.4 Creating Database Links

2.5 Gateway Password Encryption Tool

2.6 Configuring the Gateway for Multiple Sybase Databases

2.6.1 Multiple Databases Example: Configuring the Gateway

2.6.2 Multiple Databases Example: Configuring the Sybase Environment

2.6.3 Multiple Databases Example: Configuring Oracle Net Services Listener

2.6.4 Multiple Databases Example: Stopping and Starting the TNS Listener

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

2.6.6 Multiple Databases Example: Accessing Sybase Data

2.7 Performing Configuration Tasks

2.7.1 Configuring for Two-Phase Commit

2.7.1.1 Task 1: Create a Recovery Account and Password

2.7.1.2 Task 2: Create the Transaction Log Table

2.7.2 Specifying an Owner

3 Sybase Gateway Features and Restrictions

3.1 Using the Pass-Through Feature

3.2 Executing Stored Procedures and Functions

3.2.1 Return Values and Stored Procedures

3.2.2 Result Sets and Stored Procedures

3.2.2.1 OCI Program Fetching from Result Sets in Sequential Mode

3.2.2.2 PL/SQL Program Fetching from Result Sets in Sequential Mode

3.3 Database Compatibility Issues for Sybase

3.3.1 Chained Mode

3.3.2 Column Definitions

3.3.3 Naming Rules

3.3.3.1 Rules for Naming Objects

3.3.3.2 Case Sensitivity

3.3.4 Data Types

3.3.4.1 Binary Literal Notation

3.3.4.2 Data Type Conversion

3.3.5 Queries

3.3.5.1 Row Selection

3.3.5.2 Empty Strings

3.3.5.3 Empty Bind Variables

3.3.6 Locking

3.4 Known Restrictions

3.4.1 Transactional Integrity

3.4.2 Transaction Capability

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

3.4.4 Stored Procedures

3.4.5 Pass-Through Feature

3.4.6 Sybase NCHAR and NVARCHAR Data Types

3.4.7 SQL Syntax

3.4.7.1 WHERE CURRENT OF Clause

3.4.7.2 CONNECT BY Clause

3.4.7.3 ROWID

3.4.7.4 Subqueries in INSERT Statement

3.4.7.5 EXPLAIN PLAN Statement

3.4.8 SQL*Plus COPY Command with Lowercase Table Names

3.4.9 Database Links

3.5 Known Problems

3.5.1 FLOAT Data Type

3.5.2 VARBINARY Data Type

3.5.3 Encrypted Format Login

3.5.4 Date Arithmetic

3.5.5 Sybase IMAGE and TEXT Data Type

3.5.6 String Functions

3.5.7 Schema Names and PL/SQL

3.5.8 Data Dictionary Views and PL/SQL

3.5.9 Stored Procedures

4 Case Studies

4.1 Case Descriptions

4.2 CD-ROM Contents

4.3 Demonstration Files

4.4 Demonstration Requirements

4.5 Creating Demonstration Tables

4.5.1 Demonstration Table Definitions

4.5.2 Demonstration Table Contents

4.6 Case 1: Simple Queries

4.7 Case 2: A More Complex Query

4.8 Case 3: Joining Sybase Tables

4.9 Case 4: Write Capabilities

4.9.1 DELETE Statement

4.9.2 UPDATE Statement

4.9.3 INSERT Statement

4.10 Case 5: Data Dictionary Query

4.11 Case 6: The Pass-Through Feature

4.11.1 UPDATE Statement

4.11.2 SELECT Statement

4.12 Case 7: Executing Stored Procedures

A Data Type Conversion

A.1 Data Type Conversion

B Supported SQL Syntax and Functions

B.1 Supported SQL Statements

B.1.1 INSERT

B.1.2 SELECT

B.1.3 UPDATE

B.2 Oracle Functions

B.2.1 Functions Not Supported by Sybase

B.2.2 Functions Supported by Sybase

B.2.2.1 Arithmetic Operators

B.2.2.2 Comparison Operators

B.2.2.3 Group Functions

B.2.2.4 String Functions

B.2.2.5 Other Functions

C Data Dictionary

C.1 Data Dictionary Support

C.1.1 Sybase System Tables

C.1.2 Accessing the Gateway Data Dictionary

C.1.3 Direct Queries to Sybase Tables

C.1.4 Supported Views and Tables

C.2 Data Dictionary Mapping

C.2.1 Default Column Values

C.3 Gateway Data Dictionary Descriptions

D Heterogeneous Services Initialization Parameters

D.1 HS Initialization Parameter File Syntax

D.2 HS_FDS_CONNECT_INFO

D.3 HS_FDS_DEFAULT_OWNER

D.4 HS_FDS_PARSER_TOKEN_SIZE

D.5 HS_FDS_PROC_IS_FUNC

D.6 HS_FDS_RECOVERY_ACCOUNT

D.7 HS_FDS_RECOVERY_PWD

D.8 HS_FDS_RESULTSET_SUPPORT

D.9 HS_FDS_TRACE_LEVEL

D.10 HS_FDS_TRANSACTION_LOG

D.11 HS_FDS_TRANSACTION_MODEL

Index