Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Documentation Accessibility

Organization

Related Documentation

Conventions

1 Introduction

1.1 Overview

1.2 Heterogeneous Services Technology

1.3 Oracle Transparent Gateways

2 Configuring the Gateway

2.1 Configuring the Gateway

2.1.1 Task 1: Choose a System Identifier for the Gateway

2.1.2 Task 2: Customize the Initialization Parameter File

2.2 Configuring Oracle Net Services Listener for the Gateway

2.2.1 Task 1: Configure Oracle Net Services TNS Listener for the Gateway

2.2.1.1 Example of Address to Listen On in listener.ora File

2.2.1.2 Example of Gateway to Start in listener.ora File

2.2.2 Task 2: Stop and Start the TNS Listener for the Gateway

2.3 Configuring the Oracle Database Server for Gateway Access

2.3.1 Configuring Oracle Net Services for the Oracle Database Server

2.3.1.1 Configuring tnsnames.ora

2.4 Creating Database Links

2.5 Gateway Password Encryption Tool

2.6 Configuring the Gateway for Multiple Informix Databases

2.6.1 Multiple Databases Example: Configuring the Gateway

2.6.2 Multiple Databases Example: Configuring the Informix Environment

2.6.3 Multiple Databases Example: Configuring Oracle Net Services Listener

2.6.4 Multiple Databases Example: Stopping and Starting the TNS Listener

2.6.5 Multiple Databases Example: Configuring for Gateway Access

2.6.5.1 Configuring Oracle Net Services for Multiple Gateway Instances

2.6.6 Multiple Databases Example: Accessing Informix Data

2.7 Performing Configuration Tasks

2.7.1 Configuring for Two-Phase Commit

2.7.1.1 Task 1: Create a Recovery Account and Password

2.7.1.2 Task 2: Create the Transaction Log Table

3 Informix Gateway Features and Restrictions

3.1 Using the Pass-Through Feature

3.2 Database Compatibility Issues for Informix

3.2.1 ANSI SQL Standard

3.2.2 Naming Rules

3.2.2.1 Rules for Naming Objects

3.2.2.2 Object Names

3.2.2.3 Case Sensitivity

3.2.3 Data Types

3.2.3.1 Binary, Byte and Text Literal Notation

3.2.3.2 Data Type Conversion

3.2.4 Queries

3.2.4.1 Row Selection

3.2.4.2 Empty Strings

3.2.4.3 Empty Bind Variables

3.2.5 Locking

3.3 Known Restrictions

3.3.1 Transactional Integrity

3.3.2 Transaction Capability

3.3.3 COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors

3.3.4 Pass-Through Feature

3.3.5 Informix SMALLFLOAT and REAL Data Types

3.3.6 Informix NCHAR and NVARCHAR Data Types

3.3.7 SQL Syntax

3.3.7.1 WHERE CURRENT OF Clause

3.3.7.2 CONNECT BY Clause

3.3.7.3 Use of NULL Keyword in SELECT Statement

3.3.7.4 Subqueries in INSERT Statement

3.3.7.5 Subqueries in DELETE, INSERT, and UPDATE Statements

3.3.7.6 ROWID

3.3.7.7 EXPLAIN PLAN Statement

3.3.8 SQL*Plus

3.3.9 Database Links

3.3.10 Gateway Data Dictionary Views

3.3.11 Stored Procedures

3.4 Known Problems

3.4.1 Encrypted Format Login

3.4.2 Informix BYTE and TEXT Data Types

3.4.3 Schema Names and PL/SQL

3.4.4 Data Dictionary Views and PL/SQL

4 Case Studies

4.1 Case Descriptions

4.2 CD-ROM Contents

4.3 Demonstration Files

4.4 Demonstration Requirements

4.5 Creating Demonstration Tables

4.5.1 Demonstration Table Definitions

4.5.2 Demonstration Table Contents

4.6 Case 1: Simple Queries

4.7 Case 2: A More Complex Query

4.8 Case 3: Joining Informix Tables

4.9 Case 4: Write Capabilities

4.9.1 DELETE Statement

4.9.2 UPDATE Statement

4.9.3 INSERT Statement

4.10 Case 5: Data Dictionary Query

4.11 Case 6: The Pass-Through Feature

4.11.1 UPDATE Statement

4.11.2 SELECT Statement

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 Informix

B.2.2 Functions Supported by Informix

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

B.2.2.6 Date Functions

B.2.2.7 Other Functions

B.2.3 Functions Supported by the Gateway

C Data Dictionary

C.1 Data Dictionary Support

C.1.1 Informix System Catalog Tables

C.1.2 Accessing the Gateway Data Dictionary

C.1.3 Direct Queries to Informix 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 Heterogeneous Services Initialization Parameters

D.1 HS Initialization Parameter File Syntax

D.2 HS_FDS_CONNECT_INFO

D.3 HS_FDS_PARSER_TOKEN_SIZE

D.4 HS_FDS_RECOVERY_ACCOUNT

D.5 HS_FDS_RECOVERY_PWD

D.6 HS_FDS_TRACE_LEVEL

D.7 HS_FDS_TRANSACTION_LOG

D.8 HS_FDS_TRANSACTION_MODEL

Index