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.