Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Sean Kelsey said:
> 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;
Errrr.... something is missing in the first "WHEN" clause?
--
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.