DB2 Server for VSE & VM: Interactive SQL Guide and Reference

FORWARD



>>-FORWARD----+--------------+---------------------------------><
              +-rows_integer-+
              '-MAX----------'

FORWARD is an ISQL display command that lets you move your display forward through a query result.

rows_integer
is the number of rows you want to move forward.

MAX
causes the last display of the query result to be displayed along with an indication of the number of rows in the query result and the Query Cost Estimate (QCE) message. For query results that contain many rows, a FORWARD MAX command can take a long time.

If nothing is specified, the display moves forward one-half of a display.

Scroll forward through the query result one-half of a display at a time by typing FORWARD. (You can also press PF8 or PF20.) Because you can reset your PF keys, you can assign the FORWARD function to another PF key.

You can activate FORWARD by pressing ENTER if it is the first display command to be issued for a query result. The display moves forward one entire display each time you press ENTER.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]