Hi Gerry
To answer your question. You should be able to use UPDATE function on the empty file. What this will do is open and then close the file. There should be no need to actually create a record and delete as the only thing you need is an open and close on the file. Just as a side note. If you have any question like this feel free in contacting our Hotline at 1-800-538-7822 (the call is free to clients who are paying maintenance). Robert Galambos Compuware Senior Technical Specialist IBM Certified Solutions Expert - DB2 UDB for OS/390 V7 Database Administration [EMAIL PROTECTED] Tel: +1 905 866 7000 Toll Free: +1 800 263 7189 Fax: +1 905 886 7023 Quebec: +1 877-281-1888 Compuware Canada Service is our best product Les renseignements contenus dans le présent message électronique sont confidentiels et concernent exclusivement le(s) destinataire(s) désigné(s). Il est strictement interdit de distribuer ou de copier ce message. Si vous avez reçu ce message par erreur, veuillez répondre par courriel à l'expéditeur et effacer ou détruire toutes les copies du présent message. -----Original Message----- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Gerry Anstey Sent: August 23, 2005 11:54 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Fileaid I want to open a new VSAM KSDS and write a record to it then delete the record so that the file is empty but had it's "Initial Load". I thought that fileaid could do this as it does it in the online version fine, but I want to set up a batch job. The initial load is easy enough but how can I delete a record? Looks like I'll have to knowck up a quick program to do it, it just had the ring of something that can be done by fileaid or the like. Gerry Kirk Talman <[EMAIL PROTECTED] To: IBM-MAIN@bama.ua.edu M> cc: Sent by: IBM Subject: Re: Fileaid Mainframe Discussion List <[EMAIL PROTECTED] .edu> 23/08/2005 16:21 Please respond to IBM Mainframe Discussion List Not sure what you mean by "in place"? We use SORT for that purpose, which requires a file with REUSE attribute and a work file. When SORTs are used to update a file "in place" without using a work file, we call them "suicide sorts". One could also use IDCAMS for the record creation. pup Gerry Anstey <[EMAIL PROTECTED]> wrote 08/23/2005 10:41 AM I'm talking about batch of course! Gerry ----- Forwarded by Gerry Anstey/JPMCHASE on 23/08/2005 15:41 ----- Hi Listers, How do you get Fileaid to create and delete records in place for a VSAM KSDS? I have RTFM'd but it is well hidden. thanks Gerry ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html