Restricting the rows to view with the "Row count" entry field
If you just want to limit the volume of data that FM/Db2 retrieves from Db2®, use the Row count entry field on the Db2® View panel or the Db2® Edit panel to specify the number of rows of Db2® data you want.
You can use this entry field to select "large mode" by typing ALL, 0,
or * in the field.
If the maximum number of rows was retrieved, the message Limit
of Rows Retrieved
appears immediately below the last row (in TABL
display format).
You can use this entry field when viewing or editing large tables, in combination with the Start position entry field, to show small portions of the table. You can then specify row selection criteria that limit rows retrieved to those of interest.
Related references