Re: Dumb JDBC Question

Posted in 1999

Sujit.Pal@bankofamerica.com — Fri, 10 Sep 1999 08:56:05 -0700 — source: Informix-list mailing list archive (1991-1998)

Richard Use the following SQL right after the select statement: select dbinfo('sqlca.sqlerrd2') from systables where tabid = 1; This is a general purpose function that returns the number of rows processed by a select, update, insert or delete. HTH Sujit Richard Auslander <rich@airflash.com> on 09/09/99 07:17:04 PM Please respond to Richard Auslander <rich@airflash.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Dumb JDBC Question Is there a way to determine the number of records that were returned by a "select"? This is almost a general question that shouldn't be very dependent on platform, version, etc. I've read the API documentation, and I don't see anything. Of course, that's probably just me... Rich -- Richard C. Auslander Database Manager AirFlash, Inc. 1733 Woodside Rd., Suite #110 Redwood City, CA 94061 (650) 556-7928 www.airflash.com