Re: Informix SQL question !!!

Posted in 1996

Josef Dufek — 18 Oct 1996 06:31:38 GMT — source: Informix-list mailing list archive (1991-1998)

Giuliano Ferraro <ferraro@oliric.ico.olivetti.com> wrote in article <326666B5.3ED6@oliric.ico.olivetti.com>... > Greetings, > > I'm coming from Oracle database and I need to port some tool to Informix. > In Oracle SQL I have a query like this: > > SELECT > ROWNUM, COLUMN-1, COLUMN-2, ..., COLUMN-c > FROM > TABLE-1, TABLE-2, ..., TABLE-t > WHERE > CONDITIONS > > where the first column ROWNUM is a system column managed by Oracle > and it contains the ordinal number of the row retrieved by SELECT. In > short, I use this column to enumerate the result set of the SELECT > statement. > How could do the same in Informix SQL? > Any suggestion will be much appreciated. > Please reply directly to my e-mail address > (giufer@opo122.ico.olivetti.com or ferraro@oliric.ico.olivetti.com). > Thank you in advance. > There is ROWID in Informix. But use it carefully (it may be changed). Pepa.