IBM Books

Reference

TOTAL_ROWS


AIX HP-UX Linux OS/2 OS/390 OS/400 SCO SUN Win NT
X X X X X X X X X

Purpose

The total number of rows a query returns, no matter what the value of upper_limit for the TABLE language construct. For example, if RPT_MAX_ROWS is set to display a maximum of 20 rows, but the query returns 100 rows, this variable is set to 100 after ROW processing.

Operating system differences:

Language Environment Restriction: Use this variable only with the following database language environments:

Required: You must set DTW_SET_TOTAL_ROWS to YES to use this variable. See DTW_SET_TOTAL_ROWS for more information.

Examples

Example 1: Displays the total number of names found

%DEFINE DTW_SET_TOTAL_ROWS="YES"
 
%REPORT{
<H2>E-mail directory</H2>
<UL>
%ROW{
<LI>Name: <a href="mailto:$(V1)">$(V2)</a><BR>
Location: $(V3)
%}
</UL>
Names found: $(TOTAL_ROWS)
%}


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