RE: QUICK Embedded SQL Question

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Apparently SQLER3 also contains the estimated number of rows when a PREPARE 
of a SELECT is done.

Vern

At 02:50 PM 2/6/2004 -0500, you wrote:

> Thanks, Rick. I knew it was in there some time. I just wasn't sure if it
> was after a Cursor open or after a fetch.
>
> Thanks,
>
> Mark
>
> Mark D. Walter
> Senior Programmer/Analyst
> CCX, Inc.
> mwalter@xxxxxxxxxx
> http://www.ccxinc.com
>
>
> |---------+-------------------------------->
> |         |           <Rick.Chevalier@ameri|
> |         |           credit.com>          |
> |         |           Sent by:             |
> |         |           midrange-l-bounces@mi|
> |         |           drange.com           |
> |         |                                |
> |         |                                |
> |         |           02/06/2004 02:34 PM  |
> |         |           Please respond to    |
> |         |           Midrange Systems     |
> |         |           Technical Discussion |
> |         |                                |
> |---------+-------------------------------->
>
>  >------------------------------------------------------------------------------------------------------------------------------|
>   | 
>                                                         |
>   |       To:       <midrange-l@xxxxxxxxxxxx> 
>                                                         |
>   |       cc: 
>                                                         |
>   |       Subject:  RE: QUICK Embedded SQL 
> Question 
> |
>
>  >------------------------------------------------------------------------------------------------------------------------------|
>
>
>
>
> The number of rows returned on a fetch are returned in SQLER3.  SQLER5 =
> 100  will indicate if you have reached the end of file.
>
> I don't know of a way to get the number of records (or lack of records)
> without performing at least one fetch.
>
> Rick
>
> > -----Original Message-----
> > From: midrange-l-bounces@xxxxxxxxxxxx
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> > MWalter@xxxxxxxxxxxxxxx
> > Sent: Friday, February 06, 2004 12:39 PM
> > To: Midrange Systems Technical Discussion
> > Subject: RE: QUICK Embedded SQL Question
> >
> >
> >
> > SQLER3?
> >
> > Thanks,
> >
> > Mark
> >
> > Mark D. Walter
> > Senior Programmer/Analyst
> > CCX, Inc.
> > mwalter@xxxxxxxxxx
> > http://www.ccxinc.com