RE: SQLRPG - prepare, declare, no cursor

Rick leave out the EXECUTE step of your example here.  I do not believe
you can use EXECUTE or EXECUTE IMMEDIATE to return a record count.
EXECUTE is not used with cursors and fetches.  Also, validate the SQLSTT
value after each step except for DECLARE. 

Thanks, Matt



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rick baird
Sent: Tuesday, April 11, 2006 1:43 PM
To: RPG programming on the AS400 / iSeries
Subject: SQLRPG - prepare, declare, no cursor

Hey all,

I know if done this before, but I'm drawing a blank.

I'm building a dynamic sql statement (variable 'where' clause, could
contain as few as one, as many as 6 fields to compare in my where
statement).

All i want is the record count  -  count(*), moved into a host
variable - so there will be no cursor - only a single fetch of the
record count.

which of the following steps do I need to run, in order, to do this?

prepare
declare
execute
open
fetch

I RTFM'd, but I'm not getting anywhere.

Thanks!