Ad Hoc Update process
The AD Hoc Update process executes an ad hoc update against an SQL database. 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 Ad Hoc Update process.
SQL adapter Ad Hoc Update process inputs
The following table describes the process output parameters for the SQL adapter with the Ad Hoc Update process.
SQL adapter Ad Hoc Update process output
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*