MVSFORUMS.com

[mainframemouli]

I searched this forum and i found a simillar issue , but the problem with that issue is usage of multiple cursor , i am using a cursor to fetch from the table matching a specific criteria and updating the table where the cursor is currently pointing to.

There is a -510 sql code for the cursor program.

[CZerfas]

Hello Mainframemouli,

the cursor you have defined is a not-updateable-cursor, since it contains a join.

The criteria for beeing an updateable cursor is, that your cursor has to use only the base tables, i.e. there have to be no intermediate workfiles build by DB2. These workfiles are built for joins, index-ORing and sorts. Only a pretty limited number of cursors could therefor be used for positioned updating.

regards
Christian

[shekar123]

mainframemouli,

Can you make info and try to debug:

Programmer Response: The requested UPDATE or DELETE cannot be performed.

1.For a remote table, modify the DECLARE CURSOR andthen rebind the PLAN.
2.For a cursor that uses parallelism, disable parallelism for the query by using the DEGREE(1) BIND option for
static SQL or by setting the CURRENT DEGREE special register to '1' for dynamic SQL.
3.For an ambiguous cursor in an application bound CURRENTDATA(NO), either make the cursor unambiguous (declare it FOR UPDATE OF), or rebind the application CURRENTDATA(YES).
_________________
Shekar
Grow Technically

[mainframemouli]

Thanks CZerfas.

Shekar,
What CZerfas told is true that a we cannot update a intermedaite table. Only base tables can be updated.

Do you think even then the solutions you suggested can work fine?please suggest me if its possible still.