Rownum in Informix/Oracle

Posted in 2000

stobie@my-deja.com — Mon, 16 Oct 2000 11:34:51 GMT — source: Informix-list mailing list archive (1991-1998)

Hi I'm trying to convert some Oracle Queries to run under Informix. Does anyone know if there is an equivalent to the ROWNUM argument/column for the Informix select statement as one query I have uses this to generate an index column and i can't see a way to replicate this in Informix at the moment. Many Thanks Steve Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to stobie@my-deja.com

Rudy Fernandes — Tue, 17 Oct 2000 10:53:12 -0400 — source: Informix-list mailing list archive (1991-1998)

Informix has no equivalent to Oracle's ROWNUM (which numbers rows returned by a query, isn't it?). You could create these numbers by dumping the results of your query into a pre-created temp table that has all the columns returned by the query AND an additional SERIAL column - very klunky! If you explain your challenge a little more, someone could provide you a solution that does not need the use of ROWNUM. Rudy stobie@my-deja.com wrote: > Hi > I'm trying to convert some Oracle Queries to run under Informix. Does > anyone know if there is an equivalent to the ROWNUM argument/column for > the Informix select statement as one query I have uses this to generate > an index column and i can't see a way to replicate this in Informix at > the moment. > Many Thanks > Steve > > Sent via Deja.com http://www.deja.com/ > Before you buy.