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
Last activity: May 14, 2020, 06:41 PM