You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for Informix


1 to 20 of 189 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Database Gateway for Informix User's Guide - Contents

ContentsOracle 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 … Closes Open Cursors 2.3.4 Pass-Through Feature 2.3.5 Informix SMALLFLOAT and REAL Data Types 2.3.6 … Informix

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Informix

Multiple Informix Databases Example: Accessing Informix Datacreated, you can verify the connection to the new Informix databases, as in the following: SQL

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Informix

5.7.5 Multiple Informix Databases Example: Accessing Informix Datacreated you can verify the connection to the new Informix databases, as in the following: SQL

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Oracle Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Oracle® Database Gateway for InformixUser's Guide 11 g Release 1 (11.1) B31047-03 September 2007 Oracle Database Gateway for Informix

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Installing Oracle Database Gateway for Informix

4 Installing Oracle Database Gateway for Informixprocedure for Oracle Database Gateway for Informix. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Informix\". Run the Oracle Universal Installer. See \"Step … appear depend on your platform. See Table 4-3 for a description of the installation procedure of Oracle Database Gateway for Informix.

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Installing Oracle Database Gateway for Informix

4 Installing Oracle Database Gateway for Informixprocedure for Oracle Database Gateway for Informix. To install the gateway, follow these steps … Requirements for Oracle Database Gateway for Informix\". Run the Oracle Universal Installer. See \"Step … they appear depend on your platform. See Table 4-2 for a description of the installation procedure of Oracle Database Gateway for Informix.

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Supported SQL Syntax and Functions

B.2.2 Functions Supported by Informixequivalent Informix functions: Arithmetic Operators Comparison Operators Group Functions String Functions … Pattern Matches Date Functions Other Functions B.2.2.1 Arithmetic Operators Oracle Informix … + + - - * * / / B.2.2.2 Comparison Operators Oracle Informix = = > > = >=, !=, ^= <> IS NOT NULL IS NOT NULL IS … NUL L IS NULL

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Initialization Parameters

Oracle Database Gateway for Informix Initialization ParametersGateway for Informix. They are as follows: HS_DB_DOMAIN HS_DB_INTERNAL_NAME HS_DB_NAME

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Case Studies

3.8 Case 3: Joining Informix TablesCase 3 demonstrates the following: Joins between Informix tables. Subselects. The query retrieves … information from three Informix tables and relates the employees to their department name and salary

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Informix

5 Configuring Oracle Database Gateway for InformixInformix: Configure the Gateway Initialization Parameter File Configure Oracle Net for the Gateway … Encrypt Gateway Initialization Parameter Values Configure the Gateway to Access Multiple Informix Databases

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Supported SQL Syntax and Functions

B.2.1 Functions Not Supported by InformixOracle SQL functions with no equivalent function in Informix are not supported in DELETE, INSERT

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Informix Gateway Features and Restrictions

2.2 Database Compatibility Issues for InformixInformix and Oracle databases function differently in some areas, causing compatibility problems

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Informix Gateway Features and Restrictions

2.3.6 Informix NCHAR and NVARCHAR Data TypesThe gateway cannot select a column defined with an Informix NCHAR or NVARCHAR data type.

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Data Dictionary

C.1.3 Direct Queries to Informix TablesQueries issued directly to individual Informix system catalog tables are allowed but they return … different results because the Informix system catalog table column names differ from those of the data … dictionary view. Also, certain columns in an Informix system catalog table cannot be used in data dictionary processing.

Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Informix

5 Configuring Oracle Database Gateway for InformixInformix: Configure the Gateway Initialization Parameter File Configure Oracle Net for the Gateway … Encrypt Gateway Initialization Parameter Values Configure the Gateway to Access Multiple Informix Databases

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 1 (11.1)

Configuring Oracle Database Gateway for Informix

Multiple Informix Databases Example: Configuring the GatewayChoose One System ID for Each Informix Database A separate instance of the gateway is needed for … each Informix database. Each instance needs its own gateway System ID (SID). For this example, the … gateway SIDs are chosen for the instances that access the Informix databases: dg4ifmx2 for the gateway … same Informix

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Informix Gateway Features and Restrictions

2 Informix Gateway Features and RestrictionsAfter the gateway is installed and configured, you can use the gateway to access Informix data … , pass Informix commands from applications to the Informix database, perform distributed queries, and … Compatibility Issues for Informix Known Restrictions Known Problems

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Informix Gateway Features and Restrictions

2.3.5 Informix SMALLFLOAT and REAL Data TypesInformix SMALLFLOAT and REAL data types have a precision of 6.

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Informix Gateway Features and Restrictions

2.4.2 Informix BYTE and TEXT Data Typescannot be used in a SQL statement that accesses a column defined as Informix data type TEXT. You … cannot use SQL*Plus to select data from a column defined as Informix data type TEXT when the data is … such data in a Informix database. BYTE and TEXT data types must be NULLABLE for INSERT or UPDATE to

Database Gateway for Informix User's Guide, 11g Release 1 (11.1)

Data Dictionary

C.1.1 Informix System Catalog TablesInformix data dictionary information is stored in the Informix database as Informix system catalog … tables. All Informix system catalog tables have names prefixed with Ò sys Ó. The Informix system … catalog tables define the structure of a database. When you change data definitions, Informix