Count records in SQL

Jerry Forss <[email protected]> Thu, 12 Feb 2026 20:15:46 +0000

Newsgroups	gmane.comp.lang.as400.rpg
Message-ID	<BL1PPF07C40B43AD7D85A1DABCAB64DB623C660A@BL1PPF07C40B43A.namprd22.prod.outlook.com>

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.