MVSFORUMS.com

[John Corbin]

Hi gang...

If I have code like

SELECT
WHEN code ='A' | CODE = 'B' | CODE = 'C'
more code here
OTHERWISE
more code here
END

does the line code ='A' | CODE = 'B' | CODE = 'C'

read the same as code ='A' or CODE = 'B' or CODE = 'C'

Is there another way to code this ... I was thinking of


SELECT
WHEN code = 'A'
WHEN code = 'B'
WHEN code = 'C'
more code here
OTHERWISE
more code here
END

[kolusu]

John,

All IF and WHEN clauses must be followed by a THEN clause. So you cannot code as you have shown

Hope this helps...

Cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[John Corbin]

I neglected to add the THEN part...

Am more interested in the OR part though

[warp5]

John, depending on your emulator or where you are reading your rexx you did interpret it correctly as an 'or' character. You could code alternately like you did, but you would have to have that batch of 'more code here' after each when statement or place it in a called routine.