ODBC/JDBC Gateway icon

ODBC/JDBC Gateway

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

Actions9

Query → Execute Query

AI-generated

Summary

Executes the supplied SQL against a preconfigured ODBC/JDBC Gateway connection and returns query results. Use positional ? placeholders with the optional Parameters array; enable Preview to cap results at 100 rows.

Inputs

  • Connection Name or ID (required) — Select the gateway connection to use, or provide its ID with an expression.
  • SQL (required) — SQL statement to execute.
  • Preview (Max 100 Rows) — Defaults to false. When enabled, caps query results at 100 rows; this takes precedence over Max Rows.
  • Split Rows Into Items — Defaults to true. Returns one item per result row, with column names as fields. When disabled, returns the raw gateway response in one item.
  • Options: Parameters — JSON array of positional values for ? placeholders. Defaults to [].
  • Options: Max Rows — Positive value caps returned rows when Preview is off. Defaults to 0, which leaves the gateway's row limit in effect.

Output shape

With Split Rows Into Items enabled, returns one item per row with named columns; when there are no rows, returns one item with connection, row_count, columns, and affected_rows. With splitting disabled, returns one item containing the raw gateway response.

The operation sends the connection, SQL, optional parameters, and applicable row limit to the gateway's /query endpoint. SQL may be any statement accepted by the gateway; this operation does not enforce that it is a SELECT. Errors stop execution unless the node is configured to continue on fail.

Links

Discussion