Focal Point
[CLOSED] Do we have any problem in "IN FILE" concept (where condition)

This topic can be found at:
http://forums.informationbuilders.com/eve/forums/a/tpc/f/1381057331/m/7157061036

April 14, 2013, 12:56 AM
Santhu
[CLOSED] Do we have any problem in "IN FILE" concept (where condition)
Do we have any problems faced in "IN FILE"
one week back i was using "IN FILE" in where condition.
now if i try to use same condition, report fails

(FOC1400) SQLCODE IS 936 (HEX: 000003A8)
: ORA-00936: missing expression
: Error context area: "COLUMN_NAME" IN(, , , ,
L (FOC1406) SQL OPEN CURSOR ERROR. : TABLE_NAME

if you observe closely IN list contains null values.

does anybody have any inputs on this error?

Regards,
Santhosh

This message has been edited. Last edited by: <Kathryn Henning>,


WebFOCUS 8.0.0.7 App Studio
April 14, 2013, 05:48 PM
Waz
Whats the code ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.05OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Know The Code

April 15, 2013, 09:19 AM
jgelona
Your file should have a separate value on every line and be formatted like this:
value 1
value 2
...
value n


Note that if the values are alpha, WebFOCUS will put the quotes around the string.

As testing for NULL in an IN clause, that never returns a true or false value. See this:

Understand how NULLs affect IN and EXISTS


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.