AW: Problem with SELECT ... FROM DUAL

2004-02-19 Thread Andreas Klenk
After going with my local machine to the same version like our live server I don't have anymore problems. Thank you for your help Andreas Klenk -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Problem with SELECT ... FROM DUAL

2004-02-19 Thread Zabach, Elke
Andreas Klenk wrote: > > > That sounds strange. > > Did you (try to) rename some dba? > No. > > > Do you see table SYSMONITOR without prefixing it with DBA. ? > No. Works only with the prefix. > > > Did you try to load the systemtables anew (load_systab in > dbmcli) ? > > I tried to load

AW: Problem with SELECT ... FROM DUAL

2004-02-19 Thread Andreas Klenk
> That sounds strange. > Did you (try to) rename some dba? No. > Do you see table SYSMONITOR without prefixing it with DBA. ? No. Works only with the prefix. > Did you try to load the systemtables anew (load_systab in dbmcli) ? I tried to load it but can't get it to work. ./dbmcli -d TISY

RE: Problem with SELECT ... FROM DUAL

2004-02-19 Thread Zabach, Elke
Andreas Klenk wrote: > > 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 th

Problem with SELECT ... FROM DUAL

2004-02-18 Thread Andreas Klenk
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