Use the IBM Informix connector in parallel and server jobs to read, write, or look up data in Informix databases.

Prerequisite

Connection

Create the connection. For instructions, see Connecting to a data source in DataStage® and the Informix connection.

Sampling

If you want to use the sampling functionality, install the SQL Packages Extension in the Informix

server.

For more information, see SQL Packages Extension.

Restrictions

Table names in an Informix database that is not ANSI-compliant must be unique

The table actions that you can do in an Informix database depend on whether the database was created as ANSI compliant. If the Informix database was not created as MODE ANSI, each table name must be unique among all the identifiers of tables, views, sequence objects, and synonyms within the same database. In a database that is not ANSI-compliant, this rule means that if you try to replace or create a table with the same name, the action will fail with an SQL error message indicating that the table already exists.