Re: Number of rows returned by a fetch

[Reeve <rfritchman@xxxxxxxxx>]

Before you close your cursor:
     EXEC SQL GET DIAGNOSTICS :row_retrieved = ROW_COUNT;

On Mon, May 31, 2021 at 11:25 AM <stefan@xxxxxxxxxx> wrote:

>       rowsreturned = SQLErrd(3);
>
> Best regards
>
> Stefan
>
> Hi,
>
> If I issue a "fetch for 20 rows into myArray" type command in a SQLRPGLE
> program, where can I get the number of rows actually returned if it is less
> than 20?
>
> Thanks
> --
>
> --
> 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.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com