> 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
