Tagged: IBM Toggle Comment Threads | Keyboard Shortcuts

  • Subinkrishna Gopi 2:41 pm on October 5, 2011 Permalink |
    Tags: , database, db2, IBM   

    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.

    Advertisements
     
  • Subinkrishna Gopi 1:42 pm on September 20, 2007 Permalink |
    Tags: IBM, lotus, , office, word processor   

    Lotus Symphony – IBM’s free office suite 

    IBM Lotus Symphony
    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

     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel