IBM DB2

From DreamFactory
Jump to: navigation, search
 
Line 1: Line 1:
The IBM DB2 service type can connect to local or remote IBM DB2 servers.
+
The [https://www.dreamfactory.com/hub/integrations/ibm-db2/ IBM DB2] service type can connect to local or remote IBM DB2 servers.
  
 
==Common Feature Exceptions==
 
==Common Feature Exceptions==

Latest revision as of 16:38, 8 August 2019

The IBM DB2 service type can connect to local or remote IBM DB2 servers.

Common Feature Exceptions

Requirements

  • PHP extensions ibm_db2 and pdo_ibm are required to be installed or compiled in. Check here for installation help.

Configuration

  • host - String. Required. The name of the database host, i.e. localhost, 192.168.1.1, etc.
  • port - Integer. Optional. The number of the database host port, internally defaults to 56789.
  • database - String. Required. The name of the database to connect to on the given server. This can be a lookup key.
  • username - String. Optional. The name of the database user. This can be a lookup key.
  • password - String. Optional. The password for the database user. This can be a lookup key.
  • default_schema_only - Boolean. Defaults to false. Do not include other schemas/databases on this server regardless of permissions given to the supplied credentials.
  • options - Object. Optional. A name-value array of driver-specific connection options.
  • attributes - Object. Optional. A key-value array of attributes to be set after connection. For further information, see http://php.net/manual/en/pdo.setattribute.php.
  • statements - Array of Strings. Optional. An array of additional SQL statements to run during connection initialization.