Queries
Run multiple DB2 queries.
type: "io.kestra.plugin.jdbc.db2.Queries"
Examples
Send a SQL query to a DB2 Database and fetch a row as output.
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
url *Requiredstring
The JDBC URL to connect to the database.
fetchSize integerstring
10000
Number of rows that should be fetched.
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this ResultSet object. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. Ignored if autoCommit
is false.
fetchType string
NONE
STORE
FETCH
FETCH_ONE
NONE
The way you want to store data.
FETCH_ONE - output the first row. FETCH - output all rows as output variable. STORE - store all rows to a file. NONE - do nothing.
parameters object
Parameters
A map of parameters to bind to the SQL queries. The keys should match the parameter placeholders in the SQL string, e.g., : parameterName.
password string
The database user's password.
sql string
The SQL query to run.
timeZoneId string
The time zone id to use for date/time manipulation. Default value is the worker's default time zone id.
transaction booleanstring
true
Transaction
If one query failed, rollback transactions.
username string
The database user.
Definitions
io.kestra.plugin.jdbc.AbstractJdbcBaseQuery-Output
row object
Map containing the first row of fetched data.
Only populated if fetchOne
parameter is set to true.
rows array
List of map containing rows of fetched data.
Only populated if fetch
parameter is set to true.
size integer
The number of rows fetched.
Only populated if store
or fetch
parameter is set to true.
uri string
uri
The URI of the result file on Kestra's internal storage (.ion file / Amazon Ion formatted text file).
Only populated if store
is set to true.