RE: Last record keeps repeating

The file status BIF's (%EOF, %FOUND, etc...) are not updated by SQL
statements. You need to check SQLSTT (preferred) or SQLCOD. SQLSTT will
equal '02000' when there is no more data. You may want to take a look at
the database programming books in the InfoCenter.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Douglas W. Palme
Sent: Friday, September 16, 2005 11:44 AM
To: RPG Group
Subject: Last record keeps repeating

I am using embedded sql to prepare a report of our customer sales totals
for 
a range of dates, however when it hits the last record in the sql query
it 
just keeps repeating itself.

I thought I could end it by using a DOW NOT %EOF statement but
apparently 
that is not correct.

Suggestions on how to exit the loop cleanly?


If you bought, it was hauled by a truck - somewhere, sometime.