DB2 EE stage - Extract - SQL IN Clause
Posted: Thu May 10, 2007 10:58 pm
Hi All,
My Requirement is like these :
In my SQL I have to use IN condition for checking the few strings. I have to pass these strings in a parameter as per my requirement. I am using the DB2 EE stage for my extract from DB2. But, my job is aborting as it is not able to perform IN function with the strings (I have passed these string in a Parameter). Same IN condition is properly working for Integers if I passed the values in a parametr. Is there any constraint in DB2 EE stage for checking the strings by using IN clause ? Is anybody faced these type of problem ? Please share your experiences.
My Requirement is like these :
In my SQL I have to use IN condition for checking the few strings. I have to pass these strings in a parameter as per my requirement. I am using the DB2 EE stage for my extract from DB2. But, my job is aborting as it is not able to perform IN function with the strings (I have passed these string in a Parameter). Same IN condition is properly working for Integers if I passed the values in a parametr. Is there any constraint in DB2 EE stage for checking the strings by using IN clause ? Is anybody faced these type of problem ? Please share your experiences.