Query
yaml
type: "io.kestra.plugin.jdbc.as400.query"Examples
yaml
id: as400_query
namespace: company.team
tasks:
- id: query
type: io.kestra.plugin.jdbc.as400.Query
url: jdbc:as400://127.0.0.1:50000/
username: "{{ secret('AS400_USERNAME') }}"
password: "{{ secret('AS400_PASSWORD') }}"
sql: select * from as400_types
fetchType: FETCH_ONE
Properties
url *Requiredstring
fetchSize integerstring
Default
10000fetchType string
Default
NONE Possible Values
STOREFETCHFETCH_ONENONEparameters object
password string
sql string
timeZoneId string
username string
Outputs
row object
rows array
SubType object
size integer
uri string
Format
uri