RE: SELECT NEXT

>is there a better solution for exchanging SELECT NEXT(from 
>Adabas)-Querys
>with SELECT and FETCH NEXT??
>This seems not to work somewhat, I get everytime only the 
>first Dataentry...
>Or am I making something wrong? What would be the wright 
>Syntax for that?

- Execute the SELECT once. You probably have to change it to restrict
the rows that you get (WHERE keycol BETWEEN <first> AND <last>). An
'ORDER BY keycol' is also required if you want to get the rows in the
same order as your Adabas D program did
- Execute FETCH NEXT until the cursor is exhausted.

Daniel Dittmar

-- 
Daniel Dittmar
SAP Labs Berlin
daniel.dittmar@xxxxxxx 

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx