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® ASE dbname[@engine] Database Name @ Engine Name
SAP HANA® datasource[?options] ODBC Data Source ? ODBC connection string parameters