Re: Can I do this in SQL? How?

[Luis Rodriguez <luisro58@xxxxxxxxx>]

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.