Unsupported content This version of the product has reached end of support. The documentation is available for your convenience. However, you must be logged in to access it. You will not be able to leave comments.

Select process

The Select process issues a select statement against an SQL database, retrieving a set of rows. 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 Select process.

 SQL adapter Select process inputs

The following table describes the process output parameter for the SQL adapter with the Select process.

 SQL adapter select process output

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*