counting each row returned

Posted in 2000

Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Triggers, Constraints & Referential Integrity

Bridget Reitsma — Wed, 19 Apr 2000 15:21:58 +1200 — source: Informix-list mailing list archive (1991-1998)

Hi, I want to select all the rows from a table - but only display 100 and then when a trigger is released display the next 100 and so forth. How can I do this using sql and JDBC? I thought about using rowid but this won't work - as it's not sequential and if delete somthing everything is out of sync?! Is there a way that you can choose the 10 column in a table with out knowing what is in it? thanks for any answers bridget

↪ replying to Bridget Reitsma

Watawinona — 20 Apr 2000 19:46:31 GMT — source: Informix-list mailing list archive (1991-1998)

>Subject: counting each row returned >From: Bridget Reitsma b.reitsma@auckland.ac.nz >Date: 19.04.00 05:21 W. Europe Daylight Time >Message-id: <38FD2656.4AC2C7CB@auckland.ac.nz> > >Hi, > >I want to select all the rows from a table - but only display 100 and >then when a trigger is released display the next 100 and so forth. How >can I do this using sql and JDBC? > >I thought about using rowid but this won't work - as it's not sequential >and if delete somthing everything is out of sync?! > >Is there a way that you can choose the 10 column in a table with out >knowing what is in it? > >thanks for any answers bridget > > > > > > > try using a cursor and a JDBC 2 driver. Nona