Query

Query

Certified

Execute a single SQL query against IBM DB2

yaml
type: io.kestra.plugin.jdbc.db2.Query

Examples

yaml
id: db2_query
namespace: company.team

tasks:
  - id: query
    type: io.kestra.plugin.jdbc.db2.Query
    url: jdbc:db2://127.0.0.1:50000/
    username: "{{ secret('DB2_USERNAME') }}"
    password: "{{ secret('DB2_PASSWORD') }}"
    sql: SELECT * FROM db2_types
    fetchType: FETCH_ONE

Properties

sql *string

url *string

afterSQL string

fetchSize integerstring

Default10000

fetchType string

DefaultNONE

Possible Values

STOREFETCHFETCH_ONENONE

parameters object

password string

timeZoneId string

username string

Outputs

row object

rows array

SubTypeobject

size integer

uri string

Formaturi

Metrics

fetch.size counter

Unitrows

Apache Spark

Tasks that submit Apache Spark jobs and run Spark CLI commands.

DataInfrastructure

Duckdb

Tasks that connect to DuckDB via JDBC to run queries and loads.

Data

Query Certified Execute a single SQL query against IBM DB2

More Plugins in this Category

Apache Spark

Duckdb

Query

Certified

Execute a single SQL query against IBM DB2