%{----------------------------------------------------------------------%}
%{ Table1.ndm - Net.Data message handling, example 1. %}
%{ %}
%{ Copyright (c) 2001, Craig Pelkie %}
%{ ALL RIGHTS RESERVED %}
%{----------------------------------------------------------------------%}
%{----------------------------------------------------------------------%}
%{ Define section for the macro. %}
%{----------------------------------------------------------------------%}
%define {
DTW_HTML_TABLE = "YES"
%}
%{----------------------------------------------------------------------%}
%{ RUNSQL - run the SQL statement, generate default report %}
%{----------------------------------------------------------------------%}
%function(DTW_SQL) RUNSQL() {
select * from qiws.qcustcdt where cusnum = 111111
%}
%{----------------------------------------------------------------------%}
%{ INPUT - initial section called, runs RUNSQL macro function %}
%{----------------------------------------------------------------------%}
%html(INPUT) {
Net.Data macro Table1.ndm
Net.Data macro Table1.ndm
@RUNSQL()
@dtw_assign("a")
** END **
%}