Re: DB2 vs MySQL ... Oh I have learned a lot!

On 1/13/2016 10:48 AM, Rob wrote:

I am finding that I was quite spoiled with MySQL.

But as I always suspected, DB2 on i is the power house RDMS of the entire industry. Total FAN!

I am pleased with their implementation of Limit from MySQL. Would have been great if it had been implemented the same, and not so verbose...

as in this snippet from one of my scripts: "FETCH FIRST 80 ROWS ONLY" And what I read... this does not guarantee the same row with each call unless an "ORDER BY" is included.

Actually, the latest verison of DB2 for IBM i supports LIMIT the same way. LIMIT [OFFSET,] ROWS. But as pointed out by Chuck in another thread, what DB2 does is support the ANSI standard, more completely than any other database. If you want portability, then ANSI is the way to go. If you use a vendor-specific syntax, you may or may not be able to use that elsewhere. And if you have to switch vendors, then you have to deal with the consequences.

Me, I'm more upset that DB2 LUW always outpaces DB2 for i, but I've learned to live with being the last one at the table. Even a slightly backward version of DB2 is indeed one heck of a powerful engine, and there's absolutely nothing in the industry like the embedded RPG integration.

In my (not so) humble opinion, of course. :)