User Guide : Map Connectors : Source and Target Map Connectors : Informix-Online DS Multimode
 
Share this page             
Informix-Online DS Multimode
This connector provides DSN-less source and target connections to the Informix-Online Dynamic Server relational database management system.
This connector is a multimode connector. The main distinction between single and multimode connectors is in the use of event actions:
Single mode connectors – Use event actions to access one target file or table at a time in a transformation.
Multimode connectors – Use multimode event actions to access multiple target tables in the same transformation, each time the transformation run.
Use the event actions intended for multimode connectors to enable access to multiple target tables.
Informix Client Installation
Install the following Informix Client SDK version on same system with DataConnect
Windows: CSDK 3.0
Solaris: CSDK 2.9
Connection strings from the Informix client configuration file can be referenced in the DriverOptions connector property as documented below under the Procedure topic. The following table lists standard Informix connection keywords.
Keyword
Short Version
driver
driver
dsn
dsn
filedsn
filedsn
uid
uid
database
db
host
host
pwd
pwd
server
srvr
service
serv
protocol
pro
client_locale
cloc
db_locale
dloc
translationdll
tdll
translationoption
topt
connectdatabase
condb
exclusive
xcl
cursorbehavior
curb
savefile
savefile
options
opt
description
desc
enablescrollablecursors
scur
enableinsertcursors
icur
optimizeautocommit
oac
optofc
optofc
needodbctypesonly
odtyp
reportkeysetcursors
rkc
fetchbuffersize
fbc
describedecimalfloatpoint
ddfp
donotuselvarchar
dnl
reportcharcolaswidecharcol
rcwc
Simulated Database Connections
If you try to make a live connection to a database that you do not have direct access to, Map Editor displays a message that the connection is simulated. The simulated mode may be unable to display all property options. To see all property options, install and configure the database client before connecting in the Map Editor.
Limitations
Target Schema modification - In multimode targets, modifications to column names, data types, and sizes are not permitted.
Query Statement Support - Your target format must be able to support query statements for transformations written with this connector to work, such as Access, Oracle, SQL Server, to name a few.
Auto-Increment Fields - If your target table contains an auto-increment column, you may get an error at run time. If this occurs, you must delete the field that is causing the problem from the record.
Property Options
 
Property
S/T
Description
MaxDataLength
T
The maximum data length for long data types. Default is 1 MB: 1,048,576. You can reset this number as you choose based on your available memory capabilities and Target requirements.
SQL Log
T
The default is sql.log in the default installation directory. If you want to use a different log, click once in the value cell, then select the ellipsis to browse to the location of the file, or enter the path and file name.
UpdateNullFields
T
Null values are sent to the database when inserting or updating records. The default is true. If you select False, null values are not sent to the database when you insert or update records. When set to false, this property forces the connector to operate in unbound mode, which may cause 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.
SQL Output
T
Allows you to select bound or unbound mode and whether you want to write SQL statements to a SQL log or not. Keep in mind that bound mode is faster, since bind variables are used. Target Only is the default output:
Target Only – Uses bound mode, which uses bind variables. SQL statements are sent to the Target and not to the SQL log specified in the SQL Log property.
Target Only (Unbound Mode) – 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 specified in the SQL Log property.
Target and SQL Log – Sends SQL statements to the Target and to the SQL log specified in the SQL Log property.
SQL Log Only – Sends SQL statements only to the SQL log file specified in the SQL Log property.
Synonyms
T
If set to true, this property allows you to see synonyms. The alias names appear in the table list along with the tables. Default is false.
SystemTables
T
The SystemTables property is applicable only if you are logged onto the database as the database administrator. Only the DBA has access to SystemTables. If set to true, this property allows you to see all the tables created by the DBA. The system table names appear in the table list. The default is false.
Views
T
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.
Data Type
The only available data type is text.