SQL Operation Tab

The following list describes the properties on the SQL Output Record Properties dialog box SQL Operation tab:

Data Source

List of the associated data sources.

Table/View

List of the database tables for the selected data source.

Insert
Update
Delete

Operation that the translator performs against the table.

Automatically change and retry operation when needed

If you select this check box and also select:

• Insert and a row already exists, the translator performs an update.
• Update and a row does not exist, then the translator performs an insert.

On failure, automatically switch selected operation and retry Inserts as Updates or Updates as Inserts

If selected, if the operation is not completed the translator will automatically switch the operation type (that is, update to insert or insert to update) and retry the operation.

When the Delete option is selected, this check box is inactive because it does not apply to the delete operation.