Go to main content
1/12
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
Executing Stored Procedures and Functions
2.2.1
Return Values and Stored Procedures
2.2.2
Result Sets and Stored Procedures
2.2.2.1
OCI Program Fetching from Result Sets in Sequential Mode
2.2.2.2
PL/SQL Program Fetching from Result Sets in Sequential Mode
2.3
CHAR Semantics
2.4
Multi-byte Character Sets Ratio Suppression
2.5
IPv6 Support
2.6
Gateway Session IDLE Timeout
2.7
Database Compatibility Issues for Teradata
2.7.1
Schema Considerations
2.7.2
Naming Rules
2.7.2.1
Rules for Naming Objects
2.7.2.2
Case Sensitivity
2.7.3
Data Types
2.7.3.1
Binary Literal Notation
2.7.3.2
Data Type Conversion
2.7.4
Queries
2.7.4.1
Row Selection
2.7.4.2
Empty Bind Variables
2.7.5
Locking
2.8
Known Restrictions
2.8.1
Transactional Integrity
2.8.2
Transaction Capability
2.8.3
COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
2.8.4
Pass-Through Feature
2.8.5
Bind Variables for Date Columns
2.8.6
SQL Syntax
2.8.6.1
WHERE CURRENT OF Clause
2.8.6.2
CONNECT BY Clause
2.8.6.3
ROWID
2.8.6.4
EXPLAIN PLAN Statement
2.8.6.5
Callback Support
2.8.7
SQL*Plus
2.8.8
Database Links
2.8.9
CALLBACK links
2.9
Known Problems
2.9.1
Teradata LONG VARCHAR Data Type
2.9.2
Schema Names and PL/SQL
2.9.3
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_PROC_IS_FUNC
D.3.16
HS_FDS_RECOVERY_ACCOUNT
D.3.17
HS_FDS_RECOVERY_PWD
D.3.18
HS_FDS_TRACE_LEVEL
D.3.19
HS_FDS_TRANSACTION_LOG
D.3.20
HS_FDS_FETCH_ROWS
D.3.21
HS_IDLE_TIMEOUT
D.3.22
HS_NLS_LENGTH_SEMANTICS
D.3.23
HS_KEEP_REMOTE_COLUMN_SIZE
D.3.24
HS_FDS_REMOTE_DB_CHARSET
D.3.25
HS_FDS_SUPPORT_STATISTICS
D.3.26
HS_FDS_SQLLEN_INTERPRETATION
Index
Scripting on this page enhances content navigation, but does not change the content in any way.