Re: Return count of records from SQL select

[dlclark@xxxxxxxxxxxxxxxx]

"RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx> wrote on 04/06/2018 04:16:53 
PM:
> I must be ready for the weekend, as I can't seem to remember how to do 
this
> in RPG.
>
> I need to know ONLY the number of rows that would be returned from an 
SQL
> select statement.  I don't need to know anything about the rows
> themselves.  The decision I need to make is based on whether the number 
of
> rows from the select statement is zero or greater than zero.


        For static SQL, you can use SELECT INTO:

  Exec select count(*) as aCount into :TheCount from File1;

Sincerely,

Dave Clark