Subject | sp case statement |
---|---|
Author | Matchey,Brian |
Post date | 2012-10-31T21:38:28Z |
Is there a way to achieve the logic I'm trying to accomplish with the CASE statement in the WHERE clause below?
CREATE OR ALTER PROCEDURE GET_DATA (
Input_code char(1) )
RETURNS (
Output_code integer )
as
begin
FOR SELECT T.Output_code
FROM Table T
WHERE T.Input_code =
case :Input_code when 'A' then 'A'
when 'B' then 'B'
else (('A') or ('B'))
end
INTO :Output_code
DO
SUSPEND;
end;
Vertafore
Unleash your potential
Daniel Raith
Software Engineer II
26550 W. Mondovi St, Eleva, WI 54738
T 800 433 2550 Ext 2917 | F 805 553 9308 | draith@...<mailto:draith@...>
vertafore.com
[Non-text portions of this message have been removed]
CREATE OR ALTER PROCEDURE GET_DATA (
Input_code char(1) )
RETURNS (
Output_code integer )
as
begin
FOR SELECT T.Output_code
FROM Table T
WHERE T.Input_code =
case :Input_code when 'A' then 'A'
when 'B' then 'B'
else (('A') or ('B'))
end
INTO :Output_code
DO
SUSPEND;
end;
Vertafore
Unleash your potential
Daniel Raith
Software Engineer II
26550 W. Mondovi St, Eleva, WI 54738
T 800 433 2550 Ext 2917 | F 805 553 9308 | draith@...<mailto:draith@...>
vertafore.com
[Non-text portions of this message have been removed]