Database server/user information
Database server and user information for each supported database type.
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
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
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 directoryMYSQL_UNIX_PORT
=$MYSQLDIR
/mysql.sockMYSQLPORT
=port used for mysql socket
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
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
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
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. |