Question & Answer
Question
I have a table that is more than 100 rows, but when I "Run SQL" in dashDB console, it only display a maximum of 100 rows. How can I change the setting ?
Answer
In the console, under "Run SQL" after you issue and run an SQL; there is a "setting" button ( on the far right hand side) that looked like the following,
After clicking the icon, you are in a "Setting" diagram (see below) which you can change the "Max displayed row count in each data set".
However, the maximum rows for now is only 500; if you needs to display result set bigger than 500 rows, please consider:
METHOD #1 - "Connecting applications to the dashDB database"
https://www.ibm.com/support/knowledgecenter/SS6NHC/com.ibm.swg.im.dashdb.doc/connecting/connecting_applications_to_dashdb_database.html
METHOD #2 - You can store the result in table using SQL like the following:-
CREATE TABLE RESULTSET_1 AS (SELECT ....) WITH DATA;
Then go to "Tables" tab -> select the table (RESULTSET_1) -> click on "Browse data" -> Export to csv (see below):-
Doing it this way, you can notice that the export rows are NOT limited anymore; simple use '0' to export all rows :-
Hope this will help
Was this topic helpful?
Document Information
More support for:
IBM dashDB
Software version:
Version Independent
Document number:
292135
Modified date:
16 June 2018
UID
swg21998919