Multiple selects in if else statements.

[banccrop]

Hello all,

Here is my problem. I am writing a DB2 SQL stored procedure. Here is the main context:
if(true) then
select * from tableA
else
select * from tableB
endif;

How is this accomplished in DB2 SQL stored procedure?
I still have not found a way to accomplish this.
Thanks

 

[msera]

forget if ... else; try case

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmst151.htm#hdrcasestmt

 

[gregsimpson]

The following link may be of help to you.

http://www7b.boulder.ibm.com/dmdd/library/techarticle/0203yip/0203yip.html

Cheers
Greg