unknown argument error

RAJEEV KATTA · Post by **RAJEEV KATTA** » Wed Dec 03, 2008 6:36 pm

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.

chulett · Post by **chulett** » Wed Dec 03, 2008 8:22 pm

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.

ray.wurlod · Post by **ray.wurlod** » Wed Dec 03, 2008 9:57 pm

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.

chulett · Post by **chulett** » Thu Dec 04, 2008 1:02 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Dec 04, 2008 1:45 pm

It is NEVER true. Oracle is wrong.

chulett · Post by **chulett** » Thu Dec 04, 2008 1:50 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Dec 04, 2008 2:01 pm

Oracle bin Larry

RAJEEV KATTA · Post by **RAJEEV KATTA** » Thu Dec 04, 2008 8:46 pm

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.

chulett · Post by **chulett** » Thu Dec 04, 2008 9:18 pm

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.

sinhasaurabh014 · Post by **sinhasaurabh014** » Fri Dec 05, 2008 6:06 am

whats the solution please?????

what was the work-around?

RAJEEV KATTA · Post by **RAJEEV KATTA** » Wed Dec 10, 2008 4:50 pm

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