RE: Last record keeps repeating

Thanks Matt, I will do that; in addition I appreciate the answer regarding 
the %EOF question.



On Fri, 16 Sep 2005 11:52:36 -0400, Haas, Matt wrote
> 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.
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
> list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L)
>  mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To 
> subscribe, unsubscribe, or change list options, visit: 
> http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-
> L-request@xxxxxxxxxxxx Before posting, please take a moment to 
> review the archives at http://archive.midrange.com/rpg400-l.


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