Unknown result table when using "where current of"

[James Stahecki]

Hello,

I'm having a problem deleting or updating table rows using the "where current of 
cursor" option.

Our environment consists of Microfocus cobol 2.2, UnixODBC 2.2.6 and SAPDB 7.3.0.40 
all running on a single IBM RS/6000 with AIX 4.3.3

My test program attempts to delete a row where current of cursor position but gets an 
error stating unknown result table. I tried an update statement instead of delete, but 
that also fails with the same error. I also tried compiling the test program on a 
win2k pc using the 7.04.03.00 ODBC driver; same error.  Any help you can provide is 
greatly appreciated.

Thanks,
-Jim


Test Program:

       EXEC SQL CONNECT 'ADMIN' IDENTIFIED BY 'PASSWORD' USING 'ARMTEST' END-EXEC.  

       EXEC SQL
         DECLARE nxc1 CURSOR FOR
         select city, state, zip
         from admin.a_test_tbl
         where state = 'PA'
         for update of city
       END-EXEC.
 
       EXEC SQL OPEN nxc1 END-EXEC.
 
       EXEC SQL fetch  nxc1 into :city, :state, :zipcode END-EXEC.
 
       EXEC SQL
         delete from admin.a_test_tbl             
         where current of nxc1
       END-EXEC.

The following error message is returned here.
[unixODBC][SAP AG][LIBSQLOD SO][SAP DB]General error;-4000 POS(48) Unknown result 
table.
 

       EXEC SQL DISCONNECT CURRENT END-EXEC.
 

ODBC Trace:

 <<MFSQLTRACE.LOG>> 

MFSQLTRACE.LOG
Description: MFSQLTRACE.LOG