"H�bschen, Peter" wrote > > Hello, > > I've executed 'Select case when exists (SELECT > lfd_Rueckfragenummer FROM > tbl_StaffelRueckm WHERE Lfd_Rueckfragenummer = <integer>) > Then 1 Else -5678 > End from tbl_Staffelrueckm' on my database in SQL Studio > (7.4.3.28) with a > Sapdb 7.4.3.25 on a Redhat 9 Box and afterwards I got > "General error: -9210 > POS(1) System error: KB Stack op illegal". In the > documentation I found that > I should make a call at the Local Support (I'm doing this > with this E-Mail > right now ;-)) and I should attach a trace of my last > database activities. > But I don't know what is meant by this. So which files should > I attach? Can > I attach files or get they stripped of by the Mailinglistsystem? > > Here are my last 2 entries from knldiag.err: > 2003-09-01 06:30:40 --- Starting GMT > 2003-09-01 > 04:30:40 7.4.3 > Build 025-121-046-179 > 2003-09-02 11:31:56 1041 ERR 51080 SYSERROR -9210 KB Stack op illegal >
Here we are: the EXISTS <subquery> in the select_list causes the trouble. (EXISTS <subquer<> in the WHERE-clause is ok). Will be fixed with the next version, see PTS 1123958 Thank you for reporting Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
