Sample Header Ad - 728x90

Multiple values in variable and need to check IF condition for each value

0 votes
1 answer
604 views
I'm writing DB2 stored procedure. This stored procedure will be called using .ksh script. I was stuck in checking IF condition. VARIABLE = 'test1,test3,test8,......testn' The variable's datatype is varchar IF VARIABLE = 'test1' THEN --PRINT TEST1 HERE; END IF; IF VARIABLE = 'test8' THEN --PRINT TEST8 HERE; END IF; could you please help me to achieve this?
Asked by looty (25 rep)
May 14, 2020, 05:02 PM
Last activity: May 14, 2020, 06:41 PM