SQL Execute

Performs a data or database modifying SQL query against a JDBC or JNDI data source. The result of execution is a resultset containing number of rows affected and status, as detailed below. The query may contain references to parameters by enclosing the parameter in curly braces. For example update myTable set column = 'newvalue' where department = '{dept}' would replace {dept} with the value of the parameter named "dept".

Component Name: SQLExecute

Inputs:

REQUIRED
JNDI Name - Name of the JNDI connection.

or the following JDBC information

JDBC Driver - The JDBC driver to use when connecting to the data source.
JDBC Connection String - The connection string identifying the location of the data source.
JDCB User Name - User name to use when connecting to the data source.
JDBC Password - Password to use when connecting to the data source.

OPTIONAL
Keep Connection Open _-- If selected the query results are retrieved from the data source as needed, otherwise the entire query results are brought over from the data source and cached in memory. It is recommended that you set this option with larger datasets. Never use this option if you are storing the resultset in the session.

Note: Any parameter may be referenced in the query by enclosing the parameter in curly braces.

Outputs:

Result Set Name-- The name of the parameter in which to store the query results.