Contents

Title and Copyright Information

Send Us Your Comments

Preface

Documentation Accessibility

Related Documents

1 Introduction

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 Ingres II Databases

2.6.1 Multiple Databases Example: Configuring the Gateway

2.6.2 Multiple Databases Example: Configuring the Ingres II 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 the Oracle Database Server for Gateway Access

2.6.6 Multiple Databases Example: Accessing Ingres II Data

3 Ingres II Gateway Features and Restrictions

3.1 Using the Pass-Through Feature

3.2 Database Compatibility Issues for Ingres II

3.2.1 Naming Rules

3.2.1.1 Rules for Naming Objects

3.2.1.2 Object Names

3.2.1.3 Case Sensitivity

3.2.2 Data Types

3.2.2.1 Ingres II Date Limit

3.2.2.2 Default Date Values

3.2.2.3 Data Type Conversion

3.2.3.1 Empty Strings

3.2.3.2 Empty Bind Variables

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 LONG BYTE and LONG VARCHAR Data Types

3.3.6 SQL Syntax

3.3.6.1 WHERE CURRENT OF Clause

3.3.6.2 CONNECT BY Clause

3.3.6.4 EXPLAIN PLAN Statement

3.3.7 SQL*Plus COPY Command with Lowercase Table Names

3.3.8 Database Links

3.3.9 Stored Procedures

3.4 Known Problems

3.4.1 Encrypted Format Login

3.4.2 Date Arithmetic

3.4.3 Ingres II MONEY Data Type

3.4.4 String Functions

3.4.5 POSITION Function

3.4.6 Schema Names 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 Ingres II 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.2 Oracle Functions

B.2.1 Functions Not Supported by Ingres II

B.2.2 Functions Supported by Ingres II

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

C Data Dictionary

C.1 Data Dictionary Support

C.1.1 Ingres II System Tables

C.1.2 Accessing the Gateway Data Dictionary

C.1.3 Direct Queries to Ingres II 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_INGRES_MODE

D.4 HS_FDS_PARSER_TOKEN_SIZE

D.5 HS_FDS_RECOVERY_ACCOUNT

D.6 HS_FDS_RECOVERY_PWD

D.7 HS_FDS_TIMEZONE

D.8 HS_FDS_TRACE_LEVEL

D.9 HS_FDS_TRANSACTION_LOG

D.10 HS_FDS_TRANSACTION_MODEL

Index