Connection category

Under connection category, you must specify the connection method, remote server, user, password, database and server properties.

Connection method

Specify the method to use to connect to the Informix® database:

  • XPS fast. Use this option to connect to an Informix XPS (version 8.5) database. IBM® InfoSphere® DataStage® connects directly to the XPS framework.
  • HPL. Use this option to connect to Informix servers (versions 9.4, 10.0) by using the High Performance Loader (HPL).
  • Native. Use this option to connect to any version of Informix (versions 9.4, 10.0) by using native interfaces.

Remote Server

This option is available if you select the Native connection method. The default value is False. If you select True, you must specify authentication details for the remote server.

User

This option is available only for a connection method of Native with the Remote Server option set to True. Specify the user ID for connecting to the remote database.

Password

This option is available only for a connection method of native with the remote server option set to true. Specify the password for connecting to the remote database with the user ID specified by the User option. The password is encrypted.

Database

Optionally specify the name of the Informix database that contains the table that is specified by the Table Property.

Server

This option is available only with a connection method of XPS Fast or HPL. Specify the name of the Informix XPS server.