Go to main content
1/14
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
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
Scripting on this page enhances content navigation, but does not change the content in any way.