DB2
The DB2 connector provides an API to work with DB2 databases.
This article describes the operations for the DB2 built-in connector, which is available only for Standard workflows in single-tenant Azure Logic Apps. If you're looking for the DB2 managed connector operations instead, see DB2 managed connector reference.
Built-in connector settings
In a Standard logic app resource, the application and host settings control various thresholds for performance, throughput, timeout, and so on. For more information, see Edit host and app settings for Standard logic app workflows.
Connector how-to guide
For more information about connecting to DB2 from your workflow in Azure Logic Apps, see Connect to IBM DB2 from workflows in Azure Logic Apps.
Authentication
Server name
The DB2 server name.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Server name | The DB2 server name. | string | False |
Port number
The port number for the database on the DB2 server.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Port number | The port number for the database on the DB2 server. | int | False |
Database
The name of the database on the DB2 server.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Database | The name of the database on the DB2 server. | string | False |
User name
The user name for accessing the DB2 server.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| User name | The user name for accessing the DB2 server. | string | False |
Password
Password for the DB2 user name
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Password | Password for the DB2 user name | securestring | False |
Package collection
The package collection.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Package collection | The package collection. | string | False |
Default schema
The default schema for schema calls.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Default schema | The default schema for schema calls. | string | False |
Host CCSID
The host coded character set identifier (CCSID) of the DB2 database.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Host CCSID | The host coded character set identifier (CCSID) of the DB2 database. | int | False |
PC code page
The PC code page for the DB2 connection.
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| PC code page | The PC code page for the DB2 connection. | int | False |
Additional connection string keywords
Optional keywords. For example, 'Default Qualifier=User2;DBMS Platform=DB2/AS400'. Multiple values should be separated by semi-colons
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Additional connection string keywords | Optional keywords. For example, 'Default Qualifier=User2;DBMS Platform=DB2/AS400'. Multiple values should be separated by semi-colons | int | False |
Connection string
DB2 connection string
Parameters
| Name | Description | Type | Required | Allowed Values |
|---|---|---|---|---|
| Connection string | DB2 connection string | securestring | False |
Actions
| DB2 tables |
Return tables in DB2 schema. |
| Delete row |
Delete row or rows. |
| Execute a stored procedure |
Stored procedure |
| Execute non-query |
Execute a SQL command that does not return a result set. |
| Execute query |
Execute a SQL query. |
| Insert row |
Insert a row. |
| Update rows |
Update row or rows. |
DB2 tables
Return tables in DB2 schema.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Schema
|
schema | string |
The name of the schema. |
Returns
The DB2 tables.
- DB2 tables
- array
Delete row
Delete row or rows.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
The name of the table. |
|
Columns used in the 'WHERE' clause
|
searchCondition | True | object |
Column names with the values used to determine which rows to delete. |
Execute a stored procedure
Stored procedure
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Stored procedure
|
procedureName | True | string |
The name of the stored procedure. |
|
Stored procedure parameters
|
procedureParameters | string |
The parameters for executing the stored procedure. |
Returns
The output from executing the stored procedure.
- Output
- array
Execute non-query
Execute a SQL command that does not return a result set.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
SQL statement
|
statement | True | string |
The SQL statement to execute. |
|
Statement parameters
|
sqlParameters | object |
The parameters for the SQL query. |
Execute query
Execute a SQL query.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Query
|
query | True | string |
The SQL query. |
|
Query parameters
|
queryParameters | object |
Parameters for the SQL query. |
Returns
The result of the SQL query.
- Result
- array
Insert row
Insert a row.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
The name of the table. |
|
Values to insert
|
insertParameters | True | object |
The column names with the values to insert. |
Update rows
Update row or rows.
Parameters
| Name | Key | Required | Type | Description |
|---|---|---|---|---|
|
Table name
|
table | True | string |
The name of the table. |
|
Values to update
|
updatedColumns | True | object |
The names of columns with the updated values. |
|
Columns used in the 'WHERE' clause
|
searchCondition | True | object |
The names of columns with the values that determine the rows to update. |