There are also reposition methods that match the corresponding REPOSITION statements you saw earlier. These include:
  • REPOSITION-FORWARD(n) — Repositions the query n rows forward within the result set
  • REPOSITION-BACKWARD(n) — Repositions the query n rows backward within the result set
  • REPOSITION-TO-ROW(n) — Repositions the query to row n within the result set
  • REPOSITION-TO-ROWID(rowid [, ...] ) — Repositions the query to the row whose buffers have the ROWIDs passed to the method