RE: InValid Characters
select the file save the list create a work file edit the list delete the invalid keys from the list save the list get the list copy file 1 to work file clear file 1 copy workl to file1 all if i understood the problem bob -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 22:50 To: 'U2 Users Discussion List' Subject: InValid Characters When I issue the following LIST command, there is are apparent bad characters, ascii box drawing characters. How can I clear them ? The two characters show up a single box below. Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit Up-Arrow mode, or UV.VI. I tried the ascii equivalents of the box characters per... DELETE PS ^210^201 Record ID ^210^201 not found. 0 records DELETEd. DELETE PS ^210 Record ID ^210 not found. The records for @ID 103662 and 101393 appear to be clean. DELETE PS ^D2 Record ID ^D2 not found. 0 records DELETEd. DELETE PS ^D2^C9 Record ID ^D2^C9 not found. 0 records DELETEd. Suggestions would be appreciated. --Bill --- LIST PS D.PS.. 103662 101393 101312 D.PS. 103662 NEXT.COMP.PN. PREV.COMP.PN. 103661 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. NEXT.COMP.PN. PREV.COMP.PN. QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. 101393 NEXT.COMP.PN. PREV.COMP.PN. 103626 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
the systems I work on don't have EDIT-LIST, and I never think to change the punctuation and try the revised form of the commands - I grew up on EDIT-LIST and SAVE-LIST, etc. The ECL parser should accept the dashed versions of these commands. Any chance you have a VOC entry (or something in the global catalog) for EDIT-LIST or EDIT.LIST that's getting in the way? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
Tim, Thanks - I just looked at CTLGTB and there is an entry there for both. EDIT-LIST looks like this: M 0 @UDTHOME/SYS_BP EDIT-LIST root EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST. In UDTHOME, we have a sys directory, which contains a SYS_BP file, which contains EDIT.LIST and EDIT_LIST, not EDIT-LIST. Does this indicate that one of my predecessors on these systems was getting adventuresome, or is this standard issue? Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Timothy Snyder [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, February 09, 2004 11:51 AM Subject: Re: InValid Characters the systems I work on don't have EDIT-LIST, and I never think to change the punctuation and try the revised form of the commands - I grew up on EDIT-LIST and SAVE-LIST, etc. The ECL parser should accept the dashed versions of these commands. Any chance you have a VOC entry (or something in the global catalog) for EDIT-LIST or EDIT.LIST that's getting in the way? Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
I tried to respond a while ago, but my message came back with The message's content type was not explicitly allowed. I'll try a different cut-and-paste approach. Hopefully this isn't a duplicate for anybody snip Susan Lynch [EMAIL PROTECTED] Thanks - I just looked at CTLGTB and there is an entry there for both. EDIT-LIST looks like this: M 0 @UDTHOME/SYS_BP EDIT-LIST root EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST. In UDTHOME, we have a sys directory, which contains a SYS_BP file, which contains EDIT.LIST and EDIT_LIST, not EDIT-LIST. snip Susan, That all looks like what I'm seeing on a system here, and both EDIT-LIST and EDIT.LIST work fine. What platform, UDT release, etc. are you working with? Just for giggles, it may be interesting to create a synonym VOC entry for EDIT-LIST that looks like this: 1: S 2: EDIT.LIST If that works, it may help track this down. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
Tim, UD 6.0.6 (but, if I remember correctly, this was true on the release 5 that we came from as well, and our standard policy is to uninstall and re-install Unidata for a new release, which should have replaced CTLGTB). This being my first experience with the Unidata flavor, I thought it was standard behavior - annoying but standard. So, rather than set up what I thought was a non-standard synonym (and have to set up on all the customer machines as well, if one of my colleagues started using it), I was just avoiding editing lists. The synonym entry in the VOC does work as expected. Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Timothy Snyder [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, February 09, 2004 1:41 PM Subject: Re: InValid Characters I tried to respond a while ago, but my message came back with The message's content type was not explicitly allowed. I'll try a different cut-and-paste approach. Hopefully this isn't a duplicate for anybody snip Susan Lynch [EMAIL PROTECTED] Thanks - I just looked at CTLGTB and there is an entry there for both. EDIT-LIST looks like this: M 0 @UDTHOME/SYS_BP EDIT-LIST root EDIT.LIST looks the same, but has EDIT.LIST instead of EDIT-LIST. In UDTHOME, we have a sys directory, which contains a SYS_BP file, which contains EDIT.LIST and EDIT_LIST, not EDIT-LIST. snip Susan, That all looks like what I'm seeing on a system here, and both EDIT-LIST and EDIT.LIST work fine. What platform, UDT release, etc. are you working with? Just for giggles, it may be interesting to create a synonym VOC entry for EDIT-LIST that looks like this: 1: S 2: EDIT.LIST If that works, it may help track this down. Tim Snyder IBM Data Management Solutions Consulting I/T Specialist , U2 Professional Services [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
InValid Characters
When I issue the following LIST command, there is are apparent bad characters, ascii box drawing characters. How can I clear them ? The two characters show up a single box below. Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit Up-Arrow mode, or UV.VI. I tried the ascii equivalents of the box characters per... DELETE PS ^210^201 Record ID ^210^201 not found. 0 records DELETEd. DELETE PS ^210 Record ID ^210 not found. The records for @ID 103662 and 101393 appear to be clean. DELETE PS ^D2 Record ID ^D2 not found. 0 records DELETEd. DELETE PS ^D2^C9 Record ID ^D2^C9 not found. 0 records DELETEd. Suggestions would be appreciated. --Bill --- LIST PS D.PS.. 103662 101393 101312 D.PS. 103662 NEXT.COMP.PN. PREV.COMP.PN. 103661 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. NEXT.COMP.PN. PREV.COMP.PN. QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. 101393 NEXT.COMP.PN. PREV.COMP.PN. 103626 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
Bill, Not sure whether you are on UV or UD, so I will avoid using the EDIT-LIST command (which UD does not have). Given that restriction, probably the easiest method would be to SELECT PS = [101393 BY-DSND @ID (assuming that @id is left-justified) If only 1 item selected, DELETE PS If more than 1 item selected, SELECT PS SAMPLE 1, then LIST PS to be sure that the one selected is the one with the unusual characters in the key. If yes, then repeat the two SELECTs and DELETE PS. If no, then your system is sorting unprintable characters differently than mine is, and you will have to play with the selection process in order to get the right record selected prior to deleting it. Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, February 06, 2004 5:49 PM Subject: InValid Characters When I issue the following LIST command, there is are apparent bad characters, ascii box drawing characters. How can I clear them ? The two characters show up a single box below. Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit Up-Arrow mode, or UV.VI. I tried the ascii equivalents of the box characters per... DELETE PS ^210^201 Record ID ^210^201 not found. 0 records DELETEd. DELETE PS ^210 Record ID ^210 not found. The records for @ID 103662 and 101393 appear to be clean. DELETE PS ^D2 Record ID ^D2 not found. 0 records DELETEd. DELETE PS ^D2^C9 Record ID ^D2^C9 not found. 0 records DELETEd. Suggestions would be appreciated. --Bill --- LIST PS D.PS.. 103662 101393 101312 D.PS. 103662 NEXT.COMP.PN. PREV.COMP.PN. 103661 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. NEXT.COMP.PN. PREV.COMP.PN. QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. 101393 NEXT.COMP.PN. PREV.COMP.PN. 103626 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: InValid Characters
The easiest way I got over this is to select the file by @ID. The control characters are usually at the top or the end (by.dsnd) Then do an ED file And then delete the record, stepping through the select list. Regards David Jordan Managing Consultant [EMAIL PROTECTED] Dacono Holdings Pty Ltd Business Technology Consulting PO Box 909 Lane Cove NSW 2066 Australia Ph 61 2 9418 8329 Fax 61 2 9427 2371 www.dacono.com.au -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: InValid Characters
UD has EDIT-LIST or EDIT.LIST. - Original Message - From: Susan Lynch [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Friday, February 06, 2004 6:51 PM Subject: Re: InValid Characters Bill, Not sure whether you are on UV or UD, so I will avoid using the EDIT-LIST command (which UD does not have). Given that restriction, probably the easiest method would be to SELECT PS = [101393 BY-DSND @ID (assuming that @id is left-justified) If only 1 item selected, DELETE PS If more than 1 item selected, SELECT PS SAMPLE 1, then LIST PS to be sure that the one selected is the one with the unusual characters in the key. If yes, then repeat the two SELECTs and DELETE PS. If no, then your system is sorting unprintable characters differently than mine is, and you will have to play with the selection process in order to get the right record selected prior to deleting it. Susan M. Lynch F.W. Davison Company, Inc. - Original Message - From: Brutzman, Bill [EMAIL PROTECTED] To: 'U2 Users Discussion List' [EMAIL PROTECTED] Sent: Friday, February 06, 2004 5:49 PM Subject: InValid Characters When I issue the following LIST command, there is are apparent bad characters, ascii box drawing characters. How can I clear them ? The two characters show up a single box below. Thus far, I have had no luck using EditPlus, HP-Unix vi, UniVerse Edit Up-Arrow mode, or UV.VI. I tried the ascii equivalents of the box characters per... DELETE PS ^210^201 Record ID ^210^201 not found. 0 records DELETEd. DELETE PS ^210 Record ID ^210 not found. The records for @ID 103662 and 101393 appear to be clean. DELETE PS ^D2 Record ID ^D2 not found. 0 records DELETEd. DELETE PS ^D2^C9 Record ID ^D2^C9 not found. 0 records DELETEd. Suggestions would be appreciated. --Bill --- LIST PS D.PS.. 103662 101393 101312 D.PS. 103662 NEXT.COMP.PN. PREV.COMP.PN. 103661 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. NEXT.COMP.PN. PREV.COMP.PN. QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION EFFECTIVE.DATE... EFFECTIVE.CODE... ENG.CHG.ID... DATE.ADDED... NWU.PN... PWU.PN... BALýNBR.. REFERENCEýDESIGNATORS. NOTEýREFERENCE... ECO DATE. D.PS. 101393 NEXT.COMP.PN. PREV.COMP.PN. 103626 QTY.PER.ASSY. TYPE. SCRAP.FACTOR. LEAD.TIME.OFFSET. OPERATION -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users