November 30, 2005, 09:50 AM
bsnelnDefine Statement
I'm trying to write a define statement such as:
SLEVEL/A6=IF (WKKEY_LEVEL EQ 'S') THEN 'SILVER' ELSE '';
BLEVEL/A6=IF (WKKEY_LEVEL EQ 'B') THEN 'BRONZE' ELSE '';
GLEVEL/A6=IF (WKKEY_LEVEL EQ 'G') THEN 'GOLD' ELSE '';
So instead of displaying the letters S, B, & G, I need the words SILVER, BRONZE AND GOLD.
Any suggestions would be appreciated.
November 30, 2005, 09:59 AM
jimster06How about
LEVEL/A6 = DECODE WKKEY_LEVEL (S SILVER B BRONZE G GOLD);
?
November 30, 2005, 10:10 AM
smithsIf WKKEY_LEVEL is a field from a file, then wrap what you have with...
DEFINE FILE yourfilename
...
END
If WKKEY_LEVEL is a variable that you want to process in Dialog Manager, then you want something like this...
-SET &LEVEL = DECODE &WKKEY_LEVEL(
- 'G' 'GOLD'
- 'S' 'SILVER'
- 'B' 'BRONZE'
- ELSE ' ');
November 30, 2005, 11:05 AM
bsnelnThank you for the responses. Decode worked and now I know how it works!!