Queries Queries
Queries Certified

yaml
type: "io.kestra.plugin.jdbc.as400.Queries"
yaml
id: as400_queries
namespace: company.team

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