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 265 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Database Gateway for Informix User's Guide - Contents

ContentsOracle Database Gateways 2 Informix Gateway Features and Restrictions 2.1 Using the Pass-Through … Session IDLE Timeout 2.6 Database Compatibility Issues for Informix 2.6.1 ANSI SQL Standard 2.6.2 … Cursor Loops Closes Open Cursors 2.7.4 Pass-Through Feature 2.7.5 Informix SMALLFLOAT and REAL Data … CALLBACK links 2.8 Known Problems

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle InformixB.2.2.2 Comparison Operators Oracle Informix = = > > = >=, !=, ^= <> IS NOT NULL IS NOT NULL IS NUL L IS NULL

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle InformixB.2.2.7 Other Functions Oracle Informix ABS ABS COS COS EXP EXP LOG10 LOG10 LN LOGN LTRIM( char

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle InformixB.2.2.3 Group Functions Oracle Informix AVG AVG COUNT COUNT MAX MAX MIN MIN SUM SUM

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle InformixB.2.2.4 String Functions Oracle Informix ||, CONCAT || ASCII ASCII CHR CHR LENGTH LENGTH

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle InformixB.2.2.1 Arithmetic Operators Oracle Informix + + - - * * / /

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle InformixB.2.2.5 Pattern Matches Oracle Informix LIKE 'a%' LIKE \"a%\" LIKE 'a_' LIKE \"a_\" LIKE 'a

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Supported SQL Syntax and Functions

Oracle InformixB.2.2.6 Date Functions Oracle Informix date + number date + number date - number date - number date + date date + date date - date date - date

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Data Type Conversion

Informix Oracle Comment, if the maximum size for an Informix data type is smaller or larger than the corresponding Oracle … (300) and you use the COPY statement to copy the Oracle table to the Informix table where the Informix

Database Gateway Installation and Configuration Guide for Microsoft Windows, 11g Release 2 (11.2)

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 Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 2 (11.2)

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 2 (11.2)

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 for Informix User's Guide, 11g Release 2 (11.2)

Informix Gateway Features and Restrictions

2.7.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 2 (11.2)

Informix Gateway Features and Restrictions

2.8.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 Installation and Configuration Guide for Microsoft Windows, 11g Release 2 (11.2)

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 AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 2 (11.2)

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 AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64, 11g Release 2 (11.2)

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 for Informix User's Guide, 11g Release 2 (11.2)

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

Database Gateway for Informix User's Guide, 11g Release 2 (11.2)

Informix Gateway Features and Restrictions

2.6 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 2 (11.2)

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