Cursors

Cursors are a mechanism that DB2 supports. A set of table rows are processed one by one using the cursor. At once, it manages multiple row selections. Data structures called cursors to store all of a query’s results.

The working storage portion or the procedure division is where we can define the cursor. The cursor-related actions are as follows:

• Delete: The delete cursor is used to delete the rows from the table to result-ser.
• Open: The Open statement should be used before employing a cursor. The SELECT is ready for execution, thanks to the Open statement.
• Close: To release every bit of memory utilized by the cursor, use the close statement. A program should be terminated with the cursor closed.
• Fetch: The cursor is located using the get command, which also inserts the value into the INTO clause. The loop codes a fetch statement each time a new row is received.

The Working storage section or the procedure division are both acceptable places to declare a cursor. The DECLARE statement, which is the first sentence, cannot be executed.

Syntax:

EXEC SQL  

DECLARE cursorname\cursor-variable name

CURSOR FOR  SELLECT statement

END-EXEC.  

Programs in COBOL communicate with the DB2 Database. Data Base2 is DB2, and it was created by IBM. The database is a relational one. The relational information is kept in the TABLE format, which consists of multiples of rows and attributes (Columns).

DB2 is generally used for storing sizable amounts of Mainframe application data. It is comparable to SQL but has several enhanced features.

The following terms are part of the COBOL vocabulary for the Database Interface:

• Embedded SQL
• DB2 Application Programming
• Host Variables
• SQLCA
• SQL Queries
• Cursors