krk_kumar1
New User
Joined: 14 Mar 2006 Posts: 39
|
|
|
|
Hi,
Will the 'FOR UPDATE OF' clause work when the Cusror declared has the join of more than one than one table? Because i'am gettin a -504 (Cursor Name is Not defined) when i'am trying to bind the application program .I've checked the program and the Cursor is declared.
I've declared a Cursor as
EXEC SQL
DECLARE CSR1 CURSOR FOR
SELECT A.Column2,A.Column3,B.column4
FROM Table1 A,
Table2 B
Where A.Column1=B.column1
For Update of Column2,Column3
END-EXEC
and my update clause is
EXEC SQL
UPDATE Table1
SET Column2 = 'ABCD'
, Column3 = '12345'
WHERE CURRENT OF CSR1
END-EXEC.
Thanks in advance |
|