Issuing SQL Statements Directly to a Datasource

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.