
Query
Query
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*Requiredstring
url*Requiredstring
afterSQLstring
fetchSizeintegerstring
Default
10000fetchTypestring
Default
NONEPossible Values
STOREFETCHFETCH_ONENONEparametersobject
passwordstring
timeZoneIdstring
usernamestring
Outputs
rowobject
rowsarray
SubTypeobject
sizeinteger
uristring
Format
uriMetrics
fetch.sizecounter
Unit
rows