Focal Point
Define Statement

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/4411086931

November 30, 2005, 09:50 AM
bsneln
Define 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
jimster06
How about
LEVEL/A6 = DECODE WKKEY_LEVEL (S SILVER B BRONZE G GOLD);
?


jimster06
DevStu WF 7.6.11
W7
HTML, PDF, EXL2K
November 30, 2005, 10:10 AM
smiths
If 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 ' ');


------------------------------------------------------------------------
PROD: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
TEST: WebFOCUS 7.6.2 on Unix AIX/Tomcat/Servlet Mode
November 30, 2005, 11:05 AM
bsneln
Thank you for the responses. Decode worked and now I know how it works!!