Re: SQL Record Count

Duane,

The third element of the array, SQLERRD in the SQLCA should contain
the number you are looking for.   The SQLCA should be included when
you compile your program.  Look at your listing.  You should see this
array.

Regards,

Russell Conerly
IBM Certified Specialist -- RPG IV Devleoper
Tupelo, MS 


-------------------
>   When deleting records using embedded SQL, is it possible to
retrieve a
> count of the number of records deleted and use that value in my
program?
> 
>       Duane Johnson
>       Information Technology Services
>       Programming Manager
>       Coleman Powermate Inc.
>       4970 Airport Rd.
>       Kearney, NE 68847
>       djohnson@xxxxxxxxxxxxx
> 
> _______________________________________________
> 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.
> 
>