Hi,

I'm creating a software, and I have a dilemn... To check it I use MySQL, but I want to be use with DB2, Oracle and a lot of kind of différent DB.

But I have to know :

Does DB2 support something like that (and if not how to do it) :

SELECT fields FROM Table LIMIT 0,500

????

thank you very much for a quick answer, because All development depend of the answer !!!

thank you,
bye.

no, DB2 does not support LIMIT

look in the manual for FETCH FIRST