<!doctype html>
<html>
<head>
<title>Statements Configuration</title>
<link rel="stylesheet" href="styles/site.css" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel="stylesheet" href="styles/icons.css" type="text/css">
<script src="js/jquery.min.js"></script>
<script src="tree/collapsibleTreeMenu.js"></script>
<link href="tree/collapsibleTreeMenu.css" rel="stylesheet" type="text/css">
</head>
<body class="theme-default aui-theme-default">
<div id="page">
<div id="main" class="aui-page-panel">
<div id="main-header">
<div id="breadcrumb-section">
<ol id="breadcrumbs">
<li> <span><a href="Rhapsody-Integration-Engine-6.5_133160975.html">Rhapsody Integration Engine 6.5</a></span> </li>
<li> <span><a href="Developing-Rhapsody_133161055.html">Developing Rhapsody</a></span> </li>
<li> <span><a href="Database-Configuration_133161571.html">Database Configuration</a></span> </li>
<li> <span><a href="Database-Component-Configuration-Reference_133161758.html">Database Component Configuration Reference</a></span> </li>
</ol>
</div>
<h1 id="title-heading" class="pagetitle"> <span id="title-text">Statements Configuration</span> </h1>
</div>
<div id="content" class="view">
<div id="main-content" class="wiki-content group">
<p>The XML configuration file includes statement and SQL elements:</p>
<div class="table-wrap">
<table class="confluenceTable">
<tbody>
<tr>
<th class="confluenceTh"><p>Element</p></th>
<th class="confluenceTh"><p>Description</p></th>
</tr>
<tr>
<td class="confluenceTd"><p>Statement</p></td>
<td class="confluenceTd"><p>The statement element contains one SQL element that will be executed and a number of other statement elements that will each be executed for every row returned by the SQL statement.</p></td>
</tr>
<tr>
<td class="confluenceTd"><p>SQL</p></td>
<td class="confluenceTd"><p>The <span>SQL</span> element contains a <span>SQL</span> statement to execute. This statement can contain <code>@columnName</code>, <code>@messageFieldName</code>, or <code>$propertyName</code> variables.</p></td>
</tr>
</tbody>
</table>
</div>
<p> </p>
</div>
</div>
</div>
</div>
</body>
</html>