Using the LAST parameter

Both of the following commands search for the last column name containing the string NO:
L LAST NO
L NO LAST

In TABL display format, the preceding commands start at the last column for the Db2® object and scan left to find the last column name that is either NO, or contains the string NO. The search ends when either a match occurs, or the first 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 the last column for the Db2® object and scan up to find the first matching column name. The search ends when either a match occurs, or the first 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.