{nomaxrows}

This keyword switches off {maxrows #} and reestablishes unlimited row count return.

 

Example:

SELECT * FROM customers {nomaxrows}