RE: [U2] Keys with @AM in them...
In UniData you cannot AE the edit.. That was my first bet... If it had been a @VM may have been able to! I'm going to try the BASIC route... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Drew Henderson Sent: Monday, April 07, 2008 3:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Keys with @AM in them... Trying to remember what I used to do in Universe to get rid of these Try having a select list of these records active, then going into the editor, and see if it will let you edit each record, and do an FD. HTH Drew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, April 07, 2008 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] Keys with @AM in them... How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
LOL - I don't have the keys -- it was a one-off piece of code. But I'll write a program -- I was trying to do a 'select' and use AE to remove the keys -- but that just will not work... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Monday, April 07, 2008 3:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Keys with @AM in them... uh, write the same program to construct the keys and delete them? There are notes about finding these actual keys (to use in your fix program) in one of my various UniData troubleshooting presentations - from U2U, at least. In the context of 'duplicate keys'. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] David Wolverton [EMAIL PROTECTED] et To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Keys with @AM in them... 04/07/2008 01:15 PM Please respond to [EMAIL PROTECTED] er.u2ug.org How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 09407543.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic29301.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
Have you tried to old 'ED' editor? Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Tuesday, April 08, 2008 8:37 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Keys with @AM in them... LOL - I don't have the keys -- it was a one-off piece of code. But I'll write a program -- I was trying to do a 'select' and use AE to remove the keys -- but that just will not work... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Monday, April 07, 2008 3:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Keys with @AM in them... uh, write the same program to construct the keys and delete them? There are notes about finding these actual keys (to use in your fix program) in one of my various UniData troubleshooting presentations - from U2U, at least. In the context of 'duplicate keys'. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] David Wolverton [EMAIL PROTECTED] et To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Keys with @AM in them... 04/07/2008 01:15 PM Please respond to [EMAIL PROTECTED] er.u2ug.org How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 09407543.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic29301.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
UniQuery parser truncates at @FM, making it very difficult to display keys with imbedded field marks. Fortunately the ECL RECORD command displays keys in their brawb form. Once you have found the key, you can write a small UniBasic program to construct the key and delete or rewrite the record with the proper key. Note: If you think you know the bad character in either the key or the data records, use b$UDTBIN/guide -Unb to search a file. Eg. If looking for char(0): bguide -U0 filenameb Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] [demime 1.01d removed an attachment of type image/gif which had a name of 09196980.gif] [demime 1.01d removed an attachment of type image/jpeg which had a name of 09618826.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
You could fix this by selecting all records EXCEPT those with keys containing @AM in the key, copying them to a temporary file, and then clearing the permanent file and copying from the temporary file back in. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, April 07, 2008 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] Keys with @AM in them... How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
I open the file in a program, then use an internal select and loop readnext Eg Open 'file' to handle else... Select handle Loop readnext key else exit if index(key,@fm,1) then delete handle,key Repeat This simply moves a pointer thru the file and doesn't attempt a value judgement of the data read -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: 07 April 2008 09:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] Keys with @AM in them... How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.22.8/1362 - Release Date: 2008/04/06 11:12 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
Trying to remember what I used to do in Universe to get rid of these Try having a select list of these records active, then going into the editor, and see if it will let you edit each record, and do an FD. HTH Drew -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Wolverton Sent: Monday, April 07, 2008 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] Keys with @AM in them... How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Keys with @AM in them...
Hi David, My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? The problem is that the select list is field mark delimited internally. If you can work out the record ids, you can delete them in the usual way but a select list isn't going to work. Martin Phillips, Ladybridge Systems Ltd --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Keys with @AM in them...
uh, write the same program to construct the keys and delete them? There are notes about finding these actual keys (to use in your fix program) in one of my various UniData troubleshooting presentations - from U2U, at least. In the context of 'duplicate keys'. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] David Wolverton [EMAIL PROTECTED] etTo Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Keys with @AM in them... 04/07/2008 01:15 PM Please respond to [EMAIL PROTECTED] er.u2ug.org How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 09407543.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic29301.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
I believe that the problem is that the hash algorithm used to determine which group the item goes into uses the whole key as provided to it, but everything after the first attribute mark becomes part of the item, and from the point of view of the system, stops being part of the key. So a key of A^B (where ^ is the attribute mark) gets assigned a group based on the modulo of the hash of A^B, but only A gets stored as the actual item-id. (B becomes attribute one and pushes all the others down.) So trying to EDit them or use delete with them may not actually work, as this process tries to find A^B, but can only see A. If you try to edit A, the hash algorithm is likely to arrive at a different modulo, and it will look in the group where A should have been (you might actually have an item-id A in that group) and won't find the bad one, which is in the wrong group. Depending on your Universe file type, I may be a bit off, and Universe might do something a subtly different, but that's the gist of your problem. The safest way to deal with this is to create a new file, then do something like this: COPY OLDFILE * TO:(NEWFILE This *might* actually work. Again, if you had both A^B and A in the file, the second one will complain. You could maybe use (D as an option to delete the ones that successfully copied, but that might fail, too, depending how it was implemented. You could then copy the remaining records to another file and figure out how to merge the duplicates. This advice comes with no warranty! Your mileage may vary. Good luck! ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wally Terhune Sent: Monday, April 07, 2008 1:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Keys with @AM in them... uh, write the same program to construct the keys and delete them? There are notes about finding these actual keys (to use in your fix program) in one of my various UniData troubleshooting presentations - from U2U, at least. In the context of 'duplicate keys'. Wally Terhune SWG Client Support - Information Management Software U2 Support Architect b IBM U2 Client Support Team 4700 S. Syracuse St., Denver, CO 80237 Tel: (303) 773-7969 T/L 656-7969 Mobile: (303) 807-6222 [EMAIL PROTECTED] David Wolverton [EMAIL PROTECTED] etTo Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] Keys with @AM in them... 04/07/2008 01:15 PM Please respond to [EMAIL PROTECTED] er.u2ug.org How do I fix this? My program wrote items with @AM in the key. (oops) Now, I can 'select' the items, but I cannot get rid of them - they show as non-existent. Is there a way to remove/clean up these records, or will I have to clear the file and copy the good records back in? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/jpeg which had a name of 09407543.jpg] [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic29301.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Keys with @AM in them...
If you are on UniVerse try setting the ALLOWMARKS flag in uvconfig, run uvregen, restart UniVerse and then programmatically delete them (if you generated the keys, hopefully you can recreate them), Otherwise - (as others have advised) SELECT and copy what you want, blat the file (CLEAR-FILE) and repopulate with what you want to keep. I'd put ALLOWMARKS back as found for personal choice afterwards - off. Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/