AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | 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) %}