Re: Can I do this in SQL? How?

Sorry,

My bad English at work again. I really meant a view created with the help of
a CTE. Sometimes I don't really think or express myself very well in English
(not that I'm very good doing it in Spanish, either :-) )

My apologies for the confusion...

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries


On Tue, Feb 9, 2010 at 3:54 PM, Dennis Lovelady <iseries@xxxxxxxxxxxx>wrote:

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

Luis, would you mind sharing that CTE that creates a view? I think there's
a misunderstanding going on here....

Thanks,

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Appeasers believe that if you keep on throwing steaks to a tiger, the
tiger
will become a vegetarian."
-- Heywood Broun



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