RE: SQLRPG - prepare, declare, no cursor

You will get no argument from me on the amount of work point.  I had
assumed in the past that SQLER3 would return the total number of records
for a record set, but I was completely wrong there.  I had looked at
using SET (variable) but it requires a hard coded 1 row sub-select. 

Moral to the story, don't give your users any flexibility in selecting
what the want to filter out and sort on and getting the count becomes
easy.

Thanks, Matt



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

That's what I ended up doing - prepare-declare cursor-open-fetch-close.

I'm not ready to compile and test yet - many more subroutines to
write, but i think this is the ticket.

it does seem like an awful lot of work though, doesn't it?

thanks for the help.