Database server/user information

Database server and user information for each supported database type.

IBM DB2

Table 1. IBM® DB2®
ODBC datasource Name of the DataSource that has been previously created in ODBC.
User name User name used for connection, or blank if not required.
User password User password for the connection, or blank if not required.

Informix

Table 2. Informix®
Informix server Name of the Informix database server instance (the Informix environment that contains the database to which you wish to connect). This is the same as the value of the INFORMIXSERVER variable.
User name User name used for connection, or blank if not required.
User password User password for the connection, or blank if not required.
Note: For Informix SE, the system variable DBPATH must be set.

MySQL

Table 3. MySQL
Host name or IP address Where the database is located.
Database name MySQL database name.
User name User name used for connection, or blank if not required.
User password User password for the connection, or blank if not required.
Note: If you are using a remote MySQL database and a dynamic runner, these environment variables must be set in Configurations:
  • MYSQLDIR=mysql installation directory
  • MYSQL_UNIX_PORT=$MYSQLDIR/mysql.sock
  • MYSQLPORT=port used for mysql socket

Oracle

Table 4. Oracle
TNS name Oracle® TNS service name.
Schema name Name of Oracle schema.
User name User name used for connection, or blank if not required.
User password User password for the connection, or blank if not required.

PostgreSQL

Table 5. PostgreSQL
Host name or IP address Where the database is located.
Port Port number used to access the database host
Database name PostgreSQL database name.
User name User name used for connection, or blank if not required.
User password User password for the connection, or blank if not required.

SQLServer

Table 6. SQLServer
ODBC datasource Name of the DataSource that has been previously created in ODBC.
User name User name used for connection, or blank if not required.
User password User password for the connection, or blank if not required.

SQLite

Table 7. SQLite
Database file Name of the file that contains the database.
User name User name used for connection, or blank if not required.
User password User password for the connection, or blank if not required.