Re: Error deleting records!

[murali dhar <hydchap1@xxxxxxxxx>]

Nt sure of what error it is .But I was unable to
delete records ,I could save the SQL error for
reference.
Iam wondering why the error is saying
"View or logical file YST in QS36F read-only. "
when  the file YST is physical file ,dont ve
dependancies..
Murali
--- Booth Martin <Booth@xxxxxxxxxxxx> wrote:
> What happened when you tried to delete the records
> using DFU? 
>  
>
---------------------------------------------------------
> Booth Martin http://www.MartinVT.com
> Booth@xxxxxxxxxxxx
>
---------------------------------------------------------
>  
> -------Original Message-------
>  
> From: Midrange Systems Technical Discussion
> Date: 11/19/2003 8:14:35 PM
> To: Midrange Systems Technical Discussion
> Subject: Re: Error deleting records!
>  
> 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??
> _______________________________________________
> 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