<sqlUpdate>

Use <sqlUpdate> to execute any SQL statement that is not a query against a named data source that has been configured by a Presto administrator in the Presto Server or a datasource that you have declared in the mashup script. This includes basic statements to update database records.

Note:

In previous releases, the <sql> and <sqlUpdate> statements were also used to invoke stored procedures. This usage is still supported but deprecated.

You must first define configuration information and name datasources in the Presto Server. This ensures that drivers are available in the classpath. It also keeps database credentials securely encrypted and simplifies EMML code.

You can disable the <sqlUpdate> command to prevent anyone from using direct SQL statements in a mashup.

Can Contain	Empty
Allowed In	mashup \| catch \| else \| elseif \| for \| foreach \| if \| macro \| operation \| sequence \| try \| while

Name	Required	Description
name		The name of the data source for this statement. In most cases, this is the name of a datasource that has been configured in the Presto Server, although the datasource can be declared directly in the mashup script. If omitted, the query is sent to the default data source.
statement	yes	The SQL statement to execute. The actual SQL syntax supported depends on the database and driver class for this data source.
outputvariable		An optional variable to accept the output of this SQL command.