The EGL get current statement reads the row at which the cursor is already positioned in a relational-database result set.
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™.
An SQL FETCH statement represents the EGL get current statement in the generated code. The format of the generated SQL statement cannot be changed, except to set the INTO clause.
If an error occurs and processing continues, the cursor remains open.
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
execute
get
get absolute
get first
get last
get next
get previous
get relative
EGL statements
open
replace