1/12

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