IBM Informix connector (DataStage)
Use the IBM Informix connector in parallel and server jobs to read, write, or look up data in Informix databases.
Prerequisite
Create the connection. For instructions, see Connecting to a data source in DataStage® and the Informix connection.
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.