Re: Missing feature in informix?

Daniel James wrote: > > al_dev@candle.com writes: > > >In sybase equivalent is - > > set rowcount 9 > > select * from tablea > >In informix ???!!> > I agree... I don't care much for Sybase, but I found this to be one very > useful feature which would be great to have in Informix. At least there > is nothing like it that I know of in SE v5.x > -- Hopefully this will make it to the net.... While this may be a usefull feature, the work around would be to create a local variable, initialize it to 0, open a cursor and fetch rows until you reach either the limit, or you are out of data. Now if only Sybase worked on a serious issue which is extremely important: row level locking .... ;-) -Mikey #include <std.disclaimer>