Focal Point
[SOLVED] Negation of WHERE XXX IN FILE MYFILE

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

February 02, 2009, 11:19 AM
Jérény Deidda
[SOLVED] Negation of WHERE XXX IN FILE MYFILE
Hi

What's the negation of:

WHERE MYFIELD IN FILE MYFILE;

I tried with :

WHERE MYFIELD NOT IN/NOT-IN/NOT_IN FILE MYFILE

but without sucess.

Any idea?

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


WebFOCUS 7.6.4 running on Windows
Output formats : PDF, Excel and HTML
My blog
February 02, 2009, 11:27 AM
Francis Mariani
Try

WHERE NOT MYFIELD IN FILE MYFILE;



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
February 02, 2009, 11:35 AM
Jérény Deidda
Thanks Francis,

I didn't think to place the NOT in thuis position.

Topic can be closed.


WebFOCUS 7.6.4 running on Windows
Output formats : PDF, Excel and HTML
My blog
February 02, 2009, 11:36 AM
Darin Lee
Try WHERE NOT MYFIELD IN FILE MYFILE. This is documented in the Creating Reports with WebFOCUS Language manual>Selecting Records for Your Report


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
February 02, 2009, 11:38 AM
Darin Lee
Too slow on the draw. Got distracted after opening the post before any responses were posted. Now you know where the doc is.


Regards,

Darin


In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
February 02, 2009, 11:42 AM
Francis Mariani
Darin, you get bonus points for posting where it's documented.


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
February 02, 2009, 12:08 PM
Frans
Hi Jérény,

This will work:

NOT MYFIELD IN FILE MYFILE


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
February 02, 2009, 12:09 PM
Frans
oops, too slow Smiler


Test: WF 8.2
Prod: WF 8.2
DB: Progress, REST, IBM UniVerse/UniData, SQLServer, MySQL, PostgreSQL, Oracle, Greenplum, Athena.
February 02, 2009, 12:28 PM
Francis Mariani
I can be quick on the draw because I use Firefox 3 with the FocalPoint tab automatically refreshed every 5 minutes.


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