Result sets from sql selects returning 50 rows

Chaps,

As part of my _project stay in WDSCi_ I am playing with the data perspective
and trying out the sql scripting capabilities. This is to stop me signing on
and running strsql whenever I need to run a query.

It seems that when I run a select statement my result set only contains 50
rows, even though I know there should be more. Am I missing something
fundamental? Is there a next/prev button I'm not seeing? :-)

Also, is there any sql analysis tools like visual explain in WDSCi? Or will
I have to go to iSeries Naviagtor to do this?

Your help will be most appreciated.

Cheers

Larry Ducie