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.
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 |
or
|
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 |
Microsoft™ SQL Server | datasource[?options] |
ODBC Data Source ? ODBC connection string parameters |
SQLite |
or
|
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 |