Specifying the column number or column name

To locate a column, you must specify one of the following:
  • a Db2® column number
  • a column name, or
  • part of a column name

The following command locates column 4 in the data:

LOCATE #4
The following command locates column 4 in the data, and scrolls the display so that character position 100 of that column is visible: 

LOCATE #4 100
Either of the following commands locates column EMPNO in the data: 
L EMPNO
L 'EMPNO'
If you specify part of column name, the LOCATE command matches any column that contains the specified string within the column name. For example, 
L NO
locates both EMPNO and DEPTNO.