Re: Count records in SQL

Hi Jimmy,

First

D count    s   10i 0

Select Count(*) into :count From
(your SQLrequest)

The request is on db2 "cache", if think is a good solution.

Regards,

-- 
Bruno VARON

Le jeudi 12 février 2026 à 12:43 -0800, Jimmy Sansi a écrit :
> What about ...
> 
> exec sql GET DIAGNOSTICS :Rows = ROW_COUNT;
> 
> https://www.ibm.com/docs/en/i/7.5.0?topic=statements-get-diagnostics
> 
> On 2026-02-12 12:15, Jerry Forss wrote:
> 
> > I have a SQL
> > SqlSelect = 'SELECT C6DcCd, ' +
> > 'C6CvNb, '+
> > 'C6AcDt, ' +
> > 'C6FnSt,' +
> > 'C6B9Cd  ' +
> > 'From ' + %Trim(PurgeXALib) + '/MBC6REP ' +
> > 'Where C6ACDT <= ' + %EditC(PurgeDateCYMD : 'X');
> > 
> > Instead of reading through the cursor, I want the number of records
> > found.
> > 
> > How do I do that?
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.