Go to main content
1/12
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
CHAR Semantics
2.3
Multi-byte Character Sets Ratio Suppression
2.4
IPv6 Support
2.5
Gateway Session IDLE Timeout
2.6
Database Compatibility Issues for Informix
2.6.1
ANSI SQL Standard
2.6.2
Naming Rules
2.6.2.1
Rules for Naming Objects
2.6.2.2
Object Names
2.6.2.3
Case Sensitivity
2.6.3
Data Types
2.6.3.1
Binary, Byte and Text Literal Notation
2.6.3.2
Data Type Conversion
2.6.4
Queries
2.6.4.1
Row Selection
2.6.4.2
Empty Strings
2.6.4.3
Empty Bind Variables
2.6.5
Locking
2.7
Known Restrictions
2.7.1
Transactional Integrity
2.7.2
Transaction Capability
2.7.3
COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
2.7.4
Pass-Through Feature
2.7.5
Informix SMALLFLOAT and REAL Data Types
2.7.6
SQL Syntax
2.7.6.1
WHERE CURRENT OF Clause
2.7.6.2
CONNECT BY Clause
2.7.6.3
Use of NULL Keyword in SELECT Statement
2.7.6.4
Subqueries in INSERT Statement
2.7.6.5
Subqueries in DELETE, INSERT, and UPDATE Statements
2.7.6.6
ROWID
2.7.6.7
EXPLAIN PLAN Statement
2.7.6.8
Callback Support
2.7.7
SQL*Plus
2.7.8
Database Links
2.7.9
Gateway Data Dictionary Views
2.7.10
Stored Procedures
2.7.11
CALLBACK links
2.8
Known Problems
2.8.1
Encrypted Format Login
2.8.2
Informix BYTE and TEXT Data Types
2.8.3
Schema Names and PL/SQL
2.8.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_RECOVERY_ACCOUNT
D.3.15
HS_FDS_RECOVERY_PWD
D.3.16
HS_FDS_TRACE_LEVEL
D.3.17
HS_FDS_TRANSACTION_LOG
D.3.18
HS_FDS_FETCH_ROWS
D.3.19
HS_IDLE_TIMEOUT
D.3.20
HS_NLS_LENGTH_SEMANTICS
D.3.21
HS_KEEP_REMOTE_COLUMN_SIZE
D.3.22
HS_FDS_REMOTE_DB_CHARSET
D.3.23
HS_FDS_SUPPORT_STATISTICS
D.3.24
HS_FDS_SQLLEN_INTERPRETATION
Index
Scripting on this page enhances content navigation, but does not change the content in any way.