Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

1 Introduction

• Overview
• Heterogeneous Services Technology
• Oracle Database Gateways

2 Informix Gateway Features and Restrictions

• Using the Pass-Through Feature
• CHAR Semantics
• Multi-byte Character Sets Ratio Suppression
• IPv6 Support
• Gateway Session IDLE Timeout
• Database Compatibility Issues for Informix
  • ANSI SQL Standard
  • Naming Rules
    • Rules for Naming Objects
    • Object Names
    • Case Sensitivity
  • Data Types
    • Binary, Byte and Text 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
  • Pass-Through Feature
  • Informix SMALLFLOAT and REAL Data Types
  • SQL Syntax
    • WHERE CURRENT OF Clause
    • CONNECT BY Clause
    • Use of NULL Keyword in SELECT Statement
    • Subqueries in INSERT Statement
    • Subqueries in DELETE, INSERT, and UPDATE Statements
    • ROWID
    • EXPLAIN PLAN Statement
    • Callback Support
  • SQL*Plus
  • Database Links
  • Gateway Data Dictionary Views
  • Stored Procedures
  • CALLBACK links
• Known Problems
  • Encrypted Format Login
  • Informix BYTE and TEXT Data Types
  • Schema Names and PL/SQL
  • Data Dictionary Views and PL/SQL

3 Case Studies

• Case Descriptions
• Distribution Media 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 Informix 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

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 Informix
  • Functions Supported by Informix
    • Arithmetic Operators
    • Comparison Operators
    • Group Functions
    • String Functions
    • Pattern Matches
    • Date Functions
    • Other Functions
  • Functions Supported by the Gateway

C Data Dictionary

• Data Dictionary Support
  • Informix System Catalog Tables
  • Accessing the Gateway Data Dictionary
  • Direct Queries to Informix Tables
  • Supported Views and Tables
• Data Dictionary Mapping
  • Default Column Values
• Gateway Data Dictionary Descriptions

D Initialization Parameters

• Initialization Parameter File Syntax
• Oracle Database Gateway for Informix Initialization Parameters
• Initialization Parameter Description
  • 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_TIMESTAMP_MAPPING
  • HS_FDS_DATE_MAPPING
  • HS_FDS_CONNECT_INFO
  • HS_FDS_RECOVERY_ACCOUNT
  • HS_FDS_RECOVERY_PWD
  • HS_FDS_TRACE_LEVEL
  • HS_FDS_TRANSACTION_LOG
  • HS_FDS_FETCH_ROWS
  • HS_IDLE_TIMEOUT
  • HS_NLS_LENGTH_SEMANTICS
  • HS_KEEP_REMOTE_COLUMN_SIZE
  • HS_FDS_REMOTE_DB_CHARSET
  • HS_FDS_SUPPORT_STATISTICS
  • HS_FDS_SQLLEN_INTERPRETATION
  • HS_FDS_ARRAY_EXEC

Index