Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Legacy Presto components | Mashables and Mashups | Mashups in EMML | Writing Mashups in EMML | Issuing SQL Statements Directly to a Datasource | <sqlUpdate>
 
<sqlUpdate>
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.

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release