Talk About Network

Google





Data Bases > IBM DB2 > Re: Problem wit...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 5 of 5 Topic 9081 of 9564
Post > Topic >>

Re: Problem with IN predicate

by amir <ahsharif@[EMAIL PROTECTED] > Jul 19, 2008 at 04:16 AM

On Jul 15, 12:22=A0pm, Lennart <Erik.Lennart.Jons...@[EMAIL PROTECTED]
> wrote:
> On Jul 15, 7:28 am, amir <ahsha...@[EMAIL PROTECTED]
> wrote:
>
> > > I assume that your real query is different and that this is just an
> > > example? Anyhow, try:
> > Exactly!
> > > select 1 from sysibm.sysdummy1 where (1,1) IN ( values (1,1), (2,1)
)
>
> > I tried this but got error like before:
> > <<SQL0104N An unexpected token "," was found following "+ ) -".
> > Expected tokens may include: "". SQLSTATE=3D42601>>
>
> Which platform and version?
>
> /Lennart
I am connecting directly to DB2 7 Client Command Center
 




 5 Posts in Topic:
Problem with IN predicate
amir <ahsharif@[EMAIL   2008-07-13 06:13:54 
Re: Problem with IN predicate
Lennart <Erik.Lennart.  2008-07-13 07:18:41 
Re: Problem with IN predicate
amir <ahsharif@[EMAIL   2008-07-14 22:28:03 
Re: Problem with IN predicate
Lennart <Erik.Lennart.  2008-07-15 02:22:48 
Re: Problem with IN predicate
amir <ahsharif@[EMAIL   2008-07-19 04:16:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Wed Jan 7 22:09:53 PST 2009.