Hi, we have the following problem:
In a program, which is connected via ODBC to our SAPDB (Version 7.4.3.30) we create dynamically tables (no temp.tables) which we use for data-compression purposes. After filling such a table with data we have to process the following statement on this table: update tablename set col1 = (select distinct refno from othertable where condition1 = xyz) We're getting the following error then: General error;-9111 POS(1) System error: Move error In the kerneltrace I find the following: 2003-12-04 11:06:11 869 ERR 54111 MOVE UpdMap.2: 63[66]->63[8096] len:18 2003-12-04 11:06:11 869 ERR 51080 SYSERROR -9111 Move error 2003-12-04 11:16:10 872 ERR 54111 MOVE UpdMap.2: 63[66]->63[8096] len:18 2003-12-04 11:16:10 872 ERR 51080 SYSERROR -9111 Move error 2003-12-04 11:16:54 872 ERR 54111 MOVE UpdMap.2: 63[66]->63[8096] len:18 2003-12-04 11:16:54 872 ERR 51080 SYSERROR -9111 Move error The problem can be reproduced with Windows and ODBC as well as with Unix-Odbc Any clues ?? Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
