DB2 Cursor Multi-row fetch | DB2 Cursor with ROWSET Positioning | What is multi row fetch in DB2?.
#db2 #cobol #db2 #cics #multirowfetch
COBOL+DB2 applications can either execute a singleton select statement or use the DB2 Cursor to retrieve data from the DB2 database. DB2 Cursor or SQL Cursor or simply cursor is a mechanism by which you access data row-by-row from the result set. DB2 Cursor multiple-row FETCH statement can be invoked to fetch multiple rows from a table or view with a single FETCH statement. Your request may become more efficient if you fetch multiple rows at once, especially for distributed requests. Multi-row FETCH, available in DB2 since Version 8, has the capability to dramatically improve the performance of DB2-based database applications. The tutorial focus on DB2 Single Row vs Multi-Row FETCH. Let’s get started with Cursor in DB2 Tutorials (i.e. Multi-Row FETCH in DB2 Cursor).
Agenda.
0:00 Introduction to DB2 Cursor Tutorial.
0:28 DB2 Cursor multiple-row fetch tutorial agenda.
1:15 What is a COBOL+DB2 Application or COBOL DB2 program?
1:37 What is a Cursor and why do you need them?
3:30 What are the stages of the DB2 cursor?
4:16 Single row vs multiple rows fetch in DB2?
6:05 DB2 Cursor multiple-row fetch benefits?
6:53 What is multi-row fetch in DB2?
7:10 What is Rowset positioning?
8:10 Declare DB2 cursor with rowset positioning.
10:07 DB2 cursor with Multi-Row FETCH (i.e. COBOL+DB2 program example).
13:49 DB2 cursor Multi-row FETCH with the simple cursor.
15:32 DB2 cursor with rowset positioning Cursor with ROWSET Positioning.
17:03 Thank you.
►Subscribe to @Topictrick & Don’t forget to press THE BELL ICON to never miss any updates. ◄
Also, Please visit below mention the link to stay connected with Topictrick on –
► Offical Website : www.topictrick.com
► Youtube : @Topictrick
► Follow us on Twitter : https://twitter.com/topictrick
► Facebook : https://www.facebook.com/topictrick/
► Linkedin : https://www.linkedin.com/showcase/topictrick
► Reddit : https://www.reddit.com/r/topictrick/
► Mainframe Blog : https://mainframe-forum.blogspot.com
Thank you for your support.
Topictrick™
@Topictrick
Comments are closed.