Table of Contents

• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Related Documents
  • Conventions
• 1 Introduction to the Oracle Database Gateway for Sybase
  • Overview of Oracle Database Gateways
  • About Heterogeneous Services Technology
  • About Oracle Database Gateway for Sybase
• 2 Sybase Gateway Features and Restrictions
  • Remote Insert Rowsource
  • 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
  • CHAR Semantics
  • Multi-byte Character Sets Ratio Suppression
  • IPv6 Support
  • Gateway Session IDLE Timeout
  • 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
    • Sybase Identifiers Length Limit
  • 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
    • 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
• 3 Case Studies
  • Case Descriptions
  • Distribution Media Contents
  • Accessing the 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
• 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
  • 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
  • ALL_CATALOG
  • ALL_COL_COMMENTS
  • ALL_CONS_COLUMNS
  • ALL_CONSTRAINTS
  • ALL_IND_COLUMNS
  • ALL_INDEXES
  • ALL_OBJECTS
  • ALL_TAB_COLUMNS
  • ALL_TAB_COMMENTS
  • ALL_TABLES
  • ALL_USERS
  • ALL_VIEWS
  • DBA_CATALOG
  • DBA_COL_COMMENTS
  • DBA_OBJECTS
  • DBA_TAB_COLUMNS
  • DBA_TAB_COMMENTS
  • DBA_TABLES
  • DICT_COLUMNS
  • DICTIONARY
  • DUAL
  • TABLE_PRIVILEGES
  • USER_CATALOG
  • USER_COL_COMMENTS
  • USER_CONS_COLUMNS
  • USER_CONSTRAINTS
  • USER_IND_COLUMNS
  • USER_INDEXES
  • USER_OBJECTS
  • USER_TAB_COLUMNS
  • USER_TAB_COMMENTS
  • USER_TABLES
  • USER_USERS
  • USER_VIEWS
• D Initialization Parameters
  • Initialization Parameter File Syntax
  • Oracle Database Gateway for Sybase Initialization Parameters
    • HS_CALL_NAME
    • HS_DB_DOMAIN
    • HS_DB_INTERNAL_NAME
    • HS_DB_NAME
    • HS_DESCRIBE_CACHE_HWM
    • HS_LANGUAGE
      • Character Sets
      • Language
      • Territory
    • HS_LONG_PIECE_TRANSFER_SIZE
    • HS_OPEN_CURSORS
    • HS_RPC_FETCH_REBLOCKING
    • HS_RPC_FETCH_SIZE
    • HS_TIME_ZONE
    • HS_TRANSACTION_MODEL
    • IFILE
    • HS_FDS_VALIDATE_SERVER_CERT
    • HS_FDS_ENCRYPT_SESSION
    • HS_FDS_TRUSTSTORE_FILE
    • HS_FDS_TRUSTSTORE_PASSWORD
    • HS_FDS_TRANSACTION_ISOLATION
    • HS_FDS_TIMESTAMP_MAPPING
    • HS_FDS_DATE_MAPPING
    • HS_FDS_CONNECT_INFO
    • 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_FETCH_ROWS
    • HS_FDS_QUOTE_IDENTIFIER
    • HS_IDLE_TIMEOUT
    • HS_NLS_LENGTH_SEMANTICS
    • HS_KEEP_REMOTE_COLUMN_SIZE
    • HS_FDS_REMOTE_DB_CHARSET
    • HS_FDS_SUPPORT_STATISTICS
    • HS_FDS_RSET_RETURN_ROWCOUNT
    • HS_FDS_SQLLEN_INTERPRETATION
    • HS_FDS_REPORT_REAL_AS_DOUBLE
    • HS_FDS_ARRAY_EXEC
• Index