Cobol - Cobol-DB2 Question

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Cobol-DB2 Question

Houman Ghahremanlou

2004-11-24, 8:55 pm

Hello Everyone,

In a COBOL-DB2 program:

EXEC SQL
SELECT CASE
WHEN (CONDTION 1
AND CONDITION 2)
THEN 'FIRST MET'
------------------------------------------------------------------------------->
WHEN (CONDITION 3
AND CONDITION 4)
THEN 'SECOND MET'
WHEN (CONDITION 4
AND CONDITION 5)
THEN 'THIRD MET'
ELSE 'NONE'
END
INTO :MESSAGE
FROM TABLE
WHERE .....
END-EXEC

for some reason when any condition after the first WHEN ,is met... I get an
empty message, even the else doesn't get executed.

Can anyone shed a light on this ? thank you in advance for any kind of help.

Houman

Sponsored Links