Re: Feature Requests

> Message-Id: <9108211740.AA07396@dhlmis.ssf-sys.DHL.COM> > Date: Wed, 21 Aug 91 10:40:36 -0700 > From: Jim Gordon <jgordon@ssf-sys.dhl.com> > To: informix-list@rmy.emory.edu > Subject: Feature Requests > X-Informix-List-Id: <list.357> > > On the subject of feature requests I have three which I am thinking of > raising. Comments from Informix and others welcome. > > 2. When you open a cursor in 4GL it would be nice if Informix would > place an estimate of the number of rows that will be returned in SQLCA > ERRCODE[3] before you do any fetches. With the above you could then > declare a cursor, open it create an array of the right size and > process the rows. I'm certain that the information is available in > the system because I-SQL forms presents the number found when you do a > query on the screen and I doubt that SQL is doing the select twice > (Once with select count(*)). Alternatively is there a function > (Undocumented of course) that will return the information. Perform does in fact perform a select to retrieve rowids (I believe) of the answer set, and then selects each again as the next row is requested. The count is just not available until the query is complete. thomas rush uunet!cpqhou!thomasr compaq computer corporation their employee, deep in the hearth of texas not their opinions.