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
Scripting on this page enhances content navigation, but does not change the content in any way.