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>,

Whats the code ?

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