Home
IBM
Enabling LIMIT and OFFSET in DB2 9.7.2
IBM

Enabling LIMIT and OFFSET in DB2 9.7.2

5 Comments

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

Get more stuff like this

Subscribe to my mailing list to receive similar updates about programming.

Thank you for subscribing. Please check your email to confirm your subscription.

Something went wrong.

I respect your privacy and take protecting it seriously. Feel free to review my privacy policy page for further details.

About The Author

Antonio Cangiano
More from this Author

Antonio Cangiano is an Engineering Manager and AI Specialist at IBM. He authored Ruby on Rails for Microsoft Developers (Wrox, 2009) and Technical Blogging (The Pragmatic Bookshelf, 2012, 2019). He is also the Marketing Lead for Cognitive Class, an educational initiative which he helped grow from zero to over 3 Million students. You can follow him on Twitter.

5 Comments

  1. Leons Petrazickis June 2, 2010

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

    Reply
  2. Arun Srini June 2, 2010

    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??

    Reply
  3. Murad Iqbal May 9, 2012

    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.

    Reply

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.