EXEC_SQL Question

From: Sue Han <sue_han_at_my-deja.com>
Date: Fri, 22 Oct 1999 06:15:58 GMT
Message-ID: <7uoves$b0n$1@nnrp1.deja.com>

Hi,

I want to get an estimate on number of rows that will be returned by a Dynamic SELECT statement before the actual rows are fetched.

Someone told me:
Informix reports this estimate in it's sqlca data structure when a cursor against the query is opened, however, these estimates are frequently way off. They depend on statistics gathered that may be out of date.

Estimate is exactly what I want. I will get statistics regularly.

Can EXEC_SQL do this and how? What about I connect to Oracle or non-Oracle DB?

Thanks in advance.

Sue

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 22 1999 - 01:15:58 CDT