>How can I implement an IF statement with a Exist predicate
>ej.
>if exists(select 1 from dba.mytable where mycolumnpk=1) then begin
> insert into z values (1);
>end;
It is not possible to place a sql statement into a IF statement. As a
workaround you could extract the select statement from the IF statement :
VAR cnt integer;
select count(*) into :cnt from dba.mytable where
mycolumnpk = 1 and rowno <= 1;
IF cnt > 0
then
insert into z values(1);
Best Regards,
Thomas
--
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]
