Stupid delete logical question

[Old Fossil Bama]

In DB2/400, if I run this statement: delete from ordvcrec a where not
exists(select * from i$paint b where a.part#=b.i$par t)

Where ORDVCREC is a join logical of physical files ORDVALID and
ORDMASCREC, will the rows being deleted be the "logical" rows from
ORDVCREC only, or could physical rows (records) be wiped out in
ORDVALID or ORDMASCREC?

I am assuming that only logical rows will be deleted from ORDVCREC,
but I am afraid to try it...

Thanks for any and all opinions and answers...

[Stefano P.]

Re: Stupid delete logical question

In DB2/400, if I run this statement: delete from ordvcrec a where not

exists(select * from i$paint b where a.part#=b.i$par t)

As Chuck as answered in c.s.i.a.misc, you have to delete records from
the physical files as
"a Join Logical file [SQL VIEW, or DDS LF], will not be update capable."

To check this, "Refer to DSPFD ORDVCREC to confirm that the database
considers the VIEW to disallow update capabilities"

Thanks for any and all opinions and answers...

Hi
Stefano P.

--
"Niuna impresa, per minima che sia,
può avere cominciamento e fine senza queste tre cose:
e cioè senza sapere, senza potere, senza con amor volere"
[Anonimo fiorentino, XIV sec.]

(togliere le "pinzillacchere " dall'indirizzo email ;-)

[Old Fossil Bama]

Re: Stupid delete logical question

On Jan 13, 4:47 pm, "Stefano P." <procs...@pinzi llacchere.yahoo .it>
wrote:

In DB2/400, if I run this statement:  delete from ordvcrec a where not
exists(select * from i$paint b where a.part#=b.i$par t)

>
As Chuck as answered in c.s.i.a.misc, you have to delete records from
the physical files as
"a Join Logical file [SQL VIEW, or DDS LF], will not be update capable."
>
To check this, "Refer to DSPFD ORDVCREC to confirm that the database
considers the VIEW to disallow update capabilities"
>

Thanks for any and all opinions and answers...

>
Hi
        Stefano P.
>
--
"Niuna impresa, per minima che sia,
  può avere cominciamento e fine senza queste tre cose:
  e cioè senza sapere, senza potere, senza con amor volere"
                 [Anonimo fiorentino, XIV sec.]
>
(togliere le "pinzillacchere " dall'indirizzo email  ;-)

Thanks, Stefano.