$sql.resultSet.setFetchDirection

Gives a hint as to the direction in which the rows in this ResultSet object will be processed.
Syntax
    $sql.resultSet.setFetchDirection{direction}
    $sql.resultSet{setFetchDirection}{direction}
DocumentationGives a hint as to the direction in which the rows in this ResultSet object will be processed. The initial value is determined by the Statement object that produced this ResultSet object. The fetch direction may be changed at any time.:

    Paramter:
      direction - an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
    Returns:
    Throws:
      SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY and the fetch direction is not FETCH_FORWARD
Examples
GroupSQL
Minimum required transaction-mode:NONE
Required scripting permission of the developerPERMISSION_FL_BASIC
Minimum parameters1
Maximum parameters 1