MapepireInstall

Summary

Executes an SQL statement or a CL command on IBM i through Mapepire for each incoming item. SQL results can be returned together or split into one output item per row; CL results include success, data, and a message.

Inputs

• Mode — Choose SQL (default) or CL Command.
• SQL — SQL statement to run in SQL mode; defaults to values current date. Fetches results in pages using Fetch Size.
• CL Command — CL command to run in CL mode; defaults to DSPLIBL.
• Fetch Size — Number of SQL result rows to fetch per page; defaults to 100.
• Additional Fields — Optional SQL settings: Terse Results requests compact rows; Include Metadata adds column metadata and update count; Reuse Connection shares one connection across input items; Use Parameters with Parameters (JSON) supplies an array or object of SQL parameters; Query Timeout (ms) sets a timeout, with 0 meaning none; Output Mode selects one item containing all rows or one item per row.

Output shape

A list of n8n items, produced for each input item.

SQL's default output is one item with rows, metadata, and updateCount (metadata and update count are omitted when Include Metadata is false). Output Mode One Item Per Row returns items with row and, when enabled, metadata. CL mode returns success, data, and message. If Continue On Fail is enabled, errors are returned in an error field.

Links

• n8n community nodes installation guide