What's wrong with the following set of commands and why

[Rahul Babbar]

Hi,

I am facing some issues with the following set of commands.
The last 'Select' statement gives the error
"SQL0511N The FOR UPDATE clause is not allowed because the table
specified by
the cursor cannot be modified. SQLSTATE=42829

SQL0511N The FOR UPDATE clause is not allowed because the table
specified by the cursor cannot be modified."

Please explain why is this happening?

create table test1(num INTEGER);
create table test2(num2 INTEGER);

insert into test1 values(1);
insert into test2 values(1);

commit;

select test1.num from test1, test2 where test1.num = test2.num2 for
update with RS;

Thanks

Rahul Babbar

[Lennart]

On Oct 23, 1:11 pm, Rahul Babbar <[e-mail]:

Hi,

I am facing some issues with the following set of commands.
The last 'Select' statement gives the error
"SQL0511N The FOR UPDATE clause is not allowed because the table
specified by
the cursor cannot be modified. SQLSTATE=42829

SQL0511N The FOR UPDATE clause is not allowed because the table
specified by the cursor cannot be modified."

Please explain why is this happening?

create table test1(num INTEGER);
create table test2(num2 INTEGER);

insert into test1 values(1);
insert into test2 values(1);

commit;

select test1.num from test1, test2 where test1.num = test2.num2 for
update with RS;

[db2inst1@53dbd181 ~]$ db2 "? SQL0511N"
[...]
On the database manager, the result table is read-only if the
cursor is based on a VALUES statement or the SELECT statement
contains any of the following:
[...]
o A FROM clause that identifies one of the following:
- More than one table or view
[...]
/Lennart

[Rahul Babbar]

On Oct 23, 8:31 pm, Lennart <[e-mail]:

On Oct 23, 1:11 pm, Rahul Babbar <[e-mail]:

Hi,

I am facing some issues with the following set of commands.
The last 'Select' statement gives the error
"SQL0511N The FOR UPDATE clause is not allowed because the table
specified by
the cursor cannot be modified. SQLSTATE=42829

SQL0511N The FOR UPDATE clause is not allowed because the table
specified by the cursor cannot be modified."

Please explain why is this happening?

create table test1(num INTEGER);
create table test2(num2 INTEGER);

insert into test1 values(1);
insert into test2 values(1);

commit;

select test1.num from test1, test2 where test1.num = test2.num2 for
update with RS;

[db2inst1@53dbd181 ~]$ db2 "? SQL0511N"
[...]
On the database manager, the result table is read-only if the
cursor is based on a VALUES statement or the SELECT statement
contains any of the following:
[...]
o A FROM clause that identifies one of the following:
- More than one table or view
[...]

/Lennart

However,

The statement
"select test1.num from test1 for
update with RS; "

does work fine....the problem seems to come only if you try to have a
select involving two tables.

Please explain a bit more on the above and what should be done to fix
it?

Rahul