I'm able to eliminate the record of 'ENGLAND' & 'JAGUAR' using concatenation.
DEFINE FILE CAR
TESTCND/A30V=COUNTRY||'-'||CAR;
END
TABLE FILE CAR
PRINT COUNTRY CAR
WHERE TESTCND NE 'ENGLAND-JAGUAR'
END
There must be someother easy way to achieve this. Suggestions are welcome.
Thanks, RifazThis message has been edited. Last edited by: Rifaz,
-Rifaz
WebFOCUS 7.7.x and 8.x
April 02, 2014, 09:48 AM
Francis Mariani
TABLE FILE CAR
PRINT COUNTRY CAR
WHERE NOT (COUNTRY EQ 'ENGLAND' AND CAR EQ 'JAGUAR')
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
April 02, 2014, 09:50 AM
Fernando
How about this:
WHERE NOT (COUNTRY EQ 'ENGLAND' AND CAR EQ 'JAGUAR');
Fernando
Prod WF 8.1.04, QA WF 8.2.03, Dev WF 8.2.03
April 02, 2014, 09:56 AM
j.gross
Francis and Fernando:
Better make that
WHERE NOT (COUNTRY EQ 'ENGLAND' OR CAR EQ 'JAGUAR')
April 02, 2014, 10:10 AM
Francis Mariani
Jack, not too sure of that - the OR may eliminate more than one wishes:
TABLE FILE CAR
SUM
COUNTRY
BODYTYPE
BY COUNTRY NOPRINT
BY BODYTYPE NOPRINT
END
TABLE FILE CAR
SUM
COUNTRY
BODYTYPE
BY COUNTRY NOPRINT
BY BODYTYPE NOPRINT
WHERE NOT (COUNTRY EQ 'ENGLAND' AND BODYTYPE EQ 'SEDAN');
END
TABLE FILE CAR
SUM
COUNTRY
BODYTYPE
BY COUNTRY NOPRINT
BY BODYTYPE NOPRINT
WHERE NOT (COUNTRY EQ 'ENGLAND' OR BODYTYPE EQ 'SEDAN');
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
April 02, 2014, 10:13 AM
j.gross
ok, I misread the original post
April 02, 2014, 12:06 PM
Rifaz
Thanks Francis,Jack and Fernando!!!
-Rifaz
WebFOCUS 7.7.x and 8.x
April 02, 2014, 04:47 PM
Waz
Hey, not the throw water on the creative fire here, but this is very basic stuff, and can be found in the manuals.