Hi,
I write nesting IF/THEN/ELSE alright but when I try SELECT/WHEN/OTHERWISE/END, I can't make it work. I am writing a SELECT/WHEN/OTHERWISE/END and in one of the WHEN clauses, I am including another SELECT condition. it works all good but I get an error regarding the last OTHERWISE. my last lines are like this:
OTHERWISE SAY 'YOU SHOULD ANSWER WITH A NUMBER' END
OTHERWISE SAY 'You should answer with yes or no' END
each OTHERWISE has a former SELECT in the code.
The first one is for nested one, and the second one is for the big condition.
it gives the error :
IRX0009I Error running CONSE2, line 59: Unexpected WHEN or OTHERWISE
Do You know what should I do?
How should I write nested SELECT/WHEN/OTHERWISE/END?
OTHERWISE SAY 'YOU SHOULD ANSWER WITH A NUMBER' END
OTHERWISE SAY 'You should answer with yes or no' END