Database source specification (source)

In database connection parameters, the source parameter identifies the data source name.

If the source parameter is defined with an empty value (""), the database interface connects to the default database server, which is usually the local server.

If the source entry is not present in FGLPROFILE, direct database specification method takes place.

Table 1. Meaning of the source connection parameter for supported databases
Database Type Value of "source" entry Description
Genero db datasource ODBC Data Source
Generic ODBC datasource ODBC Data Source
IBM® Informix® dbname[@dbserver] IBM Informix database specification
IBM DB2® dsname DB2 Catalogued Database
MySQL

dbname[@host[:port]]

or

dbname[@localhost~socket]

Database Name @ Host Name: TCP Port

or

Database Name @ Local host ~ UNIX™ socket file

ORACLE tnsname Oracle TNS Service name
PostgreSQL dbname[@host[:port]] Database Name @ Host Name: TCP Port
SQL Server datasource ODBC Data Source
SQLite filename Database file path
Sybase Adaptive Server Enterprise (ASE) dbname[@engine] Database Name @ Engine Name