Contents

Title and Copyright Information

List of Tables

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

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 Gateway Startup File

Task 3: Customize the Initialization Parameter File

Setting Up the Gateway Data Dictionary

Installing the PL/SQL Package DBMS_TG4RMS

Creating ADD Definitions Using the ADD Language

Extending ADD Definitions Using the ADD Language

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

Configuring the Gateway for Multiple RMS Data Dictionaries

Multiple Data Dictionaries Example: Configuring the Gateway

Multiple Data Dictionaries Example: Configuring Oracle Net Services Listener

Multiple Data Dictionaries Example: Stopping and Starting the TNS Listener

Multiple Data Dictionaries Example: Configuring the Oracle Database Server for Gateway Access

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

Multiple Data Dictionaries Example: Accessing RMS Data

3 RMS Gateway Features and Restrictions

Updating Gateway Metadata Statistics

Compatibility Issues for RMS

Naming Rules

Rules for Naming Objects

Case Sensitivity

Queries

Empty Strings

Empty Bind Variables

Known Restrictions

Transaction Capability

Pass-Through SQL

ROWID

Table and Column Names

SQL Syntax

SELECT FOR UPDATE Statement

CONNECT BY Clause

Database Links

Stored Procedures

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

Case 4: Data Dictionary Query

A Data Type Conversion

Data Type Conversion

B Supported SQL Syntax and Functions

Supported SQL Statements

SELECT

Oracle Functions

Functions Not Supported by RMS

Functions Supported by RMS

Arithmetic Operators

Comparison Operators

String Functions

Group Functions

Other Functions

C Data Dictionary

Data Dictionary Support

Accessing the Gateway Data Dictionary

Supported Views and Tables

Default Column Values

RMS Data Dictionary Descriptions

D Heterogeneous Services Initialization Parameters

Initialization Parameter File Syntax

HS_FDS_CONNECT_INFO

HS_FDS_TRACE_LEVEL

E Oracle Transparent Gateway for RMS Metadata Syntax

Reserved Keywords

The DEFINE RECORD Statement

Record Attributes

The FILENAME Attribute

The FILTER Attribute

The N_BLOCKS Attribute

The N_ROWS Attribute

The ORGANIZATION Attribute

The RECORD_FORMAT Attribute

The SIZE Attribute

The FIELDS Statement

Elementary Field Description Statements

Field Attributes

The STRUCTURE Field Description Statement

The VARIANTS Field Description Statement

The INDEXES Statement

The Index Description Statement

Index Attributes

The Index Segment Statement

Index Segment Attributes

ADD Supported Data Types

Index