Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    3

    Question Unanswered: Is there anything like ROWNUM in oracle for DB2?

    Currently, I migrate my application to DB2 from Oracle. In oracle, there is something called ROWNUM. I use this only for showing 10 records in one page, and click next for another 10 records.

    In DB2, I don't know is there any similar feature or not, can anyone tell me?

    If not, can anyone tell me how to implement the "paging the records".


    Regards

    Louis

  2. #2
    Join Date
    Jan 2002
    Posts
    3

    Thumbs up

    After searching the net few days, I finally found the solution.


    http://www7b.boulder.ibm.com/dmdd/li...adamache3.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •