Page 1 of 1
Is cursor the mandatory need for accessing link
Posted:
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
Posted:
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
Posted:
Sun Dec 26, 2010 6:39 pm
by Selvaraj
Hi nic,
Thanx for ur quick reply nic.