Skip Headers

Table of Contents Image Oracle Transparent Gateway for Rdb Administrator's Guide
Release 2 (9.2) for HP OpenVMS

Part Number A96558-01
Go To Index
Index

Go to next page

Contents

Title and Copyright Information

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
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 Rdb Databases
Multiple Databases Example: Configuring the Gateway
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 Rdb Data
Performing Configuration Tasks
Configuring for Two-Phase Commit
Create the Transaction Log Table

3 Rdb Gateway Features and Restrictions

Using the Pass-Through Feature
Controlling the Rdb Database Constraints Mode
Database Compatibility Issues for Rdb
Handling Dates
Queries
Empty Strings
Empty Bind Variables
Constraint Handling
Known Restrictions
Transactional Integrity
Transaction Capability
COMMIT or ROLLBACK in Cursor PL/SQL Loops Closes Open Cursors
Pass-Through Feature
MultiSchema Rdb Databases
Subqueries in UPDATE Statement
ROWID
Table and View Names
Column Names
Unsupported Data Types
Database Links
Stored Procedures
Known Problems
Encrypted Format Login
Data Definition Language Statements
Date and Time Issues

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 Rdb 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 Rdb
Functions Supported by Rdb
Arithmetic Operators
Comparison Operators
String Functions
Group Functions
Pattern Matches
Date Functions
Other Functions
Functions Supported by the Gateway

C Data Dictionary

Data Dictionary Support
Rdb System Catalog Tables
Accessing the Gateway Data Dictionary
Direct Queries to Rdb Tables
Supported Views and Tables
Data Dictionary Mapping
Default Column Values
Gateway Data Dictionary Descriptions

D Heterogeneous Services Initialization Parameters

Initialization Parameter File Syntax
HS_FDS_CONNECT_INFO
HS_FDS_CONSTRAINTS_MODE
HS_FDS_TRACE_LEVEL
HS_FDS_TRANSACTION_MODEL

Index


Go to next page
Oracle
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Index
Index