SQL tab (DB Write step)

Use the SQL tab of the DB Write customizer window to define SQL UPDATE, SQL DELETE, or SQL INSERT statements that will update the chosen database.

DB Write Customizer Window—SQL Tab

The following table describes the properties of the SQL tab of the DB Write customizer window:

Properties / Buttons

Description

Enter SQL command to be executed

SQL command that you want to be executed.

Note	Enter the SQL UPDATE, SQL DELETE, or SQL INSERT statements, using standard SQL syntax.

Show All Fields (Select Table)

Use this drop-down list to select the table from the database and display all fields.