AFAIK you must declare the cursor FOR UPDATE ...
-----Mensaje original-----
De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] nombre de David
Possinger
Enviado el: Mi�rcoles, 09 de Julio de 2003 08:05 a.m.
Para: [EMAIL PROTECTED]
Asunto: Unknown result table
We are embedding SQL into COBOL programs using UNIX ODBC version 2.2.5. The
following code works until we do the update statement. On the UPDATE
statement we receive -4000: Unknown result table. Is the syntax incorrect or
is it incorrect use of "where current of" statement? Please advise.
Thanks,
David
EXEC SQL
DECLARE cur1 CURSOR FOR select col_, col_02
from test_table
END-EXEC.
display 'declare ' SQLCODE ' ' mfsqlmessagetext.
EXEC SQL
OPEN cur1
END-EXEC.
display 'open ' SQLCODE ' ' mfsqlmessagetext.
EXEC SQL
fetch cur1 into :var1, :var2
END-EXEC.
display 'var1: ' var1, 'var2: ' var2
display 'fetch ' SQLCODE ' ' mfsqlmessagetext.
EXEC SQL
update test_table
set col_02 = 'XZCVWE11111111'
where current of cur1
END-EXEC.
--------
error message from output:
UPDATE -0000004000 [unixODBC][SAP AG][LIBSQLOD SO][SAP DB]General
error;-4000 POS(66)
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
