Meditations on programming, startups, and technology
New Relic

Enabling LIMIT and OFFSET in DB2 9.7.2

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

If you enjoyed this post, then make sure you subscribe to my Newsletter and/or Feed.

receive my posts by email

5 Responses to “Enabling LIMIT and OFFSET in DB2 9.7.2”

  1. Wow. Finally. This is tremendous. I’ll enable this in the MediaWiki port shortly.:-)

  2. Arun Srini says:

    So what happens if I had already set the compatibility to Oracle? Will I lose the features I already had? like the pl/sql blocks etc??

  3. Murad Iqbal says:

    In my DB 9.7, I am getting SQL exceptions for usage of the LIMIT and OFFSET. After setting db2set DB2_COMPATIBILITY_VECTOR=MYS, nothing changed. Still trying to figure out how to get the LIMIT and OFFSET work.

Leave a Reply

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.

Current ye@r *

Copyright © 2005-2014 Antonio Cangiano. All rights reserved.