Newbie Question...

  Hi,  

    is there a clean way to store the number of rows obtained from     an SQL query into a variable?

  (ex.)

    EXEC SQL SELECT *

	INTO :foo
	FROM BAR
	WHERE <fooCondition>;

    no_rows = <some way to read the number of rows obtained
	from the query>.