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
elseif var::Table name='AccomadationLog' then
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?