| Parameter | Explanation |
|---|---|
| name (required) | The unique database connection name. The name
parameter is the identifier for a database connection, and so each
connection must have a unique name.
Note: When you import connections
from a file, if the import file contains a duplicate name,
the import wizard prompts you to either update the connection properties
with the new data, or to keep the existing connections without modifications.
|
| dataServerType (required) | The database server type. The following values
are permitted:
Attention: Some products support a limited set of
database servers. Before you import a data source connection file,
make sure that the included dataServerType entries
are supported by your product.
|
| db2instance (optional) | The DB2® instance name. |
| databaseName (required) | The database name for this database connection. |
| host (required) | The IP address or IP name of the host where the database exists. To retrieve the host name, run the TCP/IP hostname command on the server. To retrieve the host IP address, run the ping host_name command on the server. |
| port (required) | The port number where the database is configured. |
| user (optional) | The database user name. |
| password/password.decrypted (optional) | The password for the database user. If you use the password parameter, the password that is specified in the definition must be in the encrypted form. |
| location (required for DB2Z) | The location of the DB2 for z/OS® system. |
| databaseAlias (optional) | The alias of the DB2 command line processor (CLP). This parameter can be used for data server types DB2LUW and DB2Z only. |
| INFORMIXSERVERNAME (required for INFORMIX_JDBC, optional for INFORMIX) | The name of the Informix® database server. |
| xtraProps (optional) | Additional properties such as connection properties
as defined in the JDBC driver documentation for the database server
type. Example: traceLevel=32 |
| URL (see the explanation) | The JDBC URL of the database server. The URL parameter
is required if the data server type is not supported by default. If you do not enter a value for this parameter, a default URL is created for the connection. |
| comment (optional) | A descriptive comment for the database connection. |
You can see a sample of CSV text file in the samples subdirectory of the installation directory.