Embedded SQL record count -Reply

>>> Dan Swartz <dswartz@courts.state.pa.us> 10/16 8:41 am >>>
>I have embedded an SQL statement in an RPG program to retrieve records 
>intoa cursor.  The select statement is using a "where" clause to only select 
>certain records.

>I'd like to get a total record count of what was selected before I start
>processing the records.  I want to use the total record count to send the
>user a message of the status of the submitted job (ie, % complete using
>how many processed in relation to the total selected).

>Is there a way to get this total record count after opening the cursor?

>Thanks for any help and suggestions.

>Dan

You could try something like:

Select count(*), ' ', ' ', ' ', 0, 0 from filename union
Select 0, alphafld1, alphafld2, alphafld3, numfld1, numfld2 from filename
order by 1 desc

The zeros and blanks are just place holders.  It may run slower.

David Morris


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---