ODBC/JDBC Gateway icon

ODBC/JDBC Gateway

Esegue query SQL su RDBMS multipli tramite il gateway ODBC/JDBC

Actions9

Query → Execute Statement

AI-generated

Summary

Executes the supplied SQL statement on a preconfigured ODBC/JDBC Gateway connection, with optional positional parameters and a row limit. For this operation, it returns the connection used, affected row count, and elapsed time for each input item.

Inputs

  • Connection Name or ID (required) — Select or enter the gateway connection to use.
  • SQL (required) — The SQL statement to execute, such as an INSERT, UPDATE, DELETE, or DDL statement.
  • Options → Parameters — A JSON array of positional values for ? placeholders in the SQL. Invalid JSON produces an error.
  • Options → Max Rows — Maximum rows to return; the default is 0, which leaves the gateway default in effect. The source sends this only when the value is greater than 0.

Output shape

One item per input item, containing connection, affected_rows, and elapsed_ms.

affected_rows is null when the gateway response omits it. With Continue On Fail enabled, an item error is returned as { "error": "..." }.

Links

Discussion