Contents

List of Tables

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 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 Teradata Databases

2.6.1 Multiple Databases Example: Configuring the Gateway

2.6.2 Multiple Databases Example: Configuring Oracle Net Services Listener

2.6.3 Multiple Databases Example: Stopping and Starting the TNS Listener

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

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

2.6.5 Multiple Databases Example: Accessing Teradata Data

2.7 Performing Configuration Tasks

2.7.1 Configuring for Two-Phase Commit

2.7.1.1 Task 1: Create a Recovery Account and Password

2.7.1.2 Task 2: Create the Transaction Log Table

3 Teradata Gateway Features and Restrictions

3.1 Using the Pass-Through Feature

3.2 Database Compatibility Issues for Teradata

3.2.1 Schema Considerations

3.2.2 Naming Rules

3.2.2.1 Rules for Naming Objects

3.2.2.2 Case Sensitivity

3.2.3 Data Types

3.2.3.1 Binary Literal Notation

3.2.3.2 Date Format Support

3.2.3.3 Data Type Conversion

3.2.4 Queries

3.2.4.1 Row Selection

3.2.4.2 Empty Bind Variables

3.2.5 Locking

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 Bind Variables for Date Columns

3.3.6 SQL Syntax

3.3.6.1 WHERE CURRENT OF Clause

3.3.6.2 CONNECT BY Clause

3.3.6.3 ROWID

3.3.6.4 EXPLAIN PLAN Statement

3.3.7 SQL*Plus

3.3.8 Database Links

3.3.9 Stored Procedures

3.4 Known Problems

3.4.1 Encrypted Format Login

3.4.2 Teradata LONG VARCHAR Data Type

3.4.3 Schema Names and PL/SQL

3.4.4 Data Dictionary Views 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 Teradata 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.1.1 DELETE

B.1.2 INSERT

B.1.3 SELECT

B.1.4 UPDATE

B.2 Oracle Functions

B.2.1 Functions Not Supported by Teradata

B.2.2 Functions Supported by Teradata

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

C Data Dictionary

C.1 Data Dictionary Support

C.1.1 Teradata System Catalog Tables

C.1.2 Accessing the Gateway Data Dictionary

C.1.3 Direct Queries to Teradata 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_PARSER_TOKEN_SIZE

D.4 HS_FDS_RECOVERY_ACCOUNT

D.5 HS_FDS_RECOVERY_PWD

D.6 HS_FDS_TRACE_LEVEL

D.7 HS_FDS_TRANSACTION_LOG

D.8 HS_FDS_TRANSACTION_MODEL

Index