Mashups in EMML : Writing Mashups in EMML : Issuing SQL Statements Directly to a Datasource : <sqlUpdate>
<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 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.
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 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.
Copyright © 2013-2015 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback