DB Write Step

Use the DB Write step to select a database and enter SQL UPDATE, SQL DELETE, or SQL INSERT statements.

You can use this step to update an enterprise database. When you are finished with a database write operation, use the DB Release step to free the connection to the database server.

The DB Write step has three output branches:

• Successful—The DB Write step successfully enters the specified SQL statements.

• Connection Not Available—The DB Write step can not find a connection to the specified database.

• SQL Error—The DB Write step encounters a SQL command error.

The DB Write customizer window contains four tabs:

• General tab (DB Write step)

• SQL tab (DB Write step)

• Test tab (DB Write step)