Scroll Data

Several commands are available to scroll the data vertically and horizontally. Scroll vertically to view additional rows when the number of rows retrieved exceeds the number of lines available on the screen. Scroll horizontally to view additional columns when the width of the data display exceeds the width of the screen.

Vertical Scroll

You can enter the scrolling commands UP, DOWN, TOP, and BOTTOM on the command line or assign them to program function keys. The ISPF SCROLL values, CSR, PAGE, DATA, HALF, MAX, and n (where n is the number of lines to scroll) are supported.

When a single table is displayed, vertical scrolling is identical to vertical scrolling in ISPF. Scrolling a multi-table display is discussed in Coordinated Scroll.

Horizontal Scroll

During a Point-and-Shoot session, all columns may not be displayed on the screen. When the combined width of the columns exceeds the width of the screen, the scroll indicator, MORE with an appropriate direction arrow, is displayed on the information line for the table. For example, if the display width of a column is 20 characters but only 10 spaces remain on the screen, the column is omitted from the display until you scroll horizontally.

You can scroll horizontally using LEFT and RIGHT (usually assigned to PF10 and PF11) to display the remaining columns. Operands for these commands allow you to scroll by column name, numeric value, or cursor position. These commands perform the same functions in columnar or sidelabels format. In sidelabels format, if insufficient space is available, partial data from columns may be displayed.

When multiple tables are displayed, indicate the table to scroll by specifying a table name or identifier with the column name (for example, T2.CUST_ID) or by cursor position. If a table is not indicated, the lowest-level table is scrolled.

Lock Columns for Horizontal Scroll

You can use the LOCK and UNLOCK commands to retain specified columns on the screen when scrolling horizontally. The LOCK command repositions the named column first on the screen and retains the column in that position when a horizontal scroll is performed. A locked column is identified by a series of plus signs, +, after the column heading. Multiple columns may be locked. The UNLOCK command unlocks the named locked column and returns it to the original position.

For more information about the LOCK and UNLOCK commands, see Lock Columns.