Re: Can I do this in SQL? How?

A CTE [Common Table Expression] generates a temporary TABLE
[literally; i.e. uses temporary addresses, and thus has no owner]
which is scoped to [i.e. allows reference only within] the active
statement. Only a GLOBAL TEMPORARY TABLE could span statements or
be used in the UPDDTA utility. And unlike what might be inferred
from its moniker, the GTT is not actually a true temporary object
and hardly /global/ in the eyes of most.

Regards, Chuck

Luis Rodriguez wrote:

Sorry, full of typos...

Excuse for asking but, Why you say you can't update a CTE? I'm at
V5R3. I can create a view using CTE and do an UPDATE on it. Heck,
I can even use it with UPDDTA!!.

[Added] Of course, a JOIN is a different beast but, if I'm not
wrong, even that can be updated using a INSTEAD OF trigger...

<<SNIP>>

On Tue, Feb 9, 2010 at 2:43 PM, Joe Pluta

Jack Prucha wrote:

<<SNIP>>

<<SNIP>>

My biggest gripe is that, at least on V5R4, I can't create a
CTE and then turn around and use that in an UPDATE. That's a
real limitation for me. I don't know about V6R1, haven't had
the chance to try it.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.