Re: Can I do this in SQL? How?

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...

Regards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, Feb 9, 2010 at 3:11 PM, Luis Rodriguez <luisro58@xxxxxxxxx> wrote:

Joe,

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 and UPDATE on it. Heck, I can even use it
with UPDDTA!!.

Rehards,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, Feb 9, 2010 at 2:43 PM, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>wrote:

Jack Prucha wrote:

Thanks Joe & Rick.

Joe, it worked perfectly after I put the comma back in after the first

CTE.

I love CTEs. It turns SQL into a decent programming language. So do
things like T-SQL, but they're vendor specific and so defeat the entire
purpose. But ANSI standard functionality like CTEs makes SQL turn the
corner for me.

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.

Joe
--
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.