Skip Headers

Table of Contents Image Oracle Transparent Gateway for Teradata Administrator's Guide
Release 2 (9.2) for HP-UX

Part Number A96560-01
Go To Index
Index

Go to next page

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 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 Teradata 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
Configuring Oracle Net Services on the Oracle Database Server for Multiple Gateway Instances
Multiple Databases Example: Accessing Teradata 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 Teradata Gateway Features and Restrictions

Using the Pass-Through Feature
Database Compatibility Issues for Teradata
Schema Considerations
Naming Rules
Rules for Naming Objects
Case Sensitivity
Data Types
Binary Literal Notation
Date Format Support
Data Type Conversion
Queries
Row Selection
Empty Bind Variables
Locking
Known Restrictions
Transactional Integrity
Transaction Capability
COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
Pass-Through Feature
Bind Variables for Date Columns
SQL Syntax
SELECT FOR UPDATE Statement
WHERE CURRENT OF Clause
CONNECT BY Clause
Subqueries in UPDATE Statement
ROWID
SQL*Plus
Database Links
Stored Procedures
Known Problems
Encrypted Format Login
Aggregate Function with CREATE TABLE or CREATE VIEW Statement
Teradata LONG VARCHAR Data Type
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 Teradata 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 Teradata
Functions Supported by Teradata
Arithmetic Operators
Comparison Operators
Group Functions
String Functions
Other Functions

C Data Dictionary

Data Dictionary Support
Teradata System Catalog Tables
Accessing the Gateway Data Dictionary
Direct Queries to Teradata 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_RECOVERY_ACCOUNT
HS_FDS_RECOVERY_PWD
HS_FDS_SHAREABLE_NAME
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