Re: Can I do this in SQL? How? -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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 mailing list archive is Copyright 1997-2024 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.