Nested IF - (FOC266) IF .. THEN .. ELSE .. SYNTAX ERROR

Focal Point

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

November 05, 2007, 04:09 PM

Tomsweb

Nested IF - (FOC266) IF .. THEN .. ELSE .. SYNTAX ERROR

What am I doing wrong here?

-SET &PRDT = '002';
-SET &PLAN_CD = '008';

-SET &ABC = IF ((&PRDT EQ '002')
- AND (&PLAN_CD EQ '603' OR '609' OR '611' OR '612' OR '613' OR '614' OR '615') THEN '1'
- ELSE IF (&PRDT EQ '002') AND (&PLAN_CD NE '007' OR '008' OR '075')) THEN '2' ELSE '0';

-TYPE &ABC

-EXIT

And I get this....
-SET &ABC = IF ((002 EQ '002')
AND (008 EQ '603' OR '609' OR '611' OR '612' OR '613' OR '614' OR '615') THEN '1'
- ELSE IF (002 EQ '002') AND (008 NE '007' OR '008' OR '075')) THEN '2' ELSE '0';

0 ERROR AT OR NEAR LINE 6 IN PROCEDURE mrheaderFOCEXEC *

(FOC266) IF .. THEN .. ELSE .. SYNTAX ERROR

?????

November 05, 2007, 04:18 PM

Francis Mariani

Try this:

-SET &ABC = IF (&PRDT EQ '002')
- AND (&PLAN_CD EQ '603' OR '609' OR '611' OR '612' OR '613' OR '614' OR '615') THEN '1'
- ELSE IF (&PRDT EQ '002') AND (&PLAN_CD NE '007' OR '008' OR '075') THEN '2' ELSE '0';

or leave out the brackets.

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server