Re: Count records in SQL

[JOSE PEREZ <joseenocperez.jp@xxxxxxxxx>]

If I'm not wrong you need a group by to count so group by C6ACDT

Yahoo Mail: Search, Organize, Conquer 
 
  On Thu, Feb 12, 2026 at 3:43 PM, Jimmy Sansi<jsansi@xxxxxxxxx> 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?