Re: Rownum in Informix/Oracle

Posted in 2000

Obnoxio The Clown — Mon, 16 Oct 2000 14:02:54 BST — source: Informix-list mailing list archive (1991-1998)

From: stobie@my-deja.com > >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. ROWID? Probably not a good idea though. Maybe a SERIAL? Could you give some more details about what you're trying to do? _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.