Hello, I've got a sapdb 7.3.0.34 running. Recently I have problems with the SELECT FROM DUAL statement.
The command: "SELECT seq_tislot_feature.nextval FROM dual" leads to: Base table not found;-4004 POS(40) Unknown table name:DUAL. I can work around the problem by executing instead: SELECT seq_tislot_feature.nextval FROM DBA.dual But I've also got another problem with the DUAL. Inside a stored procedure I try INSERT INTO TISYS.MY_TAB(condition) VALUES (UPPER(:cond_upper)); Again the same error Base table not found;-4004 POS(807) Unknown table name:DUAL. If I use the UPPER command on a single line and use a variable instead with the INSERT it works fine. SET cond = UPPER(condition); What could be the reason for this behaviour? I know that at some point my sapdb could execute these statements, I didn't apply any patches and updates since. Does anybody know how to get the standard SELECT ... FROM DUAL working again? Thank You. Andreas Klenk -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
