Without using cursors handling multiple rows

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
malathy
Member
Posts: 4
Joined: Tue Sep 03, 2013 5:26 pm

Without using cursors handling multiple rows

Post by malathy » Wed Sep 04, 2013 1:27 pm

Is it possible to handle multiple rows fetched in DB2/COBOL program without using Cursors??

If yes, How?

NicC
Active Member
Posts: 650
Joined: Sun Jul 24, 2011 5:27 pm
Location: Down on the pig farm

Post by NicC » Wed Sep 04, 2013 5:33 pm

You can only fetch multiple rows using a cursor - that is what it is for! Otherwise you need a unigue reference for each row to be retrieved and issue a select for each one with that unique reference.
Regards
Nic

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others