Insert multiple records into a database
You can insert multiple records into a database table.
Use the Perform multiple inserts option to insert either all data or specific data from the selected rows. For example, you can select to add records for all new accounts (clients) to a bank customer database or add records only for clients who reside in New York.
The Perform multiple inserts option is not available for process maps (Data access activity).
The following table defines the outcome of different selection criteria.
Selection Criteria | DB Query Outcome |
---|---|
|
A single row is inserted into the database table. |
|
Multiple rows are inserted into the database table. |
|
Even though one row is selected, all rows are inserted into the database table. |
|
Multiple rows are inserted into the database table. |
|
No data is populated into the database table. |
|
One row is inserted into the database table. |
|
Multiple rows are inserted into the database table. |
|
No data is inserted into the database table. |
|
One row is inserted into the database table. |
|
Even though multiple rows are selected, only the last selected row is inserted into the database table. |
|
Multiple rows are inserted into the database table. |
|
Multiple rows are inserted into the database table. |
|
One row is inserted into the database table. |