dbisql - max rows retrieved by select is 500

BillHorne · #1 (**permalink**) 11-16-07, 16:13

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?

trvishi · #2 (**permalink**) 11-17-07, 13:53

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.

pdreyer · #3 (**permalink**) 11-19-07, 04:04

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"

BillHorne · #4 (**permalink**) 11-19-07, 08:28

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.