Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2007
    Posts
    2

    Unanswered: dbisql - max rows retrieved by select is 500

    I'm running a dbisql select in batch mode, and I'm expecting to retrieve many thousands of rows. However, when I run the query, only 500 rows are displayed, so there seems to be a default limit set somewhere. If I open dbisql in X-windows, I can see (within 'Tools==>Options==>results') a setting called 'Maximum number of rows to display' which is set to 500. Frustratingly, however, I can't modify it.

    My question is: how do I change the default value of 500 for maximum number of rows displayed?

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    Hmm. Im guessing you are referring to IQ / ASA. I checked the Utility guide and there seems to be nothing to refer this.. Checked http://www.sypron.nl/asiq_qr.126.pdf and there seems to be an option OUTPUT_LENGTH

    Sorry not being that useful, but worth a try.
    Last edited by trvishi; 11-17-07 at 14:12.

  3. #3
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    With version 9.0.2 build 3480 you can
    Click Tools, Options, Results
    Then click on the drop down arrow for "Maximum number of rows to display" and select e.g. "All rows"
    Last edited by pdreyer; 11-19-07 at 04:09.

  4. #4
    Join Date
    Nov 2007
    Posts
    2
    aah - I'm on version 8.0.3, which doesn't give me the dropdown option you describe - I'll check out getting an upgrade.

    Thanks for the response.

Posting Permissions

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