Contents

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

2.1.3 Task 3: Customize the Initialization Parameter File

2.2 Setting Up the Gateway Data Dictionary

2.2.1 Installing the PL/SQL Package DBMS_TG4RMS

2.2.2 Working With the Gateway Data Dictionary

2.2.2.1 Creating ADD Definitions Using the ADD Language

2.2.2.2 Extending ADD Definitions Using the ADD Language

2.3 Configuring Oracle Net Services Listener for the Gateway

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

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

2.3.1.2 Example of Gateway to Start in listener.ora File

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

2.4 Configuring the Oracle Database Server for Gateway Access

2.4.1 Configuring Oracle Net Services for the Oracle Database Server

2.4.1.1 Configuring tnsnames.ora

2.5 Creating Database Links

2.6 Configuring the Gateway for Multiple RMS Data Dictionaries

2.6.1 Multiple Data Dictionaries Example: Configuring the Gateway

2.6.2 Multiple Data Dictionaries Example: Configuring Oracle Net Services Listener

2.6.3 Multiple Data Dictionaries Example: Stopping and Starting the TNS Listener

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

2.6.5 Multiple Data Dictionaries Example: Accessing RMS Data

3 RMS Gateway Features and Restrictions

3.1 Updating Gateway Metadata Statistics

3.2 Compatibility Issues for RMS

3.2.1 Naming Rules

3.2.1.1 Rules for Naming Objects

3.2.1.2 Case Sensitivity

3.2.2 Queries

3.2.2.1 Empty Strings

3.2.2.2 Empty Bind Variables

3.3 Known Restrictions

3.3.1 Transaction Capability

3.3.2 Pass-Through SQL

3.3.3 ROWID

3.3.4 Table and Column Names

3.3.5 CONNECT BY Clause in a SELECT Statement

3.3.6 Database Links

3.3.7 Stored Procedures

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

4.9 Case 4: Data Dictionary Query

A Data Type Conversion

A.1 Data Type Conversion

B Supported SQL Syntax and Functions

B.1 Supported SQL Statements

B.1.1 SELECT

B.2 Oracle Functions

C Data Dictionary

C.1 Data Dictionary Support

C.1.1 Accessing the Gateway Data Dictionary

C.1.2 Supported Views and Tables

C.1.3 Default Column Values

C.2 RMS 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_IGNORE_RELATIVE_INDEX

D.4 HS_FDS_READ_SPACES_AS_NULL_VALUE

D.5 HS_FDS_TRACE_LEVEL

E Oracle Transparent Gateway for RMS Metadata Syntax

E.1 Reserved Keywords

E.1.1 Field names

E.1.2 Index names

E.2 The DEFINE RECORD Statement

E.2.1 Record Attributes

E.2.1.1 The FILENAME Attribute

E.2.1.2 The FILTER Attribute

E.2.1.3 The N_BLOCKS Attribute

E.2.1.4 The N_ROWS Attribute

E.2.1.5 The ORGANIZATION Attribute

E.2.1.6 The RECORD_FORMAT Attribute

E.2.1.7 The SIZE Attribute

E.3 The FIELDS Statement

E.3.1 Elementary Field Description Statements

E.3.1.1 Field Attributes

E.3.2 The STRUCTURE Field Description Statement

E.3.3 The VARIANTS Field Description Statement

E.4 The INDEXES Statement

E.4.1 The Index Description Statement

E.4.1.1 Index Attributes

E.4.2 The Index Segment Statement

E.4.2.1 Index Segment Attributes

E.5 ADD Supported Data Types

Index