Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Posts
    48

    Talking Unanswered: How do I control the number of rows a querry shd return

    Hi All,

    I want to control the number of rows a querry should return ( Like SPUFI returning nrows). I have a querry which returns 500+ rows but I want to limit the output only to say 10 rows. This is nothing to do with the predicates.

    Environment : DB2 OS390.

    Any suggestions/ Ideas...

    Thanks

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    FETCH FIRST n ROWS ONLY

    You may need version 7 for this, not sure.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Apr 2004
    Posts
    48
    Great... Thats exactly what I wanted.

    Thanks

Posting Permissions

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