MOVE

Name

MOVE -- position a cursor

Synopsis

MOVE [ direction [ FROM | IN ] ] cursor_namewhere direction can be empty or one of:
NEXT
PRIOR
FIRST
LAST
ABSOLUTE count
RELATIVE countcount
ALL
FORWARD
FORWARD count
FORWARD ALL
BACKWARD
BACKWARD count
BACKWARD ALL

Description

MOVE repositions a cursor without
retrieving any data. MOVE works exactly
like the FETCH command, except it only
positions the cursor and does not return rows.

The parameters for the MOVE command
are identical to those of the FETCH
command; refer to FETCH for details
on syntax and usage.

Outputs

On successful completion, a MOVE
command returns a command tag of the form

MOVE count

The count is the number of
rows that a FETCH command with the same
parameters would have returned (possibly zero).