Defining write statements

Write statements define a delete, insert, or update statement against a specified data provider. Write statements enable administrators to delete, insert, or update column values in a data provider from within a workflow.

The following procedures explain how to configure simple and advanced write statements

Note:

Advanced write statements enable users with knowledge of SQL to write insert, update, or delete SQL statements.

To define a simple write statement
  1. Select the Query activity, click Properties and, after Write statement, click the Browse button.
  2. Select Simple Write and select a Write Type from the drop-down list. Options vary by data provider.
  3. After Table Name, select the table in the data provider against which the write statement is defined.
  4. Under Column Name, select a column in the data provider against which the write statement is defined.
  5. Under Value, select the data to be inserted into the data provider.
  6. Under Where, select a column name.
    Note:
    • ‘Where’ statements display only if Delete or Update is selected
    • The column names displaying in the list derive from the Table Name selected.
  7. Select an operator from the drop-down list
    • =
    • <>
    • >
    • <
    • >=
    • <=
  8. From the third drop-down list, select or type the variables used to evaluate the information selected from the first column
  9. To test the write statement, click Test Syntax.
  10. To empty column values, click Clear. To accept the write statement, click OK.
  11. Click Save.
To define an advanced write statement
  1. Select the Query activity, click Properties.
  2. After Write statement, click the Browse button and select the Advanced Write button.
  3. Under Query, type the insert, update, or delete SQL statements to be run against the data provider and click Execute.
  4. The Parameter name column will be populated with the column names in the data provider.
  5. Under Variable Name, from the drop-down list, select the variables used to evaluate the information you selected from the first column.
  6. To test the write statement, click Test Syntax.
  7. To empty column values, click Clear. To accept the write statement, click OK.
  8. Click Save.
Parent topic: Configuring the Query activity