NLIST

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 {
...
%}
%}
%} 


[ Top of Page | Previous Page | Next Page | Index ]