iSeries DB2 Delete Statement Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 12 Jul 2006 16:11 GMT

Found some samples that say this statement should work, but is doesn't
(invalid token at "Where (Key1," ). Is there something I'm doing
wrong or a better way to accomplish what I'm trying to do?

delete from FileA
Where (Key1, Key2)

not In
(select
Key1, Key2 From FileB)

TIA

Chris

Reply to this Message

Karl Hanson - 12 Jul 2006 18:34 GMT

> Found some samples that say this statement should work, but is doesn't
> (invalid token at "Where (Key1," ). Is there something I'm doing
[quoted text clipped - 6 lines]
> (select
> Key1, Key2 From FileB)

You are not doing anything wrong - this is supported in V5R4 but not
prior to that. There may be another way to phrase the WHERE clause to
get the same result, but I can't offer a suggestion offhand.

--
Karl Hanson

Reply to this Message

Chris - 12 Jul 2006 19:14 GMT

> You are not doing anything wrong - this is supported in V5R4 but not
> prior to that. There may be another way to phrase the WHERE clause to
> get the same result, but I can't offer a suggestion offhand.
>
> --
> Karl Hanson

Ah, I'm on V5R3

Reply to this Message