Re: Error deleting records!

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Murali

InfoCenter has this information - search on ALWUPD there and you will learn 
about how this attribute is set. Then you will have to figure out what to 
do, as you cannot change this after a physical file is created.

Do you have access to InfoCenter there?

Can you show us the DSPFD YTS, as well as DSPFD YTS9X11G? without breaking 
any confidentiality? The *BASIC level is fine - just copy/paste from the 
green screen. Are there referential integrity constraints on any of these? 
By the message, the second one HAS to be a view or logical file - the 
system does not get this stuff wrong. The logical is read-only because of 
the restrictions on the physical.

The SQL Reference manual has information on what makes something read-only, 
but I don't believe that is relevant here. Still, I suggest looking on 
InfoCenter under Database for that manual and doing a PDF search on the 
phrase 'read only' - no apostrophes. Also, a join logical is read-only, I 
believe.

HTH
Vern

At 12:01 AM 11/19/2003 -0800, you wrote:
> James,
> Thanks so much for your reply!
> The file YTS  is nt logical file ,I found from DSPFD
> that ALWDLT  is *NO for this file...
> But
> With SQL I am getting the following error :
>
> delete   FROM YTS WHERE F00001 like 'GDSRX11%'  .
>
> "View or logical file YST9X11G in QS36F read-only. "
> But this file is nt a logical file.....Iam really
> wondering why logical file is coming in error!This
> file doesnt any dependent files at all!
> Murali.