Skip Headers
Oracle® Transparent Gateway for Sybase Administrator's Guide
10g Release 2 (10.2) for HP Tru64 UNIX

Part Number B14285-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to next page
Next
PDF · Mobi · ePub

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