<sqlUpdate>

<sqlUpdate> Examples

Use <sqlUpdate> to execute any SQL statement that is not a query against a named data source that has been configured by a MashZone NextGen administrator in the MashZone NextGen 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 MashZone NextGen 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.

For more information and examples, see Inserting, Updating or Deleting Records, Handling Table or Column Names with Spaces and Explicitly Declaring the Datasource.

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

Attributes

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 MashZone NextGen 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.