Is cursor the mandatory need for accessing link



IBM's flagship relational database management system

Is cursor the mandatory need for accessing link

Postby Selvaraj » Sun Dec 26, 2010 5:48 pm

In cobol-db2 environment,Is cursor the mandatory need for accessing lik (reading,fetching,updating,deleting) records from table ? Or we can implement Sql select instead of cursor ?
Selvaraj
 
Posts: 9
Joined: Wed Dec 22, 2010 9:09 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Cursor

Postby NicC » Sun Dec 26, 2010 6:18 pm

Suggest you read the user guide but, yes, use select when you know you will only return one row. If you are uncertain then a cursor should be used so that a failure can be avoided. However, you may have to consider performance issues.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: Cursor

Postby Selvaraj » Sun Dec 26, 2010 6:39 pm

Hi nic,
Thanx for ur quick reply nic.
Selvaraj
 
Posts: 9
Joined: Wed Dec 22, 2010 9:09 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post