Re: TOP 100 in SQL - difference between Online and IUS

Roger Reynolds wrote: > > >If you're using version 7.30 you can use the "first n" clause in the > >select statement. Example: > > select first 100 a, sum(b) > > from xxx > > group by a desc> > The interesting part is (to me) the "first 100" bit, and the posters note > that this > is part of the 7.30 product, which I assume is the Online database - right. > > The "first N" does not work in my version of Universal Server, which I > thought > was identical to Online, with the extended data capabilities. > > Can somebody comment on this please. Sure, I can. UDO split off from IDS at version 7.20 or so and the FIRST n clause is a 7.30 extension. The latest UDO which will be out soon is part of the Informix code merge project to get the three IDS "options" (UDO, XPO, DSO) incorporated back into the mainline source tree so that they are truly options with all of the same features. I think this will be 9.21 but I'm not certain of the version number. This version will take advantage of all of the source optimizations that improved performance in 7.30 to boot. Art S. Kagel