Using the NEXT parameter

NEXT is the default value. Both of the following commands search for the next column name containing the string NO:
L NEXT 'NO'
L NO NEXT

In TABL display format, the preceding commands start at (but exclude) the column currently displayed on the left of the screen and scan right to find the first column name that is either NO, or contains the string NO (for example, NO, EMPNO, DEPTNO and NOMINAL all contain the string NO). The search ends when either a match occurs, or the last column of the Db2® object is encountered. If a matching column name is found, FM/Db2 scrolls the data so that the matching column is displayed on the left of the display.

In SNGL display format, the preceding commands start at (but exclude) the column currently displayed at the top of the screen and scan down to find the first matching column name. The search ends when either a match occurs, or the last column of the Db2® object is encountered. If a matching column name is found, FM/Db2 scrolls the data so that the matching column is displayed at the top of the display.