Prev: db2 Shared CGTT(Global Temp Table) Data ploblem?
Next: CLPPLus
From: Tonkuma on 30 Jun 2010 18:31
I want to add a note.

> > WHEN NOT MATCHED
> > AND EXISTS
> > (SELECT 0
> > FROM Auctions e
> > WHERE e.item_id = b.item_id
> > ) THEN
> > INSERT
>
I also tried:
WHERE m.item_id = a.item_id

It returned error:
SQL0206N "A.ITEM_ID" is not valid in the context where it is used.

So, I thought that the target table can't be referred in WHEN NOT
MATCHED clause.
And it would be rational.


First  |  Prev  | 
Pages: 1 2 3
Prev: db2 Shared CGTT(Global Temp Table) Data ploblem?
Next: CLPPLus