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
Generic ODBC	`datasource`	ODBC Data Source
IBM® Informix®	`dbname[@dbserver]`	IBM Informix database specification
IBM DB2®	`dsname`	DB2 Catalogued Database
Oracle® MySQL / MariaDB	`dbname[@host[:port]]` or `dbname[@localhost~socket]`	Database Name @ Host Name: TCP Port or Database Name @ Local host ~ UNIX™ socket file
Oracle Database	`tnsname`	Oracle TNS Service name
PostgreSQL	`dbname[@host[:port]][?options]`	Database Name @ Host Name : TCP Port ? PostgreSQL URI-style query string options
SQL Server	`datasource[?options]`	ODBC Data Source ? ODBC connection string parameters
SQLite	`filename` or `:memory:`	Path to the database file, or simple file name to be found with DBPATH, or `:memory:` to create a database in memory.
SAP HANA®	`datasource[?options]`	ODBC Data Source ? ODBC connection string parameters