QueriesQueries
QueriesCertified

yaml
type: "io.kestra.plugin.jdbc.db2.Queries"
yaml
id: db2_query
namespace: company.team

tasks:
  - id: queries
    type: io.kestra.plugin.jdbc.db2.Queries
    url: jdbc:db2://127.0.0.1:50000/
    username: "{{ secret('DB2_USERNAME') }}"
    password: "{{ secret('DB2_PASSWORD') }}"
    sql: select * from employee; select * from laptop;
    fetchType: FETCH
Properties
Default10000
DefaultNONE
Possible Values
STOREFETCHFETCH_ONENONE
Defaulttrue
Definitions
rowobject
rowsarray
SubTypeobject
sizeinteger
uristring
Formaturi
Unitrows