In the data tables you can control and navigation functions. These
functions are described below
EOF(Table) - Indicates
whether or not a cursor is positioned at the last record in a Table.
BOF(Table) - Indicates
whether or not a cursor is positioned at the first record in a Table.
LAST(Table) - Positions the
cursor on the last record in the Table.
FIRST(Table) - Positions the
cursor on the first record in the Table.
NEXT(Table) - Positions the
cursor on the next record in the Table.
PRIOR(Table) - Positions the
cursor on the previous record in the Table.
For example
\EOF(a)\, \NEXT(table1)\
NOTE: You should not use
these functions at the same time with SCAN having data table name.
You may use these functions in SCAN with no name mentioned, for example: