|
Thanks to everyone who responded. I was planning on using Wrkdbf, but was able to solve the problem without it. I had been trying to use an OpnQryF and RPG program to select the guilty record and to delete it. I couldn't seem to get the rec deleted using this method until I realized that a portion of the key had the invalid data. So I ran the OpnQryF select a rec based on a substring of the key value, and was able to delete the rec. i.e. the key is bytes long, there was invalid data in byte #1. I changed the OpnQryF to select the rec based on bytes 2 - 8 of the key, rather then the whole key. Thanks again, Dave -----Original Message----- From: Leland, David [mailto:dleland@Harter.com] Sent: Thursday, September 27, 2001 11:17 AM To: 'midrange-l@midrange.com' Subject: RE: recs with invalid data This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. -- [ Picked text/plain from multipart/alternative ] We have a utility called SuperZap, from DYNAX RESOURCES, INC. that I use for just such an emergency. This is back from 1982 and the S/38 but it still works fine. Check on your system to see if you have such a beast around. I don't think they market it anymore and I couldn't find much on the company via Google. Dave -----Original Message----- From: Prowak, Dave [mailto:DProwak@ci.syracuse.ny.us] Sent: Thursday, September 27, 2001 10:11 AM To: midrange-l@midrange.com Subject: RE: recs with invalid data >You must enter the key of the record to be deleted. >Simply hitting F23 on its own will give the message >you describe. No, I already am entering the key value. DFU trys to bring up the entire record, as it would normally do. It then tells me it found invalid data. I try F23, and get the message I described. DFU won't do the job. -----Original Message----- From: MBarton@pink.co.uk [mailto:MBarton@pink.co.uk] Sent: Thursday, September 27, 2001 10:34 AM To: midrange-l@midrange.com Subject: RE: recs with invalid data >>I beleive you can delete the record usind a dfu. >>Simply enter the key field to (identify the particular record) >>and press enter >F23 will not work. I did try this out before posting by corrupting my data using WRKDBF so I know it works.. >When I hit F23, I get >the message >"Record to be deleted is not specified" >since the invalid data stops the record from being displayed. You must enter the key of the record to be deleted. Simply hitting F23 on its own will give the message you describe. Mike This communication and the information it contains: - (a) Is intended for the person(s) or organisation(s) named above and for no other person(s) or organisation(s). Access to this mail by anyone else is unauthorised. (b) Is confidential, and may be legally privileged or otherwise protected in law. Unauthorised use, circulation, copying or disclosure of any part of this communication may be unlawful. (c) May be susceptible to interference, and should not be assumed that it has come in its original form and/or from the stated sender or PinkRoccade UK accepts no responsibility for information, errors or omissions in this e-mail or use or misuse thereof or any act done or omitted to be done in connection with this communication. If you are not the intended recipient, please inform postmaster@pink.co.uk immediately and delete it and all copies from your system. _____________________________________________________________________ This message has been checked for all known viruses by PinkRoccade delivered through the MessageLabs Virus Control Centre. For further information visit http://www.uk.uu.net/products/security/virus/ _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l or email: MIDRANGE-L-request@midrange.com Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
