Home
Working with FM/Db2
Viewing and changing Db2® data
To view the contents of a Db2® table or view, use the FM/Db2 View Utility (option 1), the FM/Db2 Edit Utility (option 2), or the FM/Db2 Browse Utility (option B).
Viewing data in a File Manager/Db2 editor session
Locating a column
Specifying the search direction and starting point
Using the FIRST parameter

Using the FIRST parameter

Both of the following commands search for the first column name containing the string NO:

L FIRST NO
L 'NO' FIRST

In TABL display format, the preceding commands start at the first column for the Db2® object and scan right to find the first column name that is either NO, or contains 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 the first column for the Db2® object 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.