Skip Headers
Oracle® Database Gateway for Teradata User's Guide
11g Release 1 (11.1)
Part Number B31050-03
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction
1.1
Overview
1.2
Heterogeneous Services Technology
1.3
Oracle Database Gateways
2
Teradata Gateway Features and Restrictions
2.1
Using the Pass-Through Feature
2.2
Database Compatibility Issues for Teradata
2.2.1
Schema Considerations
2.2.2
Naming Rules
2.2.2.1
Rules for Naming Objects
2.2.2.2
Case Sensitivity
2.2.3
Data Types
2.2.3.1
Binary Literal Notation
2.2.3.2
Data Type Conversion
2.2.4
Queries
2.2.4.1
Row Selection
2.2.4.2
Empty Bind Variables
2.2.5
Locking
2.3
Known Restrictions
2.3.1
Transactional Integrity
2.3.2
Transaction Capability
2.3.3
COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
2.3.4
Pass-Through Feature
2.3.5
Bind Variables for Date Columns
2.3.6
SQL Syntax
2.3.6.1
WHERE CURRENT OF Clause
2.3.6.2
CONNECT BY Clause
2.3.6.3
ROWID
2.3.6.4
EXPLAIN PLAN Statement
2.3.6.5
Callback Support
2.3.7
SQL*Plus
2.3.8
Database Links
2.3.9
Stored Procedures
2.4
Known Problems
2.4.1
Encrypted Format Login
2.4.2
Teradata LONG VARCHAR Data Type
2.4.3
Schema Names and PL/SQL
2.4.4
Data Dictionary Views and PL/SQL
3
Case Studies
3.1
Case Descriptions
3.2
Installation Media Contents
3.3
Demonstration Files
3.4
Demonstration Requirements
3.5
Creating Demonstration Tables
3.5.1
Demonstration Table Definitions
3.5.2
Demonstration Table Contents
3.6
Case 1: Simple Queries
3.7
Case 2: A More Complex Query
3.8
Case 3: Joining Teradata Tables
3.9
Case 4: Write Capabilities
3.9.1
DELETE Statement
3.9.2
UPDATE Statement
3.9.3
INSERT Statement
3.10
Case 5: Data Dictionary Query
3.11
Case 6: The Pass-Through Feature
3.11.1
UPDATE Statement
3.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
Initialization Parameters
D.1
Initialization Parameter File Syntax
D.2
Oracle Database Gateway for Teradata Initialization Parameters
D.3
Initialization Parameter Description
D.3.1
HS_DB_DOMAIN
D.3.2
HS_DB_INTERNAL_NAME
D.3.3
HS_DB_NAME
D.3.4
HS_DESCRIBE_CACHE_HWM
D.3.5
HS_LANGUAGE
D.3.5.1
Character Sets
D.3.5.2
Language
D.3.5.3
Territory
D.3.6
HS_LONG_PIECE_TRANSFER_SIZE
D.3.7
HS_OPEN_CURSORS
D.3.8
HS_RPC_FETCH_REBLOCKING
D.3.9
HS_RPC_FETCH_SIZE
D.3.10
HS_TIME_ZONE
D.3.11
HS_TRANSACTION_MODEL
D.3.12
IFILE
D.3.13
HS_FDS_CONNECT_INFO
D.3.14
HS_FDS_DEFAULT_OWNER
D.3.15
HS_FDS_RECOVERY_ACCOUNT
D.3.16
HS_FDS_RECOVERY_PWD
D.3.17
HS_FDS_TRACE_LEVEL
D.3.18
HS_FDS_TRANSACTION_LOG
D.3.19
HS_FDS_FETCH_ROWS
Index