Description

Executes relational database commands using SQL. See the SQL Execute section of the Actions and Component Reference for more details.

Inputs and Outputs

Database Connection Type - Specifies the type of connection to be used to connect to the database.

• JDBC - Connect using a standard JDBC connection. The following inputs must also be provided.
  • JDBC Drive - Name of the JDBC driver class to use when connecting to the database.
  • Database URL - The database connection URL.
  • User Name - The username to use when connecting to the database.
  • Password - The password to use when connecting to the database.
• JNDI - Connect using the specified JNDI name.
• Shared - Connect to the database using the named shared connection. See the Shared Relational Connection action for further details

SQL Commands - A list of SQL commands, separated by the provided command separator.
Output - the name of the result-set that contains the affected rows

Submit to DB Server as Single Command - Normally the commands are split via semi-colons, but with this enabled, the splitting step is skipped and the raw SQL provided is sent to the database engine.
Command Separator - separator token used when splitting commands
Continue processing commands on error - If an error occurs in one of the sql commands provided, continue execution of the additional commands.