Re: Count records in SQL

However yes GET DIAGNOSTICS work.

Yahoo Mail: Search, Organize, Conquer 
 
  On Thu, Feb 12, 2026 at 3:43 PM, Jimmy Sansi<[email protected]> wrote:   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.

  
-- 
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.