I am using SSIS and DB2. I have db2 query IF....Select query as follows:

if 'a'='a' then
select count(*) from x;
elseif 'b'='b'
select count(*)from y;
else
select count(*) from z;
end if

Somehow this is not working neither on db2 client nor on ssis. Can anyone suggest would could be wrong with this?

Thanks,
hs

Quoting n_i on this forum -> "It does not work" is not a valid problem statement.


What is 'a'='a', 'b'='b'... ? Where does a and b come from? a=a and b=b will always be true. How do you execute this sql on db2 client? From command line?

Actually, I am using this code in ssis for each loop container. Now I have to iterate through number of rows in a result set of the container. Therefore, I have a variable that has table name. So I am saying:
IF var::Table name='Quick response' then
select count(*)......
elseif var::Table name='AccomadationLog' then
select count(*).......
else
select count(*).....
end if

So, 'a' and 'b' were variables and their value was coming from ssis. When this sql was run in IBM data studio, it doesnt provide any results?

Thanks,