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 ODBC Data Source
SQLite

filename

or

:memory:

Database file path, or simple file name to be found with DBPATH, or :memory: to create a database in memory.
Sybase Adaptive Server Enterprise (ASE) dbname[@engine] Database Name @ Engine Name