>>The EXISTS predicate in the IF statement is not yet implemented. However, the
>>parser should return a better error explanation in that case. The
>>following code shows a workaround :
>>SELECT COUNT(*) INTO :CNT FROM SYSDBA.DUAL WHERE EXISTS (
>> SELECT * OWNER.aTable S1, OWNER.anotherTable T1
>> WHERE S1.navid = T1.navid
>> AND S1.stack_top = :stack_pointer);
>>IF CNT > 0
>>THEN
>>...
>>Regards,
>>Thomas
>>--
>>Thomas Anhaus
>>SAP DB, SAP Labs Berlin
>>[EMAIL PROTECTED]
>>http://www.sapdb.org/
In fact, Thomas, the following would even be a bit cheaper:
....
SELECT count(*) INTO :CNT
FROM OWNER.aTable S1, OWNER.anotherTable T1
WHERE S1.navid = T1.navid
AND S1.stack_top = :stack_pointer);
IF CNT > 0
.....
.....
;-)
Rgds
�ichael
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
