AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
X | X | X | X | X | X | X | X | X |
Purpose
Contains a list of all the column names from the result of a function call or query. The default separator is a space.
You can reference NLIST in REPORT and ROW blocks.
Examples
Example 1: A list of column names with ALIGN
%DEFINE ALIGN="YES" ... %FUNCTION (DTW_SQL) myfunc() { select * from MyTable %report{ Your query was on these columns: $(NLIST). %row { ... %} %} %}
The list of column names uses a space between column names with ALIGN set to YES.
Example 2: A %LIST variable to change the separator to " | "
%DEFINE %LIST " | " NLIST ... %FUNCTION (DTW_SQL) myfunc() { select * from MyTable %report{ Your query was on these columns: $(NLIST). %row { ... %} %} %}