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

BACKWARD

>>-BACKWARD----+--------------+-------------------------------->< +-rows_integer-+ '-MAX----------'

This ISQL display command displays the rows above or before those currently being displayed.

rows_integer

is a number that indicates the number of rows backward that you want to move the display.

MAX

moves the display to the beginning of the query result.

If neither rows_integer nor MAX is specified, the display moves backward half a display.

Moving backward through the query result is limited: you can go backward to a limit of one full display from the last FORWARD command, or you can return to the beginning of the query result by issuing BACKWARD MAX.

Scrolling backward a half display at a time can be done by pressing PF7 (or PF19). Because you can reset your PF keys, you can assign the BACKWARD function to any PF key. The default function key is PF7 (or PF19).

Note:

You cannot receive a prompt response when you enter a BACKWARD MAX command, because the query must be reexecuted to move the display back to the first display.