[GaneshBM]

How to implement insensitive scroll cursor in a SP.

create procedure cur_test()
language sql
begin

DECLARE rc1 insensitive scroll cursor with return for
select 'DS'
from sysibm.sysdummy1;

open rc1;

end

[GaneshBM]

Help me out to slove the issue.

[r035198x]

Sounds like home work. Read this and try it again.

[GaneshBM]

Dear r035198x ,

Thnks for the update.

In our application we retrieve the data from SP & the logic are build up in the SP. after open cursor, we are using a delete statement for the table used for the cursor. In DB 8.1 it is working fine i.e we could able to get the record set, if there are delete performed after open cursor. But in DB 9.1 version, we are not getting the record set (it is getting affected by the delete statement).

We tried to solve this by using INSENSITIVE cursor, but while compilation (SP) error is "SQLSTATE: 42601".

Need to re-solve it. Thanks in advance.