Marc-Olivier Meunier wrote: > > > > I've been browsing the ml about mysql-like LIMIT function to > > > return for > > > example only the 10 to 40 resultsets. I came to the > > > conclusion that it was > > > not possible 2 years ago unless by using cursors or the fetch > > > function. > > > So is there a brand new great function with 7.4 that can do > > > that easily > > > > NO > > > > > or will i have to test for hours and sending tons of mail to get > > > my stuff work ? > > > > I hope, not > > > > Elke > > SAP Labs Berlin > > > > > > > // Thanks Elke > > If there is nothing new, i guess the fetch function would be > the best. The > problem with it is that i don't know if i can fetch a row and > send it in the > resultset i will return to my application... > Usually i use fetch only to get a single value and to send it > out with an > out parameter. > > So i've been thinking of creating a temp table and sending my data > parameters by parameters in the temp table. The problem is I > don't know if a > temp table sticks to the session and nobody can see it or > write in it ?
A TEMP-table belongs to a session, not to a user or task. No other session can see/change that TEMP-table. > It would be better for me. If not, has anybody got a simple > example of a query > returning a set of resultset, let's say from #10 to #50 ? > I guess fetch is not good for this since it doesn't return a > resultset but > parameters... > > HELP ! The archive does not help? Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
