move man page on Peanut

Man page or keyword search:  
man Server   7435 pages
apropos Keyword Search (all sections)
Output format
Peanut logo
[printable version]

MOVE()				 SQL Commands				MOVE()

NAME
       MOVE - position a cursor

SYNOPSIS
       MOVE [ direction { FROM | IN } ] cursorname

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.

       Refer to FETCH [fetch(7)] 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).

EXAMPLES
       BEGIN WORK;
       DECLARE liahona CURSOR FOR SELECT * FROM films;

       -- Skip the first 5 rows:
       MOVE FORWARD 5 IN liahona;
       MOVE 5

       -- Fetch the 6th row from the cursor liahona:
       FETCH 1 FROM liahona;
	code  | title  | did | date_prod  |  kind  |  len
       -------+--------+-----+------------+--------+-------
	P_303 | 48 Hrs | 103 | 1982-10-22 | Action | 01:37
       (1 row)

       -- Close the cursor liahona and end the transaction:
       CLOSE liahona;
       COMMIT WORK;

COMPATIBILITY
       There is no MOVE statement in the SQL standard.

SEE ALSO
       CLOSE [close(7)], DECLARE [declare(l)], FETCH [fetch(l)]

SQL - Language Statements	  2005-11-05				MOVE()
[top]

List of man pages available for Peanut

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net