1/12

Contents

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• Overview
• Heterogeneous Services Technology
• Oracle Database Gateways

2 Teradata Gateway Features and Restrictions

• Using the Pass-Through Feature
• Executing Stored Procedures and Functions
  • Return Values and Stored Procedures
  • Result Sets and Stored Procedures
    • OCI Program Fetching from Result Sets in Sequential Mode
    • PL/SQL Program Fetching from Result Sets in Sequential Mode
• CHAR Semantics
• Multi-byte Character Sets Ratio Suppression
• IPv6 Support
• Gateway Session IDLE Timeout
• Database Compatibility Issues for Teradata
  • Schema Considerations
  • Naming Rules
    • Rules for Naming Objects
    • Case Sensitivity
  • Data Types
    • Binary Literal Notation
    • 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
    • WHERE CURRENT OF Clause
    • CONNECT BY Clause
    • ROWID
    • EXPLAIN PLAN Statement
    • Callback Support
  • SQL*Plus
  • Database Links
  • CALLBACK links
• Known Problems
  • Teradata LONG VARCHAR Data Type
  • Schema Names and PL/SQL
  • Data Dictionary Views and PL/SQL

3 Case Studies

• Case Descriptions
• Installation Media 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 Initialization Parameters

• Initialization Parameter File Syntax
• Oracle Database Gateway for Teradata Initialization Parameters
• Initialization Parameter Description
  • HS_DB_DOMAIN
  • HS_DB_INTERNAL_NAME
  • HS_DB_NAME
  • HS_DESCRIBE_CACHE_HWM
  • HS_LANGUAGE
    • Character Sets
    • Language
    • Territory
  • HS_LONG_PIECE_TRANSFER_SIZE
  • HS_OPEN_CURSORS
  • HS_RPC_FETCH_REBLOCKING
  • HS_RPC_FETCH_SIZE
  • HS_TIME_ZONE
  • HS_TRANSACTION_MODEL
  • IFILE
  • HS_FDS_TIMESTAMP_MAPPING
  • HS_FDS_DATE_MAPPING
  • HS_FDS_CONNECT_INFO
  • HS_FDS_DEFAULT_OWNER
  • HS_FDS_PROC_IS_FUNC
  • HS_FDS_RECOVERY_ACCOUNT
  • HS_FDS_RECOVERY_PWD
  • HS_FDS_TRACE_LEVEL
  • HS_FDS_TRANSACTION_LOG
  • HS_FDS_FETCH_ROWS
  • HS_IDLE_TIMEOUT
  • HS_NLS_LENGTH_SEMANTICS
  • HS_KEEP_REMOTE_COLUMN_SIZE
  • HS_FDS_REMOTE_DB_CHARSET
  • HS_FDS_SUPPORT_STATISTICS
  • HS_FDS_ARRAY_EXEC

Index