BUEHLER
15 pts. | Sep 30 2009 7:21PM GMT
Steve,
Thanks, but where would you enter this SQL in DB2 Web Query Report Assistant in order to show the count of # of rows on the report (to be similar to the row count in Query/400?
Meandyou
1840 pts. | Oct 1 2009 2:21PM GMT
Since I don’t know Web Query Report Assistant I can’t say where one would put it.
Could you use a UNION to append the COUNT to your original query?
SELECT …
FROM …
WHERE …
UNION
SELECT ‘value’ , COUNT(*)
FROM …
WHERE …
ORDER BY …
where ‘value’ is high value ( like x’FF’ ) to force that row to sort last






