<?xml version='1.0'?>
<?xml:stylesheet type="text/xsl" href="/neon/sampdata/sqlxsl2.xsl" ?>
<!-- Convert any result set to an XML format which allows direct
     processing of the result set data                           -->
<query>
  <!-- Top-level information fields describing the query and
       the overall result set                                    -->
  <plan><%EXECSQL.PLAN%></plan>
  <dbrm><%EXECSQL.DBRM%></dbrm>
  <sql><%EXECSQL.SQLSTMT%></sql>
  <partial-result><%EXECSQL.PARTIAL%></partial-result>
  <columns><%EXECSQL.COLUMNS%></columns>
  <rows><%EXECSQL.ROWS%></rows>
 
  <%IF EXECSQL.ROWS GT 0 %>
  <!-- The result-set container is sent only if any rows were
       returned by the query                                     -->
    <result-set>
      <%IF EXECSQL.COLUMNS GT 0 %>
        <column-info>
        <!-- Column name information returned if any columns were
             returned by the query                               -->
          <%DO EXECSQL.COLUMNS NOADVANCE%>
            <column>
            <column-name><%EXECSQL.COLUMN.<%HTXINDEX%>%></column-name>
            </column>
          <%ENDDO%>
        </column-info>
      <%ENDIF%>
      <%IF EXECSQL.ROWS GT 0 %>
        <row-data>
        <!-- Each individual row of the result set is tagged
             with it's row-number                                -->
          <!-- Each value per row is contained within a cell
               element referenced back to column number and name -->
          <%DO EXECSQL.ROWS ADVANCE%>
            <row row-number="<%HTXINDEX%>">
            <%DO EXECSQL.COLUMNS NOADVANCE%>
              <cell column-number="<%HTXINDEX%>"
                    column-name="<%EXECSQL.COLUMN.<%HTXINDEX%>%>">
                <cell-data><%<%EXECSQL.COLUMN.<%HTXINDEX%>%>%></cell-data>
              </cell>
            <%ENDDO%>
            </row>
          <%ENDDO%>
        </row-data>
      <%ENDIF%>
    </result-set>
  <%ENDIF%>
</query>
