MashZone NextGen 10.2 | Appendix | Legacy Presto components | Mashables and Mashups | Mashups in EMML | Writing Mashups in EMML | Issuing SQL Statements Directly to a Datasource
 
Issuing SQL Statements Directly to a Datasource
 
<sql>
<sqlUpdate>
<sqlcall>
In addition to invoking Database mashables, you can issue individual SQL statements on datasources in a mashup script. You can send queries with the <sql> statement or issue any other SQL statement with <sqlUpdate>. EMML also includes statements to manage SQL transactions (see SQL Transactions). You can also invoke stored procedures directly with <sqlcall>.
Note: Although EMML supports issuing SQL statements on multiple databases within one mashup script, it does not support distributed transactions.
MashZone NextGen administrators must define data sources for the databases that you want to work with in the Admin Console.
In rare cases, you may also need to explicitly define datasources in mashup scripts. See Declaring Data Sources and Configuring Datasource Drivers for more information.

Copyright © 2013-2018 | 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