text: BEGIN WORK;
  
  -- Set up a cursor:
  DECLARE liahona SCROLL CURSOR FOR SELECT * FROM films;
  
  -- Fetch the first 5 rows in the cursor liahona:
  FETCH FORWARD 5 FROM liahona;
  
   code  |          title          | did | date_prod  |   kind   |  len
  -------+-------------------------+-----+------------+----------+-------
   BL101 | The Third Man           | 101 | 1949-12-23 | Drama    | 01:44
   BL102 | The African Queen       | 101 | 1951-08-11 | Romantic | 01:43
   JL201 | Une Femme est une Femme | 102 | 1961-03-12 | Romantic | 01:25
   P_301 | Vertigo                 | 103 | 1958-11-14 | Action   | 02:08
   P_302 | Becket                  | 103 | 1964-02-03 | Drama    | 02:28
  
  -- Fetch the previous row:
  FETCH PRIOR FROM liahona;
  
   code  |  title  | did | date_prod  |  kind  |  len
  -------+---------+-----+------------+--------+-------
   P_301 | Vertigo | 103 | 1958-11-14 | Action | 02:08
  
  -- Close the cursor and end the transaction:
  CLOSE liahona;
  COMMIT WORK;
  