Definition

Specify a label for this task.

Select a pre-configured database server from the drop down list.

Specify whether or not to commit the changes automatically. A value of 'true' means that the changes will be committed automatically after executing each query. A value of 'false' means that an explicit commit will be issued after successfully executing all queries. If any of the query fails for any reason, a rollback is issued.

Specify the JDBC driver to use to connect to the target database. The driver need not exist in the dropdown menu, but must be installed in

Managed File Transfer

before it can be used. Specifying this value is only necessary if a Database Server resource was not selected or if it is desired to override the JDBC Driver specified in the Database Server resource.

Specify the connection information for the specified database server. The syntax for specifying the connection information is driver dependent. A JDBC URL Wizard has been provided to assist with generating JDBC URLs. Click the '..' button to launch the JDBC URL Builder. Specifying this value is only necessary if a Database Server resource was not selected or if it is desired to override the JDBC URL specified in the Database Server resource.

Specify a user name for logging in to the specified Database Server. This is only necessary if a Database Server resource was not selected or if it is desired to override the user name specified in the Database Server resource.

Specify a password for logging into the specified database. This is only necessary if a Database Server resource was not selected or if it is desired to override the password specified in the Database Server resource.

Specify whether or not the password is encrypted.

The version of this task.

Specify the level of logging to use while executing this task. Valid options are - silent, normal, verbose and debug.

Specify a condition that must be satisfied before this task can be executed. This task will be skipped if the specified condition is not met.

Whether or not this task is disabled.

Specify the action to take when this task errors out. Valid options are - abort, continue, call:[module] and setVariable:[name]=[value]. For call:[module] replace [module] with the name of the module in the project (e.g. call:ErrorModule). For setVariable:[name]=[value] replace [name] with a variable name and [value] with the variable value (e.g. setVariable:error=true).