CURSORS
A Select Query can retrieve one too many records, if the query results one record, it is good to capture the result and manipulate it. But the same select query used in same program retrieves more than one row at a time, it abends with SQL-CODE= -81. To handle this issue we go for CURSORS.
CURSORS : It is used to retrieve Multiple rows.
Life Cycle of a CURSOR will be same like a File Operations.
A Select Query can retrieve one too many records, if the query results one record, it is good to capture the result and manipulate it. But the same select query used in same program retrieves more than one row at a time, it abends with SQL-CODE= -81. To handle this issue we go for CURSORS.
CURSORS : It is used to retrieve Multiple rows.
Life Cycle of a CURSOR will be same like a File Operations.
- Declaration of a Cursor
- Open a CURSOR
- FETCH CURSOR
- CLOSE CURSOR
For More Details click on below video.
ConversionConversion EmoticonEmoticon