Re: Error deleting records!

[murali dhar <hydchap1@xxxxxxxxx>]

Thanks to all who responded .while i was editing
before posting to midrange I did a small mistake.
Please read the error as 

"View or logical file YST in QS36F read-only"
there is only one file YST ,really sorry for the
confusion with two file names.
YST is physical file and doesnt ve any dependencies..I
am still wondering for the error iam receiving..
Thanks to all who responded!
Murali.

Again Iam pasting the query here
------------
Iam trying to delete 2 records from  file YTS but
getting an error.I am getting the same error and don't
understand  why? I have tried DFU & SQL.
Iwant to delete the 2 records in the file that start
with GDSRX11.

With SQL I am getting the following error :
 
delete   FROM YTS WHERE F00001 like 'GDSRX11%'  .
  
"View or logical file YST in QS36F read-only. "  
But this file is nt a logical file.....

One reason I thought could be 
Allow delete operation  . . . . : ALWDLT     *NO   ...
Can some one suggest me what could be the other
reasons??


------
--- Vern Hamberg <vhamberg@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
> 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.
> 
> 
> _______________________________________________
> 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.
> 


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree