Thanks Matt On Wed, 26 Oct 2005 11:27:30 -0400, Matt.Haas wrote > You need to check either SQLSTT for 02000 or SQLCOD for 100. > Generally speaking, you want to process records while the first two > characters of SQLCOD are either '00' (success) or '01' (warning). > You'll need to check the SQLCOD and SQLSTT reference in the > InfoCenter to see if you want to ignore the warnings or not. > > Matt > > -----Original Message----- > From: rpg400-l-bounces@xxxxxxxxxxxx > [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Douglas W. Palme > Sent: Wednesday, October 26, 2005 11:09 AM > To: RPG Group > Subject: embedded sql > > When using embedded SQL in RPG, I need to know when there are no > more records to process from the query, I know that I can use a > count(*) statement but that seems completely inefficient. > > Is there not an SQL variable that I can use to determine that the SELECT > > INTO statement has no more records to process? > > I checked the embedded SQL programming guide but did not find > anything relevant to RPG > > If you bought it, 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, it was hauled by a truck - somewhere, sometime.
This mailing list archive is Copyright 1997-2015 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact