Re: SQL Updateing a Join

Continuing with this, I created a view to do what I need, but now I get
"View or logical file CUVPOCLOSE in MNWTEST read-only." I don't see any way
to make this updatable. I see one of the rules is there can't be multiple
tables.

On 1/2/06, Mike Wills <koldark@xxxxxxxxx> wrote:
>
> I have this select stmt:
> SELECT * FROM LAWDBF7/DBPOPLI DBPOPLI, LAWDBF7/DBPOPAO
> DBPOPAO WHERE DBPOPLI.DBPLI_COMPANY = DBPOPAO.DBPAO_COMPANY AND
> DBPOPLI.DBPLI_PO_NUMBER = DBPOPAO.DBPAO_PO_NUMBER AND
> DBPOPLI.DBPLI_LINE_NBR = DBPOPAO.DBPAO_LINE_NBR AND ( (
> DBPLI_CLOSED_FL = 'N' AND DBPLI_CANCELLED_FL = 'N') AND
> DBPLI_QUANTITY = DBPLI_APPROVE_QTY AND DBPLI_REC_QTY =
> DBPLI_APPROVE_QTY)
>
> I am want to update a field in DBPOPLI without the join it would be
> something like
> UPDATE MNWTEST/DBPOPLI SET DBPLI_CLOSED_FL = 'Y'
>     WHERE ((DBPLI_CLOSED_FL = 'N' AND
>             DBPLI_CANCELLED_FL = 'N') AND
>             DBPLI_QUANTITY = DBPLI_APPROVE_QTY AND
>             DBPLI_REC_QTY =DBPLI_APPROVE_QTY)
>
> I found some help on a site on how to do this with DB2 here 
> (http://www.devx.com/tips/Tip/14577 )
> however, it appears like iSeries doesn't support this method of updating
> records. (I know iSeries isn't technically DB2, but generally it has worked
> in the past). We are on V5R3 now. How would I do this short of a simple
> program which I am about ready to write.
>
> --
> Mike Wills
> koldark@xxxxxxxxx
> http://mikewills.name
> Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
>
> "There are 10 types of people in the world: those who understand binary,
> and those who don't." -Unknown




--
Mike Wills
koldark@xxxxxxxxx
http://mikewills.name
Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.

"There are 10 types of people in the world: those who understand binary, and
those who don't." -Unknown