Re: CASE statement problem....

2003-05-31 Thread Capodicci, Dan (COMFIN, ITSS)
PROTECTED] Subject: Re: CASE statement problem Here are some examples. set MailType = CASE InputBody.WfMessage.ActivityImplInvoke.ProgramID.ProgramName when 'WorkItemNotification' then 'is Ready for Your Approval' when 'RejectionNotice' then '

Re: CASE statement problem....

2003-05-31 Thread Raul Acevedo
Here are some examples. set MailType = CASE InputBody.WfMessage.ActivityImplInvoke.ProgramID.ProgramName when 'WorkItemNotification' then 'is Ready for Your Approval' when 'RejectionNotice' then 'Has Been Disapproved' when 'ReWorkNotice ' then 'Requires Rework' whe

CASE statement problem....

2003-05-31 Thread Capodicci, Dan (COMFIN, ITSS)
Hi All I have been stuck on a syntax error for some time so I figured I would reach out for a bit of help on this one:) Environment: WMQI 2.1 CSD3WMQ 5.3 CSD 1 I am trying to code a CASE statement in a compute node but am getting a syntax error. I have looked at it in the ESQL refe