RE: embedded sql

["Douglas W. Palme" <dpalme@xxxxxxxxxxx>]

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.