IBM Mainframe Forum

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 ?

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.

Hi nic,
Thanx for ur quick reply nic.