Oninit cdi / Archive
Talk to an expert →

CASE statement frustration...

Posted in 2004

Topics: Stored Procedures & SPL, Data Types & Schema Design, Versions, Editions & End-of-Life

Sean Kelsey — — source: Usenet: comp.databases.informix

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 0 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;

↪ replying to Sean Kelsey
June C. Hunt — — source: Usenet: comp.databases.informix

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 0 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? -- June Hunt

Glossary