Re: Count records in SQL

Glenn Gundermann <[email protected]> Thu, 12 Feb 2026 15:30:43 -0500

Newsgroups	gmane.comp.lang.as400.rpg
Message-ID	<CAOw_mOdDeXHUPQ_WvjoPN6i=Egm2XPom+k7G5h=EEFJMp7q2Xg@mail.gmail.com>

  SqlSelect = 'SELECT count(*) ' +
               'INTO  :countVar ' +
               'From ' + %Trim(PurgeXALib) + '/MBC6REP ' +
               'Where C6ACDT <= ' + %EditC(PurgeDateCYMD : 'X'

Yours truly,

Glenn Gundermann
Email: [email protected]
Cell: (416) 317-3144




On Thu, 12 Feb 2026 at 15:15, Jerry Forss <[email protected]> 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: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org 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: RPG400-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.