fgldbutl.db_get_database_type()

Returns the database type for the current connection.

Syntax

Important:

This feature is deprecated, its use is discouraged although not prohibited.

FUNCTION db_get_database_type()
  RETURNS STRING

Usage

After connecting to the database, you can get the type of the database server with this function.

Important:

This function is deprecated, use the fgl_db_driver_type() function instead. Note that db_get_database_type() returns a code of the type of database engine (in uppercase), while fgl_db_driver_type() returns the ODI driver code (in lowercase).

Table 1. Codes returned by `db_get_database_type()` per database type
DB Code	Description
`HDB`	SAP HANA®
`IFX`	IBM® Informix®
`MDB`	MariaDB
`MYS`	Oracle® MySQL
`MSV`	Microsoft™ SQL Server
`ORA`	Oracle Database
`PGS`	PostgreSQL
`SQT`	SQLite