Defining the Informix CLI Connection
When you use the GUI to edit an Informix CLI stage, the Informix CLI Stage dialog box opens. This dialog box has the Stage, Input, and Output pages (depending on whether there are inputs to and outputs from the stage.
- Stage. This page displays the name of the
stage you are editing. The General tab defines
the Informix® data source, login information,
and transaction isolation level information for concurrency control
in jobs. You can enter text to describe the purpose of the stage in
the Description field. The properties on this tab define the
connection to the Informix data source. The NLS tab
defines a character set map to be used with the stage. This tab appears
only if you have installed NLS for InfoSphere®
DataStage®.
For details, see Defining Character Set Mapping.
Note: You cannot change the name of the stage from this dialog box.
- Input. This page is displayed only if you have an input link to this stage. It specifies the SQL table to use and the associated column definitions for each data input link. It also specifies how data is written and contains the SQL statement or call syntax used to write data to an Informix table. It also specifies how to create the target table if desired and how to drop it if necessary.
- Output. This page is displayed only if you have an output or reference link to this stage. It specifies the SQL tables to use and the associated column definitions for each data output link. It contains the SQL SELECT statement or call syntax used to read data from one or more Informix tables or views.