Issuing SQL Statements to a Datasource

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 (see Invoking Stored Procedures).

Note: although EMML supports issuing SQL statements on multiple databases within one mashup script, it does not support distributed transactions.

You must define data sources for the databases you want to work with and configure their drivers in Mashup Studio . See Declaring Data Sources and Configuring Datasource Drivers for more information.

Enterprise Mashup Markup Language (EMML) Documentation is licensed
under a Creative Commons Attribution-Share Alike 3.0 United States License.