On Jul 13, 3:13 pm, amir <ahsha...@[EMAIL PROTECTED]
> wrote:
> I have a query in Oracle like this:
> Select 1 from dual
> where
> (1,1) IN ( (1,1), (2,1) )
>
> and want to convert it to DB2.
> I tried this query:
> Select 1 from sysibm.sysdummy1
> where
> (1,1) IN ( (1,1), (2,1) )
> I replaced "," with SPACE and ";" but got error.
>
> It will be appreciated to help me to solve this problem.
> Best,
I assume that your real query is different and that this is just an
example? Anyhow, try:
select 1 from sysibm.sysdummy1 where (1,1) IN ( values (1,1), (2,1) )
/Lennart
|
