SQL result limit 100 - no page down

[Apsoftbe]

Hello,

Probable been asked before so sorry for this but cannot find an option to get more than 100 rows.

Thanks
Peter

{"assetPath":"c:\Users\pa\.vscode\extensions\halcyontechltd.vscode-db2i-1.16.0\dist\mapepire-server-2.3.4.jar","assetExists":true}
{"basename":"mapepire-server-2.3.4.jar","lastInstalledName":"mapepire-server-2.3.4.jar"}
QIBM_JAVA_STDIO_CONVERT=N QIBM_PASE_DESCRIPTOR_STDIO=B QIBM_USE_DESCRIPTOR_STDIO=Y QIBM_MULTI_THREADED=Y exec /QOpenSys/QIBM/ProdData/JavaVM/jdk80/64bit/bin/java -Dos400.stdio.convert=N -jar $HOME/.vscode/mapepire-server-2.3.4.jar --single
{"id":"id2","type":"connect","technique":"tcp","application":"vscode-db2i 1.16.0","props":"naming=system;full open=false;transaction isolation=none;query optimize goal=1;block size=512;date format=iso;extended metadata=true"}
{"id":"id2","job":"803290/QUSER/QZDASOINIT","success":true,"execution_time":696}

[sebjulliand]

Hi @Apsoftbe ,
the results are loaded 100 by 100; when you scroll to the bottom of the result table, it will load the next 100 rows.

There is however that prevents the loading from happening if VS Code is zoomed in; see: #470 (comment)

Is this your case ?

[Apsoftbe]

@sebjulliand

Page down or scroll not working.

Reset Zoom gives didn't help.
Thanks.

[SanjulaGanepola]

@Apsoftbe I haven't found a fix to the scrolling issue, but I proposed a PR to add a button to retrieve more rows which should help: #516