Contents

Title and Copyright Information

Send Us Your Comments

Preface

Introduction 1-1

Overview

Heterogeneous Services Technology

Oracle Transparent Gateways

Configuring the Gateway 2-1

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 Oracle Net Services for the Oracle Database Server

Configuring tnsnames.ora

Creating Database Links

Configuring the Gateway for Multiple Informix Databases

Multiple Databases Example: Configuring the Gateway

Multiple Databases Example: Configuring the Informix Environment

Multiple Databases Example: Configuring Oracle Oracle Net Services Listener

Multiple Databases Example: Stopping and Starting the TNS Listener

Multiple Databases Example: Configuring the Oracle Database Server for Gateway Access

Configuring Oracle Net Services on the Oracle Database Server for Multiple Gateway Instances

Multiple Databases Example: Accessing Informix Data

Performing Configuration Tasks

Configuring for Two-Phase Commit

Task 1: Create a Recovery Account and Password

Task 2: Create the Transaction Log Table

Informix Gateway Features and Restrictions 3-1

Using the Pass-Through Feature

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

ROWID Restrictions

Pass-Through Feature

Informix SMALLFLOAT and REAL Data Types

Informix INTERVAL, NCHAR and NVARCHAR Data Types

SQL Syntax

CONNECT BY Clause

Use of NULL Keyword in SELECT Statement

FOR UPDATE OF Clause

Subqueries in UPDATE Statement

Subqueries in INSERT Statement

Subqueries in DELETE, INSERT, and UPDATE Statements

SQL*Plus

Database Links

Stored Procedures

Known Problems

Encrypted Format Login

Aggregate Function with CREATE TABLE or CREATE VIEW Statement

Informix BYTE and TEXT Data Types

Schema Names and PL/SQL

Data Dictionary Views and PL/SQL

Case Studies 4-1

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 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

Data Type Conversion A-1

Data Type Conversion

Supported SQL Syntax and Functions B-1

Supported SQL Statements

DELETE

INSERT

SELECT

UPDATE

Oracle Functions

Functions Not Supported by Informix

Functions Supported by Informix

Arithmetic Operators

Comparison Operators

String Functions

Group Functions

Pattern Matches

Date Functions

Other Functions

Functions Supported by the Gateway

Data Dictionary C-1

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

Heterogeneous Services Initialization Parameters D-1

Initialization Parameter File Syntax

HS_FDS_CONNECT_INFO

HS_FDS_RECOVERY_ACCOUNT

HS_FDS_RECOVERY_PWD

HS_FDS_TRACE_LEVEL

HS_FDS_TRANSACTION_MODEL