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) %}