Re: [U2] Remove items from lsit in DICT
Or just EV the attribute and then C/B//G and FI twice. Assuming there are no linked MV attributes that also need messing with. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 06 April 2012 03:26 To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT G option for C might come in handy here (Global: repeats command until there are no more matches) ^ C/B^253//G Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 05, 2012 4:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Remove items from lsit in DICT ^ up-arrow-mode C/B^253// C C C C C C C -Original Message- From: Holt, Jake jh...@samsill.com To: u2-users u2-users@listserver.u2ug.org Sent: Thu, Apr 5, 2012 3:06 pm Subject: [U2] Remove items from lsit in DICT This is probably really simple, but I can't seem to find a way without riting a sub. Is there an easy way to simply remove items from a MV ield in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just emove the Bs. Thanks, Jake Holt | samsill | Information Technology Director p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.com mailto:jh...@samsill.com | www.samsill.com | ww.bindersforlife.com ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== D2VHiLeE8cjwJ+6UKgOADBjSxIHBYlYk1F8TccP!XTbKg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remove items from lsit in DICT
That will not remove the Bs but only replace them with nulls. You will have to remove the value marks as well. Of course that will not work on single values and if the last value is a B. My first thought was to use MODIFY command but I think that can also just replace an attribute or value with another value or null. On 06/04/2012 07:03, Martin Braid wrote: Or just EV the attribute and then C/B//G and FI twice. Assuming there are no linked MV attributes that also need messing with. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 06 April 2012 03:26 To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT G option for C might come in handy here (Global: repeats command until there are no more matches) ^ C/B^253//G Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, April 05, 2012 4:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Remove items from lsit in DICT ^ up-arrow-mode C/B^253// C C C C C C C -Original Message- From: Holt, Jakejh...@samsill.com To: u2-usersu2-users@listserver.u2ug.org Sent: Thu, Apr 5, 2012 3:06 pm Subject: [U2] Remove items from lsit in DICT This is probably really simple, but I can't seem to find a way without riting a sub. Is there an easy way to simply remove items from a MV ield in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just emove the Bs. Thanks, Jake Holt | samsill | Information Technology Director p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.commailto:jh...@samsill.com | www.samsill.com | ww.bindersforlife.com ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Click https://www.mailcontrol.com/sr/wQw0zmjPoHdJTZGyOCrrhg== D2VHiLeE8cjwJ+6UKgOADBjSxIHBYlYk1F8TccP!XTbKg== to report this email as spam. Epicor Software (UK) is a limited company registered in England Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remove items from lsit in DICT
You could try selecting BY-EXP dictname # B On 05/04/2012 23:05, Holt, Jake wrote: This is probably really simple, but I can't seem to find a way without writing a sub. Is there an easy way to simply remove items from a MV field in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just remove the Bs. Thanks, Jake Holt | samsill | Information Technology Director (p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.commailto:jh...@samsill.com | www.samsill.com | www.bindersforlife.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unwanted Duplicated
If this is Universe I would say look for some option somewhere that is not set. Perhaps it behaves differently between account flavors. For example, in a BASIC program in a PICK flavor account, in order to use multiple SELECT lists you have to put $OPTIONS -x (I think) at the top on the program. Shot in the dark. On 4/5/12, Greg Coelho coe...@american.edu wrote: Hey Guys, I am selecting SAVING UNIQUE on a multivalue field. I then MERGE.LIST these ID's with a larger group - which should itself only return Unique ID's. What I am getting returned is a sizeable number of duplicates. Looking closer it appears that these ID's are often attached to a value marker which suggests that they were sitting with a Null Value that was pulled in with the ID. 'GET.LIST WORKING.IMOD.6 TO 1' 'SELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE RESIDENTS' 'SAVE.LIST GET.IMOD.ADDRESS' 'GET.LIST GET.IMOD.ADDRESS TO 2' 'MERGE.LIST 1 UNION 2 TO 3' 'SAVE.LIST WORKING.IMOD.7 FROM 3' *** WORKING.IMOD.7 is full of dups! I was thinking about trying - SELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE RESIDENTS NO.NULLS' Any recommendations? As Aways - Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unwanted Duplicated
John, Thanks for the response. I on UniData. I was thinking that perhaps this was the result of a UDT.OPTION setting... Oh! I think I've just come across the answer - please see below: When performing a SELECT statement that employs the SAVING UNIQUE keyword against a multi-valued field - the resulting list will contain two valuemarks on each line with a number in between after the saved value. An example is useful to demonstrate: :SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED SAMPLE 100 SAVE.LIST LIST.TEST :AE SAVEDLISTS LIST.TEST000 Top of LIST.TEST000 in SAVEDLISTS, 345 lines, 4,093 characters. 001: ý1ý1 002: 1003926ý1ý1 003: 1003927ý2ý1 004: 1003928ý3ý1 005: 1024941ý1ý1 006: 1024942ý2ý1 007: 1024943ý3ý1 008: 1036527ý1ý1 009: 1036528ý2ý1 010: 1036529ý3ý1 The resulting list above causes issues with the LIST ALGERBRA command... These seemingly extraneous valuemarks and numbers are actually the normal behavior of UniData when using the SAVING UNIQUE keyword on a multi-valued field (which is the case with STTR.STUDENT.ACAD.CRED). The easiest way to get rid of the value marks and numbers that are added to each line in the savedlist after using the SAVING UNIQUE on a multi-valued field is to perform a subsequent select. In this situation the STTR.STUDENT.ACAD.CRED field is a multi-valued pointer to the STUDENT.ACAD.CRED file... with an active list (from the savedlist conaining the valuemarks or directly after the SAVING UNIQUE query) select again against the STUDENT.ACAD.CRED file. This will result in the same list of IDs and will not contain the valuemarks or numbers as seen after the SAVING UNIQUE query. Here are a couple examples that will produce the desired list in a savedlist record named GOOD.LIST: If you already have the list containing the valuemarks, etc... activate that list and select against the STUDENT.ACAD.CRED file: :SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED SAMPLE 100 147 records selected to list 0. SAVE.LIST RAW.LIST 147 key(s) saved to 1 record(s). :GET.LIST RAW.LIST 147 records retrieved to list 0. SELECT STUDENT.ACAD.CRED 146 records selected to list 0. The following record ids do not exist: SAVE.LIST GOOD.LIST 146 key(s) saved to 1 record(s). : If you perform a query using the SAVING UNIQUE keyword against a multi-valued field, you can execute the second query immediately: :SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED SAMPLE 100 147 records selected to list 0. SELECT STUDENT.ACAD.CRED 146 records selected to list 0. The following record ids do not exist: SAVE.LIST GOOD.LIST 146 key(s) saved to 1 record(s). : If the list produced from the SAVING UNIQUE query does not produce a list of IDs for another file... then it will be necessary to remove the extra value marks and numbers manually. From: John Thompson jthompson...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 04/06/2012 08:48 AM Subject:Re: [U2] Unwanted Duplicated Sent by:u2-users-boun...@listserver.u2ug.org If this is Universe I would say look for some option somewhere that is not set. Perhaps it behaves differently between account flavors. For example, in a BASIC program in a PICK flavor account, in order to use multiple SELECT lists you have to put $OPTIONS -x (I think) at the top on the program. Shot in the dark. On 4/5/12, Greg Coelho coe...@american.edu wrote: Hey Guys, I am selecting SAVING UNIQUE on a multivalue field. I then MERGE.LIST these ID's with a larger group - which should itself only return Unique ID's. What I am getting returned is a sizeable number of duplicates. Looking closer it appears that these ID's are often attached to a value marker which suggests that they were sitting with a Null Value that was pulled in with the ID. 'GET.LIST WORKING.IMOD.6 TO 1' 'SELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE RESIDENTS' 'SAVE.LIST GET.IMOD.ADDRESS' 'GET.LIST GET.IMOD.ADDRESS TO 2' 'MERGE.LIST 1 UNION 2 TO 3' 'SAVE.LIST WORKING.IMOD.7 FROM 3' *** WORKING.IMOD.7 is full of dups! I was thinking about trying - SELECT ADDRESS WITH ADDRESS.CHANGE.DATE GE ':X.CHG.DATE:' SAVING UNIQUE RESIDENTS NO.NULLS' Any recommendations? As Aways - Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unwanted Duplicated
On 04/06/12 09:10, Greg Coelho wrote: John, Thanks for the response. I on UniData. I was thinking that perhaps this was the result of a UDT.OPTION setting... Oh! I think I've just come across the answer - please see below: When performing a SELECT statement that employs the SAVING UNIQUE keyword against a multi-valued field - the resulting list will contain two valuemarks on each line with a number in between after the saved value. An example is useful to demonstrate: :SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED SAMPLE 100 SAVE.LIST LIST.TEST :AE SAVEDLISTS LIST.TEST000 Top of LIST.TEST000 in SAVEDLISTS, 345 lines, 4,093 characters. 001: ý1ý1 002: 1003926ý1ý1 003: 1003927ý2ý1 004: 1003928ý3ý1 005: 1024941ý1ý1 006: 1024942ý2ý1 007: 1024943ý3ý1 008: 1036527ý1ý1 009: 1036528ý2ý1 010: 1036529ý3ý1 Correct - this is normal behavior. The way to remove these is to GET.LIST and then perform a select against the file for which these are keys and save it again. We dealt with this years ago in a similar situation. So you would followup with GET.LIST LIST.TEST SELECT STUDENT.ACAD.CRED SAVE.LIST LIST.TEST and your list will now be free of the @VM garbage. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unwanted Duplicated
Thanks Jeff! From: Jeff Butera jbut...@hampshire.edu To: u2-users@listserver.u2ug.org Date: 04/06/2012 09:28 AM Subject:Re: [U2] Unwanted Duplicated Sent by:u2-users-boun...@listserver.u2ug.org On 04/06/12 09:10, Greg Coelho wrote: John, Thanks for the response. I on UniData. I was thinking that perhaps this was the result of a UDT.OPTION setting... Oh! I think I've just come across the answer - please see below: When performing a SELECT statement that employs the SAVING UNIQUE keyword against a multi-valued field - the resulting list will contain two valuemarks on each line with a number in between after the saved value. An example is useful to demonstrate: :SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED SAMPLE 100 SAVE.LIST LIST.TEST :AE SAVEDLISTS LIST.TEST000 Top of LIST.TEST000 in SAVEDLISTS, 345 lines, 4,093 characters. 001: ý1ý1 002: 1003926ý1ý1 003: 1003927ý2ý1 004: 1003928ý3ý1 005: 1024941ý1ý1 006: 1024942ý2ý1 007: 1024943ý3ý1 008: 1036527ý1ý1 009: 1036528ý2ý1 010: 1036529ý3ý1 Correct - this is normal behavior. The way to remove these is to GET.LIST and then perform a select against the file for which these are keys and save it again. We dealt with this years ago in a similar situation. So you would followup with GET.LIST LIST.TEST SELECT STUDENT.ACAD.CRED SAVE.LIST LIST.TEST and your list will now be free of the @VM garbage. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remove items from lsit in DICT
I need to do it from a dictionary item: 1: I 2: Trans(FILE,F1,1,X);remove the Bs from @1 Basically I am trying to remove our house rep account from the list of rep numbers when I trans them to the sales order file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 4:05 AM To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT You could try selecting BY-EXP dictname # B On 05/04/2012 23:05, Holt, Jake wrote: This is probably really simple, but I can't seem to find a way without writing a sub. Is there an easy way to simply remove items from a MV field in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just remove the Bs. Thanks, Jake Holt | samsill | Information Technology Director (p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.commailto:jh...@samsill.com | www.samsill.com | www.bindersforlife.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unwanted Duplicated
If these are long lists, it may be best to save the list with its duplicates, shell out and execute unix command sort -u on the saved lists. No database i/o. Unless UD has some feature beyond UV's at this particular point. Note that sort -u output is sorted, but not necessarily by the same algorithm as UD or UV uses. cds On 4/6/2012 8:32 AM, Greg Coelho wrote: Thanks Jeff! From: Jeff Buterajbut...@hampshire.edu To: u2-users@listserver.u2ug.org Date: 04/06/2012 09:28 AM Subject:Re: [U2] Unwanted Duplicated Sent by:u2-users-boun...@listserver.u2ug.org On 04/06/12 09:10, Greg Coelho wrote: John, Thanks for the response. I on UniData. I was thinking that perhaps this was the result of a UDT.OPTION setting... Oh! I think I've just come across the answer - please see below: When performing a SELECT statement that employs the SAVING UNIQUE keyword against a multi-valued field - the resulting list will contain two valuemarks on each line with a number in between after the saved value. An example is useful to demonstrate: :SELECT STUDENT.TERMS SAVING UNIQUE STTR.STUDENT.ACAD.CRED SAMPLE 100 SAVE.LIST LIST.TEST :AE SAVEDLISTS LIST.TEST000 Top of LIST.TEST000 in SAVEDLISTS, 345 lines, 4,093 characters. 001: ý1ý1 002: 1003926ý1ý1 003: 1003927ý2ý1 004: 1003928ý3ý1 005: 1024941ý1ý1 006: 1024942ý2ý1 007: 1024943ý3ý1 008: 1036527ý1ý1 009: 1036528ý2ý1 010: 1036529ý3ý1 Correct - this is normal behavior. The way to remove these is to GET.LIST and then perform a select against the file for which these are keys and save it again. We dealt with this years ago in a similar situation. So you would followup with GET.LIST LIST.TEST SELECT STUDENT.ACAD.CRED SAVE.LIST LIST.TEST and your list will now be free of the @VM garbage. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remove items from lsit in DICT
Jake TRANS will return the raw data, so I'd write a little Basic subroutine, compile and catalog it globally and use SUBR( to call it in the dict. You either loop trough the array and delete the unwanted values or you could use SWAP and end up with a 6 liner like this. SUBROUTINE GETREP(RET.VALUE,ARRAY) SWAPSTRING = 'B':@VM SWAP SWAPSTRING WITH '' IN ARRAY SWAP 'B' WITH '' IN ARRAY RET.VALUE = ARRAY RETURN I haven't used SWAP with @VM so I won't guarantee that it'll work and you might have to use LOOP or FOR NEXT in your subroutine after all. So in the end your line 2 in your DICT item would look something like this: SUBR(GETREP,TRANS(FILE,F1,1,X)) Sometimes it's just the easiest way and in my experience quite fast too. Mecki On 06/04/2012 14:48, Holt, Jake wrote: I need to do it from a dictionary item: 1: I 2: Trans(FILE,F1,1,X);remove the Bs from @1 Basically I am trying to remove our house rep account from the list of rep numbers when I trans them to the sales order file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 4:05 AM To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT You could try selecting BY-EXP dictname # B On 05/04/2012 23:05, Holt, Jake wrote: This is probably really simple, but I can't seem to find a way without writing a sub. Is there an easy way to simply remove items from a MV field in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just remove the Bs. Thanks, Jake Holt | samsill | Information Technology Director (p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.commailto:jh...@samsill.com| www.samsill.com | www.bindersforlife.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remove items from lsit in DICT
Jake, Try TRANS(FILE,F1,1,X);IFS(NES(@,REUSE('B')),@,REUSE(''));TRIM(@,@SM) Cheers, Andy From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Friday, 6 April 2012, 14:48 Subject: Re: [U2] Remove items from lsit in DICT I need to do it from a dictionary item: 1: I 2: Trans(FILE,F1,1,X);remove the Bs from @1 Basically I am trying to remove our house rep account from the list of rep numbers when I trans them to the sales order file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 4:05 AM To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT You could try selecting BY-EXP dictname # B On 05/04/2012 23:05, Holt, Jake wrote: This is probably really simple, but I can't seem to find a way without writing a sub. Is there an easy way to simply remove items from a MV field in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just remove the Bs. Thanks, Jake Holt | samsill | Information Technology Director (p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.commailto:jh...@samsill.com | www.samsill.com | www.bindersforlife.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remove items from lsit in DICT
Mecki, Thanks, Ultimatly it's probably the only way to do it. It does sort of surprise me, given the general power and years of use of U2 dictionaries, there isn't a way to remove or filter MV values inline. Thanks all, I'll just go with a sub =) Jake -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 9:39 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Remove items from lsit in DICT Jake TRANS will return the raw data, so I'd write a little Basic subroutine, compile and catalog it globally and use SUBR( to call it in the dict. You either loop trough the array and delete the unwanted values or you could use SWAP and end up with a 6 liner like this. SUBROUTINE GETREP(RET.VALUE,ARRAY) SWAPSTRING = 'B':@VM SWAP SWAPSTRING WITH '' IN ARRAY SWAP 'B' WITH '' IN ARRAY RET.VALUE = ARRAY RETURN I haven't used SWAP with @VM so I won't guarantee that it'll work and you might have to use LOOP or FOR NEXT in your subroutine after all. So in the end your line 2 in your DICT item would look something like this: SUBR(GETREP,TRANS(FILE,F1,1,X)) Sometimes it's just the easiest way and in my experience quite fast too. Mecki On 06/04/2012 14:48, Holt, Jake wrote: I need to do it from a dictionary item: 1: I 2: Trans(FILE,F1,1,X);remove the Bs from @1 Basically I am trying to remove our house rep account from the list of rep numbers when I trans them to the sales order file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 4:05 AM To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT You could try selecting BY-EXP dictname # B On 05/04/2012 23:05, Holt, Jake wrote: This is probably really simple, but I can't seem to find a way without writing a sub. Is there an easy way to simply remove items from a MV field in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just remove the Bs. Thanks, Jake Holt | samsill | Information Technology Director (p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.commailto:jh...@samsill.com| www.samsill.com | www.bindersforlife.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Remove items from lsit in DICT
Thanks Andy. That worked perfectly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum Sent: Friday, April 06, 2012 10:51 AM To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT Jake, Try TRANS(FILE,F1,1,X);IFS(NES(@,REUSE('B')),@,REUSE(''));TRIM(@,@SM) Cheers, Andy From: Holt, Jake jh...@samsill.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Friday, 6 April 2012, 14:48 Subject: Re: [U2] Remove items from lsit in DICT I need to do it from a dictionary item: 1: I 2: Trans(FILE,F1,1,X);remove the Bs from @1 Basically I am trying to remove our house rep account from the list of rep numbers when I trans them to the sales order file. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 4:05 AM To: U2 Users List Subject: Re: [U2] Remove items from lsit in DICT You could try selecting BY-EXP dictname # B On 05/04/2012 23:05, Holt, Jake wrote: This is probably really simple, but I can't seem to find a way without writing a sub. Is there an easy way to simply remove items from a MV field in a dictionary? For instance if I have a MV with A, A,A,B,B,B,B,C,C,C and wanted to just remove the Bs. Thanks, Jake Holt | samsill | Information Technology Director (p) 817-536-1906 x 217 | 5740 Hartman Road Fort Worth TX 76119 jh...@samsill.commailto:jh...@samsill.com | www.samsill.com | www.bindersforlife.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind
One other potential issue just came to mind. I think AD user names are returned by winbind in the form domain\user by default. If your winbind is configured this way, it could be that udt doesn't like seeing the backslash character in the user name. This behaviour can be turned off with the following setting in smb.conf: winbind use default domain = yes You can see how user names are currently being reported by winbind with wbinfo -u. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, April 05, 2012 9:08 AM To: U2 Users List Subject: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind We are finally in the process of upgrading our old UD 5.2 system on Solaris to 7.2 running on a virtual RH Linux server. So far everything seems to work OK. We can log into the database as the root user fine. We can log into the database as a local linux user fine. But we don't want to create local users on the linux box as it is another set of user accounts / passwords to maintain. To get round this we are using winbind to allow users to login to the Linux server with their Windows Active Directory credentials. This works well however when we come to run the udt command in the data directory we get the following error Illegal User ID then the UID of the Winbind user. There is obviously some check that occurs when udt starts to see if the user is a valid linux user, udt must not be able to query the authentication mechanism and therefore will not allow the user to run udt. Is there a switch or another way to make this work? Thanks Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind
Thanks John, we will check all those back at work on Tuesday. This is a sample of the actual error message we see: */Illegal user id = (16777216). Mecki /* On 06/04/2012 21:13, John Hester wrote: One other potential issue just came to mind. I think AD user names are returned by winbind in the form domain\user by default. If your winbind is configured this way, it could be that udt doesn't like seeing the backslash character in the user name. This behaviour can be turned off with the following setting in smb.conf: winbind use default domain = yes You can see how user names are currently being reported by winbind with wbinfo -u. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, April 05, 2012 9:08 AM To: U2 Users List Subject: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind We are finally in the process of upgrading our old UD 5.2 system on Solaris to 7.2 running on a virtual RH Linux server. So far everything seems to work OK. We can log into the database as the root user fine. We can log into the database as a local linux user fine. But we don't want to create local users on the linux box as it is another set of user accounts / passwords to maintain. To get round this we are using winbind to allow users to login to the Linux server with their Windows Active Directory credentials. This works well however when we come to run the udt command in the data directory we get the following error Illegal User ID then the UID of the Winbind user. There is obviously some check that occurs when udt starts to see if the user is a valid linux user, udt must not be able to query the authentication mechanism and therefore will not allow the user to run udt. Is there a switch or another way to make this work? Thanks Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Change default UniVerse account on Solaris and ManFact
I just migrated my company from a single user instance to a multi-plant instance on ManFact, over UniVerse and Solaris. This included an account change from MANLIVE to another account. I think I need to change a .profile entry to change the account that our users are logged into by default, but no one (Including Epicore) and tell me where that path is. Does anyone have any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Change default UniVerse account on Solaris and ManFact
John, On our HP-UX I look in '/home'. There is a directory for each user id and '.profile' is in there. Marc Rutherford Principal Programmer Analyst Advanced Bionics LLC 661) 362 1754 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Varney Sent: Friday, April 06, 2012 2:58 PM To: 'U2 Users List' Subject: [U2] Change default UniVerse account on Solaris and ManFact I just migrated my company from a single user instance to a multi-plant instance on ManFact, over UniVerse and Solaris. This included an account change from MANLIVE to another account. I think I need to change a .profile entry to change the account that our users are logged into by default, but no one (Including Epicore) and tell me where that path is. Does anyone have any ideas? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind
No problem, Mecki, glad to help. From that message it does appear that udt isn't able to resolve the user's name from their numeric ID. One other thing to check is this setting in smb.conf: winbind enum users = true If that's set to false, that's a likely cause of the error you're getting. The default is true, though, so I doubt that's it. If the enum users setting is true, when you execute getent passwd, you should get a unified list of all local and AD users. The system calls that getent is using to return the list are the same that any other application should be using. If you're not getting a unified list, then something is wrong with the winbind config. If you are getting a unified list, then I suspect something non-standard has been written into udt and there might not be an easy fix. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, April 06, 2012 1:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind Thanks John, we will check all those back at work on Tuesday. This is a sample of the actual error message we see: */Illegal user id = (16777216). Mecki /* On 06/04/2012 21:13, John Hester wrote: One other potential issue just came to mind. I think AD user names are returned by winbind in the form domain\user by default. If your winbind is configured this way, it could be that udt doesn't like seeing the backslash character in the user name. This behaviour can be turned off with the following setting in smb.conf: winbind use default domain = yes You can see how user names are currently being reported by winbind with wbinfo -u. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, April 05, 2012 9:08 AM To: U2 Users List Subject: [U2] Logging on to UD 7.2 on RH Linux using Active Directory andwinbind We are finally in the process of upgrading our old UD 5.2 system on Solaris to 7.2 running on a virtual RH Linux server. So far everything seems to work OK. We can log into the database as the root user fine. We can log into the database as a local linux user fine. But we don't want to create local users on the linux box as it is another set of user accounts / passwords to maintain. To get round this we are using winbind to allow users to login to the Linux server with their Windows Active Directory credentials. This works well however when we come to run the udt command in the data directory we get the following error Illegal User ID then the UID of the Winbind user. There is obviously some check that occurs when udt starts to see if the user is a valid linux user, udt must not be able to query the authentication mechanism and therefore will not allow the user to run udt. Is there a switch or another way to make this work? Thanks Mecki ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users