Query in ODBC stage

[pkomalla]

Hi all,

I am using ODBC stage to extract data from oracle for lookup. Here In user-generated query, I wrote a query ...

Select
column a.
column b,
new coulmn
where
(coulmn c=?)
union all
Select
column a.
column b,
new coulmn
where
(coulmn d=?);

Iam getting an error :

[datastage][SQLClient][ODBC][DataDirect][ODBClib] Invalid argument value

Can anyone help me

[pkomalla]

Sorry guys ,....following is the correct query



Select
column a.
column b,
new coulmn
from
table A
where
(coulmn c=?)
union all
Select
column a.
column b,
new coulmn
from
table A
where
(coulmn d=?);

still i get the error

[kris007]

Remove the ";" character at the end of the query. You should be good to go without it.

[pkomalla]

I found the problem........We cannot have two parameters(?) unless we have two key columns....

[chulett]

... and you better select as many fields in your query as you have columns in the stage, and do so in the same order.