1 .\\" auto-generated by docbook2man-spec $Revision: 1.1 $
2 .TH "MOVE" "7" "2003-11-02" "SQL - Language Statements" "SQL Commands"
4 MOVE \- position a cursor
9 MOVE [ \fIdirection\fR { FROM | IN } ] \fIcursorname\fR
14 \fBMOVE\fR repositions a cursor without retrieving any data.
15 \fBMOVE\fR works exactly like the \fBFETCH\fR
16 command, except it only positions the cursor and does not return rows.
19 FETCH [\fBfetch\fR(7)]
20 for details on syntax and usage.
23 On successful completion, a \fBMOVE\fR command returns a command
30 The \fIcount\fR is the number
31 of rows moved over (possibly zero).
36 DECLARE liahona CURSOR FOR SELECT * FROM films;
38 -- Skip the first 5 rows:
39 MOVE FORWARD 5 IN liahona;
42 -- Fetch the 6th row from the cursor liahona:
44 code | title | did | date_prod | kind | len
45 -------+--------+-----+------------+--------+-------
46 P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
49 -- Close the cursor liahona and end the transaction:
56 There is no \fBMOVE\fR statement in the SQL standard.