|
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
