Partager via


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.