Re: Embedded SQL, first steps

Adam Glauser wrote:

My question is this: is there a way to determine the number
of rows selected?

Al Mac wrote:

In embedded SQL, and other SQL/400 for that matter, you can get a

COUNT(*) of some record selection
which tells you HOW MANY records (rows)
were involved in whatever you were doing.

Al -
Am I correct that you mean I would first do my "SELECT field1, field2" 
query, then do a "SELECT COUNT(*)" query with the same WHERE/GROUP BY/ 
HAVING?  I was hoping there would be some sort of count in the data 
structures returned by the DBMS.  Is there significant processing involved 
with doing the COUNT(*) query, or does the DBMS somehow cache the results 
from the initial SELECT?

Thanks for the tip,
Adam


#####################################################################################
Attention:
The above message and/or attachment(s) is private and confidential and is 
intended 
only for the people for which it is addressed. If you are not named in the 
address 
fields, ignore the contents and delete all the material. Thank you. Have a nice 
day.

For more information on email virus scanning, security and content
management, please contact administrator@xxxxxxxxxxxx
#####################################################################################