DSXchange

I am writing a query similar to the below

select ename from emp where #eno# is null

#eno# is a job parameter when I pass the value as '' I am able to view the data from the oracle stage but when I run the job it gives me the error unknown argument IS and job gets aborted.

This is the only error msg I am getting in director.

How to trace whats the problem is as the same query is working well in oracle & even in datastage view data.

What stage? And we would need to see the actual query to help, not something 'similar' to it. In that same vein, please post the actual unedited error from the job's log. You've no idea how many of the wild gooses we've chased because people felt the need to obfuscate their problem by giving incomplete or 'something like this' examples.

Lastly, please confirm the parameter value - a string you leave empty, literally two single quotes, etc. What other values, if any, do you ever pass? The name of another field, for example? I'm wondering because using "where '' is null" is the same as leaving off the where clause entirely or doing something like "where 1=1"... you get all of the records.

WHERE '' IS NULL will never be true.

A zero-length string ("") is NOT the same as NULL. One has a known value, the other does not.

Actually, it *is* true... in Oracle.

It is NEVER true. Oracle is wrong.

Granted, but it equates to true in Oracle, regardless of however much that irks you. All Hail Larry the Great!

Oracle bin Larry

Ray is correct.The stage being used is oracle enterprise stage.I found an work around for that & implemented.Thanks to all of you,appreciate very much your help.

Could you please post your resolution to this problem? It will help future searchers if you close out this issue such that people can see both the problem and the solution.

whats the solution please?????

what was the work-around?

Used ANY filter and nvl to get that.Its more on the sql query side not the datastage.