[SOLVED] Error with IF Then Else

Here is my code that gives me the EXPRESSION IS INCOMPLETE BECAUSE AN OPERATION IS MISSING error. I've tried changing the || to a single | concatenation operator, but still the error persists.

DEFINE FILE HOLDFILE1

DISPLAY_NM2/A500 = 	IF CAR_NM IS NOT MISSING 
					THEN ' ['  || CAR_NM || ' - ' || ( IF SQNC_NB IS NOT MISSING THEN  BR_NB ELSE RGN_CD ) || '] ' ;

END

Any ideas on what is missing?
Thank you!

This message has been edited. Last edited by: OnQuest,

WebFOCUS 767, Windows XP
Excel, HTML, PDF

Posts: 15 | Registered: March 11, 2009

Francis Mariani

Expert

posted

Hide Post

You cannot embed a second IF statement within the first one.

Try something like this instead:

DEFINE FILE HOLDFILE1
DISPLAY_NMXX/A50 = IF SQNC_NB IS NOT MISSING THEN BR_NB ELSE RGN_CD;
DISPLAY_NM2/A500 = IF CAR_NM IS NOT MISSING THEN ' [' || CAR_NM || ' - ' || DISPLAY_NMXX || '] ' ELSE '';
END

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Show Post

Tom Flynn

Expert

posted

Hide Post

Here is a format with a nested IF currently in production:

  
February/P12.3CB = IF '&MO2' GE '02' THEN 
                  (IF Month EQ '02' AND VERSIONS_KEY EQ 'ACT'    THEN Amount ELSE 0)
                 ELSE
                   IF Month EQ '02' AND VERSIONS_KEY EQ 'PLAN01' THEN Amount ELSE 0;

This "may" be the syntax you are looking for...

hth

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

GamP

Virtuoso

posted

Hide Post

And you're also missing the ELSE part.
The following DEFINE should syntactically correct (did not test it):

DEFINE FILE HOLDFILE1
DISPLAY_NM2/A500 = IF CAR_NM IS MISSING THEN '?' ELSE
                   IF SQNC_NB IS NOT MISSING THEN
                   ' ['  || CAR_NM || ' - ' || BR_NB || '] ' ELSE
                   ' ['  || CAR_NM || ' - ' || RGN_CD || '] ' ;
END

GamP