Re: Count records in SQL

Sorry to say, no grouping is required merely to get the count of how 
many records are in the result set. You might thinking of getting how 
many of each instance in a group.

*Regards*

*Vern Hamberg*

IBM Champion 2025 <cid:[email protected]> CAAC 
(COMMON Americas Advisory Council) IBM Influencer 2023


On 2/12/2026 4:06 PM, JOSE PEREZ wrote:
> 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<[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.