The EGL get absolute statement reads a numerically specified row in a relational-database result set. The row is identified in relation either to the beginning of the result set (if you specify a positive value) or to the end of the result set (if you specify a negative value).
You can use this statement only if you specified the scroll option in the related open statement. The scroll option is available only if you are generating output in Java™.
If the value of position is positive, the row is identified in relation to the beginning of the result set. Specifying get absolute 1, for example, retrieves the first row and is equivalent to specifying get first. Specifying get absolute 2 retrieves the second row.
If the value of position is negative, the row is identified in relation to the end of the result set. Specifying get absolute -1, for example, retrieves the last row and is equivalent to specifying get last. Specifying get absolute -2 retrieves the second to last row.
A value of zero for position causes a hard error, as described in Exception handling.
An SQL FETCH statement represents the EGL get absolute statement in the generated code. The format of the generated SQL statement cannot be changed, except to set the INTO clause.
In general, if an error occurs and processing continues, the cursor remains open, with the cursor position unchanged.
Finally, when you specify SQL COMMIT or sysLib.commit, your code retains position in the cursor that was declared in the open statement, but only if you use the hold option in the open statement.
Related concepts
resultSetID
SQL support
Related tasks
Syntax diagram for EGL statements and commands
Related reference
delete
Exception handling
execute
get
get current
get first
get last
get next
get previous
get relative
EGL statements
open
replace