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

No related posts.

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

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

1. Leons Petrazickis says:

   June 2, 2010 at 2:23 pm

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

   Reply
2. Arun Srini says:

   June 2, 2010 at 11:11 pm

   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