Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    1

    Unanswered: DB2 on AS400 and sql query question

    Hi,
    i am developing a web application in java using AS/400 as database, i have to write a sql query which will get only say 20 records from database even if there are 1000 records in the database, and then i can also set that i want records from 21 to 40 and 41 to 60,
    I need this to display only 20 records per page .
    so how can i do it,

  2. #2
    Join Date
    Aug 2002
    Posts
    1

    Thumbs up sql query question

    if you use ADODB, use the getstring method or getrows methods in which you can specify how many records to bring at a time and the starting record. So you can do this along in the scroll event of the grid to achieve the purpose.

    RV

Posting Permissions

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