Re: howto use ROWNUM which is using in ORACLE??

Posted in 2000

Sue_Davidson@exe.com.au — Tue, 2 May 2000 14:13:24 +1000 — source: Informix-list mailing list archive (1991-1998)

I don't know what ROWNUM is, but you may find rowid useful. Rowid is a unique number which Informix gives to each record. It is not selected using SELECT *, you have to select it explicitly. eg SELECT rowid, other_fields FROM tablename WHERE where_criteria "batti" <batti@digito.com> on 02/05/2000 11:52:52 Please respond to "batti" <batti@digito.com> To: informix-list@iiug.org cc: (bcc: Sue Davidson/EXE) Subject: howto use ROWNUM which is using in ORACLE?? ..I want to know how to use ROWNUM or similar thing in Informix... In manual site, I already figure out that informix doesn't have ROWNUM ... .Isn't there another way..??

↪ replying to Sue_Davidson@exe.com.au

Surfer! — Tue, 2 May 2000 09:36:24 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <8elmgk$9la$1@news.xmission.com>, Sue_Davidson@exe.com.au writes > >I don't know what ROWNUM is, but you may find rowid useful. Rowid is a unique >number AFAIR it may not always be unique in online. But I forget the fine detail! > which Informix gives to each record. It is not selected using SELECT *, >you have to select it explicitly. >eg SELECT rowid, other_fields FROM tablename > WHERE where_criteria > > <snip> >To: informix-list@iiug.org >cc: (bcc: Sue Davidson/EXE) >Subject: howto use ROWNUM which is using in ORACLE?? > >..I want to know how to use ROWNUM or similar thing in Informix... > >In manual site, I already figure out that informix doesn't have ROWNUM ... > >.Isn't there another way..?? -- Surfer!

↪ replying to Sue_Davidson@exe.com.au

QueriX 4GL / Mehdi — Tue, 02 May 2000 15:10:50 +0100 — source: Informix-list mailing list archive (1991-1998)

Sue_Davidson@exe.com.au wrote: > I don't know what ROWNUM is, but you may find rowid useful. Rowid is a unique > number which Informix gives to each record. It is not selected using SELECT *, > you have to select it explicitly. > eg SELECT rowid, other_fields FROM tablename > WHERE where_criteria > > "batti" <batti@digito.com> on 02/05/2000 11:52:52 > > Please respond to "batti" <batti@digito.com> > > To: informix-list@iiug.org > cc: (bcc: Sue Davidson/EXE) > Subject: howto use ROWNUM which is using in ORACLE?? > > ..I want to know how to use ROWNUM or similar thing in Informix... > > In manual site, I already figure out that informix doesn't have ROWNUM ... > > .Isn't there another way..?? I think rowid is handled differently on SE and Online. You may wish to check the details so that you do not end up with unexpected results. -- Compliments of QueriX -------------------------------------------------------------------------------------------------- QueriX 4GL Compilers are Informix 4GL Compatible, and Connection to other RDBMS such as Oracle. Hydra 4GL Compiler (Compatible with I4GL) Compile once, run everywhere Phoenix Windows GUI. (Front End to 4GL) Chimera Java GUI The only GUI you will ever need... (Front End to 4GL) Arachne Web Technology (Front End to 4GL on the Web & HTML Report Generator) ESQL/C Compiler For more details visit: http://www.querix.com/ ---------------------------------------------------------------------------------------------------