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?
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