IBM DB2 Features
From DreamFactory
(Created page with "The SQL Anywhere service type can connect to local or remote SQL Anywhere servers. ==Common Feature Exceptions== * This service type currently is not supported on Windows OS...") |
|||
| Line 1: | Line 1: | ||
| − | The | + | The IBM DB2 service type can connect to local or remote IBM DB2 servers. |
==Common Feature Exceptions== | ==Common Feature Exceptions== | ||
| − | |||
==Requirements== | ==Requirements== | ||
| − | + | * PHP extensions '''ibm_db2''' and '''pdo_ibm''' are required to be installed or compiled in. Check [[DreamFactory/Installation/Databases/IBM_DB2|here]] for installation help. | |
| − | + | ||
| − | * PHP | + | |
==Configuration== | ==Configuration== | ||
* '''host''' - String. Required. The name of the database host, i.e. localhost, 192.168.1.1, etc. | * '''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 | + | * '''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. | * '''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. | * '''username''' - String. Optional. The name of the database user. This can be a lookup key. | ||
Revision as of 18:28, 28 July 2016
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.
