Re: Deleting records from query

Anshu:

In DFU create a program to change data.  Then use the program to call up
the record and press F23 twice to delete a record.  If you want to
delete many records based on a criteria, you can do so using SQL or an
RPG program.  

Pravin Hindocha wrote:
> 
> Hi
> 
> I am a trainee programmer, and have a small problem.
> I have used runqry *n <physical file > to see the records in the physical
> files.
> Now, I want to delete the records from this file .
> Could someone tell me how to go about it.
> 
> I thought I could delete them through the DFU but can't seem to find any
> option once I use STRDFU.
> 
> Any suggestions.
> 
> Can one use a CL command to delete the records without going into STRSDU ?
> 
> Thanks in advance.
> 
> Anshu Sharma
> email : anshu.sharma@btinternet.com

-- 
Thank You.

Regards

Dave Mahadevan.. mailto:mahadevan@fuse.net
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the RPG/400 Discussion Mailing List!  To submit a new         *
* message, send your mail to "RPG400-L@midrange.com".  To unsubscribe   *
* from this list send email to MAJORDOMO@midrange.com and specify       *
* 'unsubscribe RPG400-L' in the body of your message.  Questions should *
* be directed to the list owner / operator: david@midrange.com          *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *