• Subject: Embedded SQL record count -Reply
  • From: David Morris <dmorris@xxxxxxxxxxxxx>
  • Date: Thu, 16 Oct 1997 17:07:41 -0600

>>> 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.


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

This thread ...

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].