EXECSQL Merge Example

Query Status

<%EXECSQL.ROWS%> rows were fetched by execution of the query:

<%EXECSQL.SQLSTMT%>

Column Information

There are <%EXECSQL.COLUMNS%> columns in each result set row. <%IF EXECSQL.COLUMNS LT 1%> <%EXIT%> <%ENDIF%> The column names are:

<%DO EXECSQL.COLUMN.0 NOADVANCE%>
• <%EXECSQL.COLUMN.<%HTXINDEX%>%> <%ENDDO%>

Result Set Row Data

Result Set Data formatted as a list is:

<%DO EXECSQL.ROWS ADVANCE%>
• Result Row <%EXECSQL.ROW%>:
  <%DO EXECSQL.COLUMNS NOADVANCE%>
  • <%EXECSQL.COLUMN.<%HTXINDEX%>%> = <%<%EXECSQL.COLUMN.<%HTXINDEX%>%>%> <%ENDDO%>
  <%ENDDO%>