DB SQL Exec

This Database tool is useful when you want to do something with a database other than query. DB SQL Exec can be used to insert data into a database, update a row already in a database, delete data from a database, or run a stored procedures on the server (scripts stored on the database that operate on the data tables).

To use this tool, build a SQL statement using one or more steps created with the Assignment Tool, and pass it in as a string variable. Use this string variable as your SQL Statement Variable on the next page. You can use the & (string append) function in several Assignment steps to build complex SQL statements.

Settings Page

Database Connection

The name of the database connection you created in a DB Get Connection statement.

SQL Statement Variable

The name of the variable that contains the SQL statement. The value of this variable is created with one or more Assignment steps. For more information on building SQL statements, see Sample SQLExec Statements.

Timeout (seconds)

The number of seconds to wait for this operation to complete successfully before taking the failure path. Any value less than or equal to zero results in the default value of 60 seconds being used. You may specify a decimal value, such as 5.5.

Exit Paths

Success

If this step executes successfully, this step takes the Success exit path.

Failure

If this step does not execute successfully, this step takes the Failure exit path. This can occur when the DB connection variable is not valid, or the SQL statement is not valid.