User Guide : Map Connectors : Source and Target Map Connectors : IBM Informix Dynamic Server 11
Share this page             
IBM Informix Dynamic Server 11
IBM Informix Dynamic Server 11 is a relational database management system. You must have it installed on your system.
The integration platform can write to IBM Informix Dynamic Server 11 target files. It is not available as a source connector. This connector uses the ODBC 3.5 standard.
Connector-Specific Notes
Target Schema Modification: In multimode targets, modifications to column names, data types, and sizes are not permitted.
Query Statement Support: The target format must support query statements (such as Oracle and SQL Server statements) for transformations to work with this connector.
Auto-Increment Fields: If the target table contains an auto-increment column, you may get an error at run time. If this occurs, delete the field that is causing the problem.
Property Options
You can set the following target (T) properties for IBM Informix Dynamic Server 11.
Data Types
The only available data type is Text.
Specifies field lengths for data. If you need to change field lengths, reset them in the schema.
The maximum data length for long data types. Default is one megabyte, or 1,048,576 bytes. You can reset this number as need based on the amount of memory available and the target requirements.
The default is sql.log, which is in the default installation directory. To use a different log, either browse to select the file or enter the path and file name.
SQL Output
Allows you to select bound or unbound mode and whether to write SQL statements to a SQL log. SQL Output has these options:
Target Only (the default) - Uses bound mode, which uses bind variables and is faster. SQL statements are sent to the target and not to the SQL log specified by the SQL Log property.
Target Only - Uses unbound mode, which does not use bind variables and sends the literal SQL statement to the database engine. SQL statements are sent to the target and not to the SQL log.
Target and SQL Log - Sends SQL statements to the target and to the SQL log file.
SQL Log Only - Sends SQL statements to the SQL log file only.
If set to true, allows you to see synonyms. The alias names appear in the table list along with the tables. Default is false.
If set to true, this property allows you to see all tables created by the DBA in the database. The system table names appear in the table list. Default is false.
Note:  This property is applicable only if the user is logged onto the database as the database administrator. Only the DBA has access to system tables.
When set to True (the default) null values are sent to the database during insertion or updating of records. When false, null values are not sent to the database and UpdateNullFields forces the connector to operate in unbound mode, which may result in slower performance.
Best Practice — If fields in the target record are not mapped, then the null values are passed to the target. If you do not want to write to these fields, then it is recommended to set the value for UpdateNullFields to False.
If set to True, this property allows you to see the view names in the table list along with the table names. Default is True.
Note:  This property supports only Append and DeleteAndAppend output modes and does not support the Replace output mode.