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 the problem by executing instead: > SELECT seq_tislot_feature.nextval FROM DBA.dual > That sounds strange. Did you (try to) rename some dba?
Do you see table SYSMONITOR without prefixing it with DBA. ? Did you try to load the systemtables anew (load_systab in dbmcli) ? Elke SAP Labs Berlin > > 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] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
