Page 1 of 1

Is cursor the mandatory need for accessing link

PostPosted: Sun Dec 26, 2010 5:48 pm
by Selvaraj
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 ?

Re: Cursor

PostPosted: Sun Dec 26, 2010 6:18 pm
by NicC
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.

Re: Cursor

PostPosted: Sun Dec 26, 2010 6:39 pm
by Selvaraj
Hi nic,
Thanx for ur quick reply nic.