Re: Error deleting records!

[murali dhar <hydchap1@xxxxxxxxx>]

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.

--- "James W. Kilgore" <email@xxxxxxxxxxxxxxxxxxx>
wrote:
> Murali,
> 
> Sorry I forgot to add the smily face to my last
> post. :)
> 
> But, let me ask you, are you just guessing that the
> logical has *NO or 
> is that a fact?
> 
> If this is a fact, then I would have to guess that
> the permissions 
> policy is that no deletes are allowed through a
> logical, only through 
> the physical file and you would need to change your
> program to perform 
> the delete against the physical even though all
> other processing is done 
> through the logical.
> 
> If you are just guessing yourself, do a DSPFD and
> find out for sure 
> before you start looking for other reasons.
> 
> Now, I'm going to go out on a branch and also add
> that the system policy 
> may be that all deletes must be done through a
> record requester/server 
> program and even if you used the physical file in
> your program the 
> delete operation may still fail.
> 
> Let us know what got in your way, just for the
> archives if nothing else 
> so that someone in the future has this situation
> they can also find an 
> answer.
> 
> Regards,
> J. Kilgore
> 
> _______________________________________________
> 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