<?xml version="1.0" encoding="iso-8859-1"?>
<?xml-stylesheet href="../make-menu.xsl" type="text/xsl"?><html>
   <head>
      <this-is section="sql-extension" page="execute" subpage=""/>
      <!--
           Generated at 2011-12-09T20:47:22.916Z--><title>Saxonica: XSLT and XQuery Processing: sql:execute</title>
      <meta name="coverage" content="Worldwide"/>
      <meta name="copyright" content="Copyright Saxonica Ltd"/>
      <meta name="title" content="Saxonica: XSLT and XQuery Processing: sql:execute"/>
      <meta name="robots" content="noindex,nofollow"/>
      <link rel="stylesheet" href="../saxondocs.css" type="text/css"/>
   </head>
   <body class="main">
      <h1>sql:execute</h1>
      <p>The <code>sql:execute</code> instruction allows arbitrary SQL statements to be executed.
There are two attributes (and no content). The <code>connection</code> attribute is an XPath expression
whose value is the SQL connection created using <code>sql:connection</code>. The <code>statement</code>
attribute is an attribute value template whose effective value is the SQL statement to be executed.
No result is returned.</p>
      <p>The statements <code>COMMIT WORK</code> and <code>ROLLBACK WORK</code> (spelt exactly like that) are
recognized specially, and cause calls on the JDBC <code>connection.commit()</code> and <code>connection.rollback()</code>
methods respectively.</p>
      <table width="100%">
         <tr>
            <td>
               <p align="right"><a class="nav" href="example.xml">Next</a></p>
            </td>
         </tr>
      </table>
   </body>
</html>