In order to enable the new LIMIT and OFFSET syntax in DB2 9.7.2, you’ll need to execute the following commands:
$ db2set DB2_COMPATIBILITY_VECTOR=MYS $ db2stop $ db2start
With this enabled, you’ll be able to execute queries such as:
SELECT * FROM users LIMIT 5 SELECT * FROM users LIMIT 5 OFFSET 10
I sincerely welcome and appreciate your comments, whether in agreement or dissenting with my article. However, trolling will not be tolerated. Comments are automatically closed 15 days after the publication of each article.