Insert process
The Insert process inserts rows into a designated table in an SQL database. If an SQL exception occurs while attempting to perform the operation (owing to a failure to provide a required column, a mismatch between the columns and value parameters being detected, or some other issue), the Compensation process executes. This process handles any necessary CDATA wrapping for SQL statements. The inputs must contain plain SQL statements.
The following table describes the process inputs for the SQL adapter with the Insert process.
SQL adapter Insert process inputs
There are no defined outputs for this process.
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*