Re: "Rownum" in Informix

?? Do you mean some kind of rownum is implemented in IDS 10.00.UC4? I checked UC4 release notes and found nothing about it (maybe my eyes ;) ) But last time I checked, this functionality is internal to IDS so you can use limit/skip clauses. But you actually cannot select an increasing number for every row that a select returns. I mean: select some_kind_of_rownum, col1, col2, ... from some_table; which yields to: 1, col1, col2, ... 2, col1, col2, ... 3, col1, col2, ... 4, col1, col2, ... It's not supported yet by IDS... or I am (Luckily) wrong? J. Jonathan Leffler escribi': > On 4/14/06, Jonathan Stowe <jns@gellyfish.com> wrote: > >>On Fri, 2006-04-14 at 07:44, Kuldeep wrote: >> >>>RowNum in Informix? How to implement it >>>any syntax,ponters,e.g >> >>You mean like >> >> select rowid from foo> > > > If you've got 10.00.UC4 (and not earlier versions, IIRC), check the > release notes. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >