CURSOR

db2 sql interview questions

Moderator: Moderator Group

Post Reply
User avatar
its.sudip
Member
Posts: 19
Joined: Sat Apr 28, 2012 1:55 pm
Location: Bangalore

CURSOR

Post by its.sudip » Sat Apr 28, 2012 2:31 pm

Is it possible to declare a cursor for UPDATE of table? and How?
Sudip Sen
Assistant Systems Engineer,
Bangalore,
Karnataka - 560037

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

Post by NicC » Sun Apr 29, 2012 2:10 pm

What did you find in the DBD SQL Reference? Specifically unde DECLARE CURSOR and even more specifically in the examples shown?
Regards
Nic

User avatar
its.sudip
Member
Posts: 19
Joined: Sat Apr 28, 2012 1:55 pm
Location: Bangalore

Post by its.sudip » Sun Apr 29, 2012 2:22 pm

NicC wrote:What did you find in the DBD SQL Reference? Specifically unde DECLARE CURSOR and even more specifically in the examples shown?
I have not searched for the answer anywhere. I got these questions in one of my interview. I want to learn DB2, that's why I've joined these forum. I know little bit of SQL, but I want to learn it again from scratch. Please tell me what is the right way to learn DB2
Sudip Sen
Assistant Systems Engineer,
Bangalore,
Karnataka - 560037

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

Post by NicC » Sun Apr 29, 2012 2:27 pm

If you want answers in a forum you have to research first and only post if you have problems understanding the answers you find. The first place to go is co-workers, then the manuals (and the IBM ones are available online at no charge), then search the internet and forums. And you can buy books. You do NOT use a forum for learning the basics.
Regards
Nic

User avatar
its.sudip
Member
Posts: 19
Joined: Sat Apr 28, 2012 1:55 pm
Location: Bangalore

Post by its.sudip » Sun Apr 29, 2012 2:34 pm

NicC wrote:If you want answers in a forum you have to research first and only post if you have problems understanding the answers you find. The first place to go is co-workers, then the manuals (and the IBM ones are available online at no charge), then search the internet and forums. And you can buy books. You do NOT use a forum for learning the basics.
Thanks NicC for your quick reply. I have joined to bangalore office recently. I don't have any co-worker right now. And about the manuals, it is too lengthy to read. I don't have that much of time. Still, I'll follow what you've said. Thanks again.
Sudip Sen
Assistant Systems Engineer,
Bangalore,
Karnataka - 560037

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

Post by NicC » Sun Apr 29, 2012 6:12 pm

You do not need to read all of them at once! But you should at least read the introductory stuff to start with.
Regards
Nic

brahan
Member
Posts: 4
Joined: Fri May 11, 2012 9:33 am

Post by brahan » Fri May 11, 2012 10:41 am

Yes we can Declare a Cursor with FOR Update Option

academyindia4

Topic deleted by Admin

Post by academyindia4 » Fri Jan 15, 2016 9:47 pm

<< Content deleted By Admin >>

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