An encounter with DB2 – How to apply “limit” to queries?

My new assignment wanted me to experiment with DB2. And like everyone else who is new to DB2, I couldn’t find a way to limit the result set! After a lot of googling and phone calls I ended up with a stupid solution – but it works.

The solution looks like this:

SELECT * FROM
	( SELECT ROW_NUMBER() OVER (ORDER BY column_to_be_sorted) AS rownumber, col1, col2, other_cols
	  FROM my_db2_table WHERE col1 = ‘something’ )
AS tmp_table
WHERE rownumber BETWEEN start_index AND end_index

I hope this helps. But I really wish if there was some better ways.

Lotus Symphony – IBM’s free office suite

IBM has released the latest version of their office suite Lotus Symphony. There is Lotus Symphony Documents – a word processor, Lotus Symphony Presentations – a presentation tool & Lotus Symphony Spreadsheets – a spreadsheet package.

This office suite allows the users to edit & save Microsoft ® Office file and can export documents to Adobe ® Portable Document Format (PDF).

“IBM® Lotus® Symphony™ has something for everyone, like a community-oriented site with tips, a template gallery and support to help you succeed. Businesses can gain more control over spiraling upgrade costs, while still protecting, accessing and maintaining documents well into the future. And for developers, Lotus Symphony tools support Microsoft® Windows® and Office applications, which means you can get even more from your current investments.”

Source: Lotus Symphony website.

Useful Links:
Home Page: http://symphony.lotus.com/software/lotus/symphony/home.jspa
Download Page: https://www14.software.ibm.com/iwm/web/swerplotus/LotusSymphonyPick.html