Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• 1.1 Overview
• 1.2 Heterogeneous Services Technology
• 1.3 Oracle Database Gateways

2 Sybase Gateway Features and Restrictions

• 2.1 Using the Pass-Through Feature
• 2.2 Executing Stored Procedures and Functions
  • 2.2.1 Return Values and Stored Procedures
  • 2.2.2 Result Sets and Stored Procedures
    • 2.2.2.1 OCI Program Fetching from Result Sets in Sequential Mode
    • 2.2.2.2 PL/SQL Program Fetching from Result Sets in Sequential Mode
• 2.3 CHAR Semantics
• 2.4 Multi-byte Character Sets Ratio Suppression
• 2.5 IPv6 Support
• 2.6 Gateway Session IDLE Timeout
• 2.7 Database Compatibility Issues for Sybase
  • 2.7.1 Chained Mode
  • 2.7.2 Column Definitions
  • 2.7.3 Naming Rules
    • 2.7.3.1 Rules for Naming Objects
    • 2.7.3.2 Case Sensitivity
  • 2.7.4 Data Types
    • 2.7.4.1 Binary Literal Notation
    • 2.7.4.2 Data Type Conversion
  • 2.7.5 Queries
    • 2.7.5.1 Row Selection
    • 2.7.5.2 Empty Strings
    • 2.7.5.3 Empty Bind Variables
  • 2.7.6 Locking
  • 2.7.7 Sybase Identifiers Length Limit
• 2.8 Known Restrictions
  • 2.8.1 Transactional Integrity
  • 2.8.2 Transaction Capability
  • 2.8.3 COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
  • 2.8.4 Stored Procedures
  • 2.8.5 Pass-Through Feature
  • 2.8.6 Sybase NCHAR and NVARCHAR Data Types
  • 2.8.7 SQL Syntax
    • 2.8.7.1 WHERE CURRENT OF Clause
    • 2.8.7.2 CONNECT BY Clause
    • 2.8.7.3 ROWID
    • 2.8.7.4 Subqueries in INSERT Statement
    • 2.8.7.5 EXPLAIN PLAN Statement
    • 2.8.7.6 Callback Support
  • 2.8.8 SQL*Plus COPY Command with Lowercase Table Names
  • 2.8.9 Database Links
  • 2.8.10 CALLBACK links
• 2.9 Known Problems
  • 2.9.1 Encrypted Format Login
  • 2.9.2 Date Arithmetic
  • 2.9.3 Sybase IMAGE and TEXT Data Type
  • 2.9.4 String Functions
  • 2.9.5 Schema Names and PL/SQL
  • 2.9.6 Data Dictionary Views and PL/SQL
  • 2.9.7 Stored Procedures

3 Case Studies

• 3.1 Case Descriptions
• 3.2 Distribution Media Contents
• 3.3 Demonstration Files
• 3.4 Demonstration Requirements
• 3.5 Creating Demonstration Tables
  • 3.5.1 Demonstration Table Definitions
  • 3.5.2 Demonstration Table Contents
• 3.6 Case 1: Simple Queries
• 3.7 Case 2: A More Complex Query
• 3.8 Case 3: Joining Sybase Tables
• 3.9 Case 4: Write Capabilities
  • 3.9.1 DELETE Statement
  • 3.9.2 UPDATE Statement
  • 3.9.3 INSERT Statement
• 3.10 Case 5: Data Dictionary Query
• 3.11 Case 6: The Pass-Through Feature
  • 3.11.1 UPDATE Statement
  • 3.11.2 SELECT Statement
• 3.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 DELETE
  • B.1.2 INSERT
  • B.1.3 SELECT
  • B.1.4 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 Initialization Parameters

• D.1 Initialization Parameter File Syntax
• D.2 Oracle Database Gateway for Sybase Initialization Parameters
• D.3 Initialization Parameter Description
  • D.3.1 HS_CALL_NAME
  • D.3.2 HS_DB_DOMAIN
  • D.3.3 HS_DB_INTERNAL_NAME
  • D.3.4 HS_DB_NAME
  • D.3.5 HS_DESCRIBE_CACHE_HWM
  • D.3.6 HS_LANGUAGE
    • D.3.6.1 Character Sets
    • D.3.6.2 Language
    • D.3.6.3 Territory
  • D.3.7 HS_LONG_PIECE_TRANSFER_SIZE
  • D.3.8 HS_OPEN_CURSORS
  • D.3.9 HS_RPC_FETCH_REBLOCKING
  • D.3.10 HS_RPC_FETCH_SIZE
  • D.3.11 HS_TIME_ZONE
  • D.3.12 HS_TRANSACTION_MODEL
  • D.3.13 IFILE
  • D.3.14 HS_FDS_CONNECT_INFO
  • D.3.15 HS_FDS_DEFAULT_OWNER
  • D.3.16 HS_FDS_PROC_IS_FUNC
  • D.3.17 HS_FDS_RECOVERY_ACCOUNT
  • D.3.18 HS_FDS_RECOVERY_PWD
  • D.3.19 HS_FDS_RESULTSET_SUPPORT
  • D.3.20 HS_FDS_TRACE_LEVEL
  • D.3.21 HS_FDS_TRANSACTION_LOG
  • D.3.22 HS_FDS_FETCH_ROWS
  • D.3.23 HS_FDS_QUOTE_IDENTIFIER
  • D.3.24 HS_IDLE_TIMEOUT
  • D.3.25 HS_NLS_LENGTH_SEMANTICS
  • D.3.26 HS_KEEP_REMOTE_COLUMN_SIZE
  • D.3.27 HS_FDS_REMOTE_DB_CHARSET
  • D.3.28 HS_FDS_SUPPORT_STATISTICS
  • D.3.29 HS_FDS_RSET_RETURN_ROWCOUNT
  • D.3.30 HS_FDS_SQLLEN_INTERPRETATION
  • D.3.31 HS_FDS_REPORT_REAL_AS_DOUBLE

Index