Hello,

one sql statement is causing severe performance issue. The problem occurs only in UDB environment, the same statemnt on the mainframe is running fine. I have an explain output from the sql. The statement itself is not that complicated, it is 3 selects and union all. Explain output is pretty big, but I could not find anything unusual. I'm new to db2 and I could be missing stuff. I am posting the explain output below and I really...

Hi,
I need to create sql script that creates a table if it doesn't exist.

I tried to use

if not exists
(select * from sysibm.systable s where name ='mytable'
then
create table mytable ...
...
end if;


It reported problems. The task doesn't seem to be that hard. But apparently there is a problem using
DDL in the scripts. How could this be implemented...