Re: CASE statement frustration...
Posted in 2004
June C. Hunt said:
> Sean Kelsey wrote:
>> IDS 9.40.TC4 (on Windows 2000 Advanced Server)
>>
>>
>> Afternoon all...
>>
>> Can anyone tell me why the folloiwng CASE statement embedded within a
>> SPL won't work? Its really bugging me.
>>
>> TIA.
>>
>> Sean.
>>
>> CREATE PROCEDURE MIS_DoTest()>>
>> DEFINE v_test INTEGER;
>> DEFINE v_res VARCHAR(12);
>>
>> LET v_test = 1;
>> LET v_res = '0';
>>
>> CASE v_test
>> WHEN THEN
>> LET v_res = '1';
>> WHEN 1 THEN
>> LET v_res = '2';
>> WHEN 2 THEN
>> LET v_res = '3';
>> ELSE
>> LET v_res = 'else';
>> END CASE;
>>
>> END PROCEDURE;
>
> Unless I am misreading the documentation, CASE within an SPL is only
> available in XPS (not IDS).
>
> Am I misreading that?
As The Big Potatoe might say: Hummm, no you don't seem to be misreading
it. :o)
--
Bye now,
Obnoxio
"C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
- Coluche
"I'm trying to see things your way, but I can't get my head up my ass"
- JCH
"Ogni uomo mi guarda come se fossi una testa di cazzo"
- Marco
http://www.catb.org/~esr/faqs/smart-questions.html
sending to informix-list