Skip Headers
Oracle® Transparent Gateway for Informix Administrator's Guide
10g Release 2 (10.2) for Solaris Operating System (SPARC)

Part Number B14275-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to next page
Next
PDF · Mobi · ePub

Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

Audience
Documentation Accessibility
Related Documents
Conventions

1 Introduction

Overview
Heterogeneous Services Technology
Oracle Transparent Gateways

2 Configuring the Gateway

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 Net Services for the Oracle Database Server
Configuring tnsnames.ora
Creating Database Links
Gateway Password Encryption Tool
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 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

3 Informix Gateway Features and Restrictions

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
Pass-Through Feature
Informix SMALLFLOAT and REAL Data Types
Informix NCHAR and NVARCHAR 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
SQL*Plus
Database Links
Gateway Data Dictionary Views
Stored Procedures
Known Problems
Encrypted Format Login
Informix BYTE and TEXT Data Types
Schema Names and PL/SQL
Data Dictionary Views and PL/SQL

4 Case Studies

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

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 Heterogeneous Services Initialization Parameters

HS Initialization Parameter File Syntax
HS_FDS_CONNECT_INFO
HS_FDS_PARSER_TOKEN_SIZE
HS_FDS_RECOVERY_ACCOUNT
HS_FDS_RECOVERY_PWD
HS_FDS_TRACE_LEVEL
HS_FDS_TRANSACTION_LOG
HS_FDS_TRANSACTION_MODEL

Index