DB2 CURSOR

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
srini1508
Member
Posts: 14
Joined: Fri Sep 30, 2011 4:37 pm

DB2 CURSOR

Post by srini1508 » Tue Oct 11, 2011 4:49 pm

i have declare cursor statement and i opened it and fetched the records in to working storage variables which are not initialised.

what will be the default value stored in these host variables during the time of OPEN CURSOR?

User avatar
dbzTHEdinosauer
Moderator
Posts: 981
Joined: Mon Oct 02, 2006 8:31 pm

Post by dbzTHEdinosauer » Tue Oct 11, 2011 6:00 pm

srini1508,

you are exceeding the bounds of acceptability for this forum.

why do you think the answer to this would be any different than the answer to this question that you posed at the end of last month?
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.

srini1508
Member
Posts: 14
Joined: Fri Sep 30, 2011 4:37 pm

DB2 CURSOR values

Post by srini1508 » Tue Oct 11, 2011 7:04 pm

that's where you have mistaken, it wont assign any values to the host variables during OPEN CURSOR.

DikDude
Moderator
Posts: 1001
Joined: Fri Jul 22, 2011 8:39 am
Location: usa

Post by DikDude » Tue Oct 11, 2011 10:34 pm

that's where you have mistaken, it wont assign any values to the host variables during OPEN CURSOR.
Why in the world did you post this?

The previous answer is NOT mistaken. . .
there is no default value.

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