Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

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*