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?
SanthoshThis message has been edited. Last edited by: <Kathryn Henning>,
WebFOCUS 22.214.171.124 App Studio
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
In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
|Powered by Social Strata|