Re: Count records in SQL

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

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

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144




On Thu, 12 Feb 2026 at 15:15, Jerry Forss <JForss@xxxxxxxxxxxxx> 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: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.