JDBC - Insert rows (batch) action
The Insert rows batch action inserts multiple rows into a table in JDBC.
You can use this action to add batches of records to a database table in a single request. Batch inserts improve performance when you process large datasets.
VERSION REQUIREMENT
This action requires On-prem agent (OPA) version 31.0 or later.
Input
| Input field | Description |
|---|---|
| Table name | Select the table to insert rows into. Choose a table from the pick list or enter the full table name. Some databases enforce case-sensitive table names. |
| Return primary keys | Select Yes to return primary keys for the inserted rows in the action output. Select No to improve performance when you don't need primary keys. |
| Rows | Provide a list of rows to insert into the selected table. Map a list datapill to the Rows source list, then map datapills to the corresponding Rows fields. |
Output
| Output field | Description |
|---|---|
| Keys | Primary keys generated for the inserted rows. Returned when Return primary keys is set to Yes. |
Last updated: