Skip Headers
Oracle® Database Gateway for Informix User's Guide
11g Release 1 (11.1)
Part Number B31047-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 Documentation
Conventions
1
Introduction
1.1
Overview
1.2
Heterogeneous Services Technology
1.3
Oracle Database Gateways
2
Informix Gateway Features and Restrictions
2.1
Using the Pass-Through Feature
2.2
Database Compatibility Issues for Informix
2.2.1
ANSI SQL Standard
2.2.2
Naming Rules
2.2.2.1
Rules for Naming Objects
2.2.2.2
Object Names
2.2.2.3
Case Sensitivity
2.2.3
Data Types
2.2.3.1
Binary, Byte and Text Literal Notation
2.2.3.2
Data Type Conversion
2.2.4
Queries
2.2.4.1
Row Selection
2.2.4.2
Empty Strings
2.2.4.3
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
Informix SMALLFLOAT and REAL Data Types
2.3.6
Informix NCHAR and NVARCHAR Data Types
2.3.7
SQL Syntax
2.3.7.1
WHERE CURRENT OF Clause
2.3.7.2
CONNECT BY Clause
2.3.7.3
Use of NULL Keyword in SELECT Statement
2.3.7.4
Subqueries in INSERT Statement
2.3.7.5
Subqueries in DELETE, INSERT, and UPDATE Statements
2.3.7.6
ROWID
2.3.7.7
EXPLAIN PLAN Statement
2.3.7.8
Callback Support
2.3.8
SQL*Plus
2.3.9
Database Links
2.3.10
Gateway Data Dictionary Views
2.3.11
Stored Procedures
2.4
Known Problems
2.4.1
Encrypted Format Login
2.4.2
Informix BYTE and TEXT Data Types
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
Distribution 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 Informix 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 Informix
B.2.2
Functions Supported by Informix
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
Pattern Matches
B.2.2.6
Date Functions
B.2.2.7
Other Functions
B.2.3
Functions Supported by the Gateway
C
Data Dictionary
C.1
Data Dictionary Support
C.1.1
Informix System Catalog Tables
C.1.2
Accessing the Gateway Data Dictionary
C.1.3
Direct Queries to Informix 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 Informix 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