Re: [U2] How to copy only @ID from one file to anothers
George, We are using a proprietary version of Unidata and it appears that I can setup a Secondary Pointer. Once setup this works like a charm. Thanks for steering me in the right direction. Greg From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 06/17/2013 01:04 PM Subject:Re: [U2] How to copy only @ID from one file to anothers Sent by:u2-users-boun...@listserver.u2ug.org I didn't think you could set up a foreign key dependency in UV? The only thing I can think of would be to setup a trigger on the parent file, That computes the ID that will be used in the child file and if it doesn't exist Create in the child file. This way, the parent file will push the @ID into the child file, whereas if you Want to pull the @ID from the parent file, maybe setup a PHANTOM that runs every Minute or so, but that won't guarantee that a record could be added to the parent File while the PHANTOM is sleeping between runs. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Monday, June 17, 2013 12:43 PM To: U2 Users List Subject: Re: [U2] How to copy only @ID from one file to anothers Guys, I am attempting to create a store computed column data from a 'co' file. How do I set this up so the stored computed column file see a new record from the parent file? and how do I initially load the ID's? Thanks, Greg ___ 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] How to copy only @ID from one file to anothers
Guys, I am attempting to create a store computed column data from a 'co' file. How do I set this up so the stored computed column file see a new record from the parent file? and how do I initially load the ID's? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I find the code?
All, I am not versed in (PQ) PROC. Can anybody tell where I have to go to find the code for A26.ISS.EMPLOYMENT? :AE VOC A26.ISS.EMPLOYMENT 3 lines long. : P 0001: PQ 0002: HRUN WBP A26.ISS.EMPLOYMENT 0003: P Bottom at line 3. As Always, THANKS! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do I find the code?
Unfortunately that was one of the first things I tried... :AE WBP A26.ISS.EMPLOYMENT Top of New A26.ISS.EMPLOYMENT in WBP. *--: P Top. Top of new record. It looks like A26.ISS.EMPLOYMENT doesn't live in WBP. Greg From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 03/05/2013 07:51 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org You have a file called WBP so ED WBP A26.ISS.EMPLOYMENT -Original Message- From: Greg Coelho coe...@american.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 5, 2013 4:50 pm Subject: Re: [U2] How do I find the code? All, I am not versed in (PQ) PROC. Can anybody tell where I have to go to find the code for A26.ISS.EMPLOYMENT? :AE VOC A26.ISS.EMPLOYMENT 3 lines long. : P 0001: PQ 0002: HRUN WBP A26.ISS.EMPLOYMENT 0003: P Bottom at line 3. As Always, THANKS! Greg ___ 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] How do I find the code?
Kate, Thanks! We do have WBP.OBS and it is populated with some 20 items - none of which is A26.ISS.EMPLOYMENT. Any other place this could be stashed? Greg From: Kate Stanton k...@walstan.com To: U2 Users List u2-users@listserver.u2ug.org, Date: 03/05/2013 08:52 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org There is a UniBasic program for which the compiled object is in the WBP.O file. You may find its source in the WBP file. This VOC entry is to run that program. On 6 March 2013 13:49, Greg Coelho coe...@american.edu wrote: All, I am not versed in (PQ) PROC. Can anybody tell where I have to go to find the code for A26.ISS.EMPLOYMENT? :AE VOC A26.ISS.EMPLOYMENT 3 lines long. : P 0001: PQ 0002: HRUN WBP A26.ISS.EMPLOYMENT 0003: P Bottom at line 3. As Always, THANKS! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Kate Stanton Walstan Systems Ltd 4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand Phone: + 64 9 360 5310 Mobile: + 64 21 400 486 Email: k...@walstan.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] How do I find the code?
Can't seem to find it in either WBP.O or WBP.OBS (I do have a VOC listing for WBP.OBS). From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 03/05/2013 09:06 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org Then Greg I suggest someone has stripped the source, and left you with only the object. You can do ED WBP.O A26.ISS.EMPLOYMENT to verify that it exists, but DO NOT LIST IT it will screw up your terminal emulator software most likely if you display the object code ED only gives you Top, then you can do EX right away -Original Message- From: Greg Coelho coe...@american.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 5, 2013 5:52 pm Subject: Re: [U2] How do I find the code? Unfortunately that was one of the first things I tried... :AE WBP A26.ISS.EMPLOYMENT Top of New A26.ISS.EMPLOYMENT in WBP. *--: P Top. Top of new record. It looks like A26.ISS.EMPLOYMENT doesn't live in WBP. Greg From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 03/05/2013 07:51 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org You have a file called WBP so ED WBP A26.ISS.EMPLOYMENT -Original Message- From: Greg Coelho coe...@american.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 5, 2013 4:50 pm Subject: Re: [U2] How do I find the code? All, I am not versed in (PQ) PROC. Can anybody tell where I have to go to find the code for A26.ISS.EMPLOYMENT? :AE VOC A26.ISS.EMPLOYMENT 3 lines long. : P 0001: PQ 0002: HRUN WBP A26.ISS.EMPLOYMENT 0003: P Bottom at line 3. As Always, THANKS! Greg ___ 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] How do I find the code?
This is a good point. I have been trying to track down the reason why this process is NOT working. I've already spent too much time going down this rabbit hole where I have very little access to runtime processing. Out of the 12 thousand lines of code that I was able to find - A26.ISS.EMPLOYMENT is my primary culprit. It will just be too easy for all this to result from the code disappearing! LOL I'm throwing in the towel for tonight - tomorrow morning I start looking for disappeared code. Thanks! From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 03/05/2013 09:33 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org It might be a non-runnable command. Have you tried to actually RUN this to see if it complains that the code is missing? -Original Message- From: Greg Coelho coe...@american.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 5, 2013 6:19 pm Subject: Re: [U2] How do I find the code? Can't seem to find it in either WBP.O or WBP.OBS (I do have a VOC listing for WBP.OBS). From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 03/05/2013 09:06 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org Then Greg I suggest someone has stripped the source, and left you with only the object. You can do ED WBP.O A26.ISS.EMPLOYMENT to verify that it exists, but DO NOT LIST IT it will screw up your terminal emulator software most likely if you display the object code ED only gives you Top, then you can do EX right away -Original Message- From: Greg Coelho coe...@american.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 5, 2013 5:52 pm Subject: Re: [U2] How do I find the code? Unfortunately that was one of the first things I tried... :AE WBP A26.ISS.EMPLOYMENT Top of New A26.ISS.EMPLOYMENT in WBP. *--: P Top. Top of new record. It looks like A26.ISS.EMPLOYMENT doesn't live in WBP. Greg From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org, Date: 03/05/2013 07:51 PM Subject:Re: [U2] How do I find the code? Sent by:u2-users-boun...@listserver.u2ug.org You have a file called WBP so ED WBP A26.ISS.EMPLOYMENT -Original Message- From: Greg Coelho coe...@american.edu To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 5, 2013 4:50 pm Subject: Re: [U2] How do I find the code? All, I am not versed in (PQ) PROC. Can anybody tell where I have to go to find the code for A26.ISS.EMPLOYMENT? :AE VOC A26.ISS.EMPLOYMENT 3 lines long. : P 0001: PQ 0002: HRUN WBP A26.ISS.EMPLOYMENT 0003: P Bottom at line 3. As Always, THANKS! Greg ___ 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 ___ 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] Searching for 'Bad' Dates
All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE .. ./... (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Searching for 'Bad' Dates
Bill, This is only returning those records that do not have a value in MPAR.STATUS.DATE. Unfortunately I looking for records where an external date has been written instead of the internal date. Greg From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Date: 01/29/2013 06:01 PM Subject:Re: [U2] Searching for 'Bad' Dates Sent by:u2-users-boun...@listserver.u2ug.org Greg: Can you do something like: :select {FileName} WITH EVAL OCONV(MPAR.STATUS.DATE, 'D') = This works fine on UniData in PICK mode, where an invalid conversion returns a null (an empty string). HTH, Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE .. ./... (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ 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] Searching for 'Bad' Dates
Aah, I see. I'll need to check our UDT.OPTIONS. I think that I've managed to get this one worked out by creating a DICT entry without formating. This gave me the list that I need. In that we are migrating more and more data to SQL Server which really chokes on a bad date I'll need to get better at flushing these out. Thanks, Greg From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Date: 01/29/2013 06:17 PM Subject:Re: [U2] Searching for 'Bad' Dates Sent by:u2-users-boun...@listserver.u2ug.org Greg: That was the point. What happens is an externally formatted date isn't OCONV'd, if the dbms is configured to return an empty string for a bad conversion. I've got this set up on our systems like this. So, when I run the following code: 2 Dev (0)- BPTEST CRT 'OConverted Date--: ' : OCONV('01/29/13', 'D') ; END Compiling Unibasic: SAVEDLISTS\BpTest_547690521 in mode 'p'. compilation finished OConverted Date--: ...I get what you're looking for, an empty string for dates filed in external format. In UniData I need UDT.OPTIONS 56 ON. Bill - Original Message - *From:* coe...@american.edu *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 1/29/2013 3:09 PM *Subject:* Re: [U2] Searching for 'Bad' Dates Bill, This is only returning those records that do not have a value in MPAR.STATUS.DATE. Unfortunately I looking for records where an external date has been written instead of the internal date. Greg From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Date: 01/29/2013 06:01 PM Subject:Re: [U2] Searching for 'Bad' Dates Sent by:u2-users-boun...@listserver.u2ug.org Greg: Can you do something like: :select {FileName} WITH EVAL OCONV(MPAR.STATUS.DATE, 'D') = This works fine on UniData in PICK mode, where an invalid conversion returns a null (an empty string). HTH, Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE .. ./... (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ 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] ASCII ^010^013 Removal (LF CR)
Thanks all! I was trying to remove both CR and LF with a CONVERT and it did not appear to be working... but when remove one item (CR or LF) at a time it does indeed work. Tony and Will - Thanks! Greg From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Date: 04/25/2012 08:07 PM Subject:Re: [U2] ASCII ^010^013 Removal (LF CR) Sent by:u2-users-boun...@listserver.u2ug.org I don't recall about which platforms this applies, but CONVERT is used to change a single character. CHANGE or SWAP (depending on platform) changes multiple chars: CONVERT SINGLE1 TO SINGLE2 IN VAR VAR = CHANGE(VAR,MULTI1,MULTI2) VAR = SWAP(VAR,MULTI1,MULTI2) From: Wjhonson Doesn't CONVERT CHAR(10):CHAR(13) TO IN X.ID work? From: Greg Coelho Any suggestions how I can use CONVERT to strip ASCII control characters EC 010 and 013 (LFCR) from a variable? CONVERT '?' TO '' IN X.ID ___ 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] ASCII ^010^013 Removal (LF CR)
Bob, Good idea! Currently I'm wrestling with just 2 control characters (010 and 013), but as you point out there are others that can cause trouble as well. I should create an array of Trouble Makers and just loop through them! Thanks again, Greg From: Bob Witney b...@explore.co.uk To: U2 Users List u2-users@listserver.u2ug.org Date: 04/26/2012 09:19 AM Subject:Re: [U2] ASCII ^010^013 Removal (LF CR) Sent by:u2-users-boun...@listserver.u2ug.org I use this : Bit of a sledgehammer but it works and it's quick too FOR CHARACTER = 127 TO 249 CONVERT CHAR(CHARACTER) TO '' IN THIS.MESSAGE NEXT CHARACTER Gets rid of all sorts of nasty webby characters :-) Bob -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: 26 April 2012 14:16 To: U2 Users List Subject: Re: [U2] ASCII ^010^013 Removal (LF CR) Thanks all! I was trying to remove both CR and LF with a CONVERT and it did not appear to be working... but when remove one item (CR or LF) at a time it does indeed work. Tony and Will - Thanks! Greg From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Date: 04/25/2012 08:07 PM Subject:Re: [U2] ASCII ^010^013 Removal (LF CR) Sent by:u2-users-boun...@listserver.u2ug.org I don't recall about which platforms this applies, but CONVERT is used to change a single character. CHANGE or SWAP (depending on platform) changes multiple chars: CONVERT SINGLE1 TO SINGLE2 IN VAR VAR = CHANGE(VAR,MULTI1,MULTI2) VAR = SWAP(VAR,MULTI1,MULTI2) From: Wjhonson Doesn't CONVERT CHAR(10):CHAR(13) TO IN X.ID work? From: Greg Coelho Any suggestions how I can use CONVERT to strip ASCII control characters EC 010 and 013 (LFCR) from a variable? CONVERT '?' TO '' IN X.ID ___ 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 __ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.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 by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.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] ASCII ^010^013 Removal (LF CR)
Thanks Scott for the insight... From: Scott Howder howd...@cedarville.edu To: U2 Users List u2-users@listserver.u2ug.org Date: 04/26/2012 10:16 AM Subject:Re: [U2] ASCII ^010^013 Removal (LF CR) Sent by:u2-users-boun...@listserver.u2ug.org Sorry...I was a bit hasty in sending my previous response. In the case where ONLY the ^010 and ^013 characters are to be removed I'd use CONVERT as suggested. The ICONV function would remove the ^010 and ^013 characters out of the string but it may remove a bunch of other characters from the string which may need to be preserved.sonever mind. Scott On 4/26/2012 at 9:49 AM, in message 4f991a280208006cc...@poplar.cedarville.edu, Scott Howder howd...@cedarville.edu wrote: I'm jumping in so this option may have been discussed already but I think the following would also do the trick: X = ICONV(X,'MCB') Scott ___ 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] ASCII ^010^013 Removal (LF CR)
Hey Guys, Any suggestions how I can use CONVERT to strip ASCII control characters DEC 010 and 013 (LFCR) from a variable? CONVERT '?' TO '' IN X.ID Thanks! Greg ___ 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
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] Unwanted Duplicated
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
Re: [U2] Using 'MATCH'
Hey Guys, I am concatenating an alpha code into a string providing that the code does not already exist (in the string). If my existing string = X.STRING and my code = X.CODE should the following work? IF X.STRING MATCH X.CODE THEN END ELSE X.STRING = X.STRING:',':X.CODE END Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using 'MATCH'
Guys, Thanks for the great suggestions. I believe that I did get MATCH confused with COUNT thinking that it could navigate a delimiter... In this situation I'm thinking that just using COUNT would be the best solution. I do appreciate the diversity of the solutions presented. Thanks! Greg From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Date: 10/31/2011 01:55 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun...@listserver.u2ug.org You might also be able to use COUNT. IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE Not knowing what your potential codes are, though, they may or may not fit your needs. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Braid Sent: Monday, October 31, 2011 10:44 AM To: U2 Users List Subject: Re: [U2] Using 'MATCH' Hi Greg, I would convert your string to a VM array, use the LOCATE syntax to add it if relevant and then convert back to a string. Martin (I am not going to worry why you aren't just using an array) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: 31 October 2011 17:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using 'MATCH' Hey Guys, I am concatenating an alpha code into a string providing that the code does not already exist (in the string). If my existing string = X.STRING and my code = X.CODE should the following work? IF X.STRING MATCH X.CODE THEN END ELSE X.STRING = X.STRING:',':X.CODE END Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using 'MATCH'
George, Thanks! This is a good point. I will retain the ',' delimiter when I do my COUNT. Greg From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Date: 10/31/2011 04:45 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun...@listserver.u2ug.org Be careful using a straight count, Because HELL will be found in in the word HELLO for instance, and would not be added Make sure you surround your search criteria with the delimiters being used, as noted in one of the replies. So, ,HELL, would not be found if ,HELLO, were in the list. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Monday, October 31, 2011 4:15 PM To: U2 Users List Subject: Re: [U2] Using 'MATCH' Guys, Thanks for the great suggestions. I believe that I did get MATCH confused with COUNT thinking that it could navigate a delimiter... In this situation I'm thinking that just using COUNT would be the best solution. I do appreciate the diversity of the solutions presented. Thanks! Greg From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Date: 10/31/2011 01:55 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun...@listserver.u2ug.org You might also be able to use COUNT. IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE Not knowing what your potential codes are, though, they may or may not fit your needs. ___ 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] Using 'MATCH'
George, Thanks for pointing this out. I'm running a test now... if it there are any issues I'll switch to MATCH and @VM. Greg From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Date: 10/31/2011 05:10 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun...@listserver.u2ug.org Is it flavor dependent? I tried it under Information flavor : 0001: Y=HELLO 0002: Y1,-1=THERE 0003: IF Y MATCH HELLO THEN PRINT YES ELSE PRINT NO 0004: STOP 0005: END I got NO, unless I set it up incorrectly - could be...I never used for this purpose before. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 31, 2011 4:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Using 'MATCH' Match *can* navigate a delimiter. It navigates the multi-value delimiter @VM That's the only one it can navigate, but why not use it if it's there ? To me using Match makes the code clear. ___ 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] Using 'MATCH'
Guys, I've run a test against 10,000 records and COUNT is performing flawlessly. When I get a minute I'll switch it to MATCH and see how it runs. I agree with the comment that MATCH would be clearer code and would easier to follow... Thanks again, Greg From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Date: 10/31/2011 05:20 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun...@listserver.u2ug.org Your syntax is backward George its not IF Y MATCH HELLO its IF HELLO MATCH Y -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Oct 31, 2011 2:10 pm Subject: Re: [U2] Using 'MATCH' Is it flavor dependent? I tried it under Information flavor : 0001: Y=HELLO 002: Y1,-1=THERE 003: IF Y MATCH HELLO THEN PRINT YES ELSE PRINT NO 004: STOP 005: END I got NO, unless I set it up incorrectly - could be...I never used for this urpose before. George -Original Message- rom: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Monday, October 31, 2011 4:47 PM o: u2-users@listserver.u2ug.org ubject: Re: [U2] Using 'MATCH' atch *can* navigate a delimiter. t navigates the multi-value delimiter @VM hat's the only one it can navigate, but why not use it if it's there ? o me using Match makes the code clear. __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 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
Re: [U2] Using 'MATCH'
Mechi, I am creating an extract for export to a third party vendor. This requires that I convert a multi-valued field to a single (comma delimited) value. The thought was instead of converting from comma to @VM and then back to comma that we might save the processor a bit of work by keeping is simple and just using COUNT against the comma delimited value. Initially I thought that I might go upstream and use LOCATE while we were still dealing with a multi-valued field, there are subroutines in place that are considering other criteria... Thanks, Greg From: Mecki Foerthmann mec...@gmx.net To: u2-users@listserver.u2ug.org Date: 10/31/2011 05:54 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun...@listserver.u2ug.org I don't get the problem. Why would you want to do this in the first place? Why not just convert the commas to @VM, use LOCATE and convert the @VM back to commas? BTW if the first string is HELL or it is the first entry then counting ,HELL, won't find it either. KISS! Mecki On 31/10/2011 20:41, George Gallen wrote: Be careful using a straight count, Because HELL will be found in in the word HELLO for instance, and would not be added Make sure you surround your search criteria with the delimiters being used, as noted in one of the replies. So, ,HELL, would not be found if ,HELLO, were in the list. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Monday, October 31, 2011 4:15 PM To: U2 Users List Subject: Re: [U2] Using 'MATCH' Guys, Thanks for the great suggestions. I believe that I did get MATCH confused with COUNT thinking that it could navigate a delimiter... In this situation I'm thinking that just using COUNT would be the best solution. I do appreciate the diversity of the solutions presented. Thanks! Greg From: Woodward, Bobbob_woodw...@k2sports.com To: U2 Users Listu2-users@listserver.u2ug.org Date: 10/31/2011 01:55 PM Subject:Re: [U2] Using 'MATCH' Sent by:u2-users-boun...@listserver.u2ug.org You might also be able to use COUNT. IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE Not knowing what your potential codes are, though, they may or may not fit your needs. ___ 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] Modifying DICT - 101
Hey Guys, Starting with this original file :ELE VOC A26.CHECKS.RECON 3 lines long. : P 0001: F 0002: DATA/DATA_X/A26.CHECKS.RECON 0003: DATA/DATA_X/D_A26.CHECKS.RECON Bottom at line 3. I've was able to get it to work with our proprietary system by: 1. Creating replacement file within the proprietary system: A26.CHECK.RECON 2. Copied the dictionary from A26.CHECKS.RECON to A26.CHECK.RECON 0001: F 0002: A26.CHECK.RECON 0003: DATA/DATA_X/D_A26.CHECKS.RECON Bottom at line 3. 3. Copied the data from A26.CHECKS.RECON to A26.CHECK.RECON and modified the date field (changing the value from external to internal). With the DICT pointing back to the original A26.CHECKS.RECON the file is accessible to the system which in the beginning could not see A26.CHECK.RECON. What do I need to do to again point to my original DICT? 0001: F 0002: DATA/DATA_X/A26.CHECK.RECON 0003: DATA/DATA_X/D_A26.CHECK.RECON Bottom at line 3. Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Convert to Numeric
Kevin, Sorry - of course line 212 - it was getting late... Line 212 and the code leading up to it is as follows: X.B.ORIG.APPROVED.AMT = OCONV(V.B.ORIG.APPROVED.AMT, MD2) X.B.ORIG.APPROVED.AMT = FMT(X.B.ORIG.APPROVED.AMT,15R) X.MDEBITS.YTD = SUM(VL.B.APPR.MDEBITS) X.MDEBITS.YTD = OCONV(X.MDEBITS.YTD,MD2) X.MDEBITS.YTD = FMT(X.MDEBITS.YTD,15R) X.MCREDITS.YTD = SUM(VL.B.APPR.MCREDITS) X.MCREDITS.YTD = OCONV(X.MCREDITS.YTD, MD2) X.MCREDITS.YTD = FMT(X.MCREDITS.YTD, 15R) Line 212 X.CRNT.BUDGT.AMT = X.B.ORIG.APPROVED.AMT + X.MDEBITS.YTD - X.MCREDITS.YTD When I pull the data, from the database, straight into Excel V.B.ORIG.APPROVED.AMT does not appear numeric (LEFT justified etc.) though it is defined as numeric in the DICT. Thanks, Greg From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/30/2011 09:16 PM Subject:Re: [U2] Convert to Numeric Sent by:u2-users-boun...@listserver.u2ug.org What does A26S.GET.GLS.INFO line 212 say? Yes, you can force values numeric but at what expense? ___ 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] Convert to Numeric
Guys, I'm getting some wildly unexpected values returned... I have attempted formatting (FMT) and converting (OCONV) and have looked at the data which appears to be correct(no O etc...). The DICT has them set at MD2, and 15R. I notice that I am also getting the following message: In CF.OBJ/_A26S.GET.GLS.INFO at line 212 Non-numeric found when numeric required. Any suggestions how I can force these values numeric? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Intergration of an existing file?
Hi guys, Quick question: I've got a custom Unidata file that my system does not recognize. The file is a HASH Type 0 - which should be compatible with the system... Any suggestions what I might try to get the system to recognize this file or to do a CREATE.FILE and COPY and end up with a recognizable file? As always - Thanks! Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Intergration of an existing file?
Gordon, Thanks for getting back... I am using a proprietary version of Unidata (Envision). The VOC can see the file: :ELE VOC A26.CHECKS.RECON 3 lines long. : P 0001: F 0002: DATA/DATA_X/A26.CHECKS.RECON 0003: DATA/DATA_X/D_A26.CHECKS.RECON Bottom at line 3. : But the 'System' cannot. I've tried to replicate the file by building one within the system which the system does recognize. :ELE VOC A26.CHECK.RECON 3 lines long. : P 0001: F 0002: A26.CHECK.RECON 0003: D_A26.CHECK.RECON Bottom at line 3. : But when I attempt to copy data to this file I cannot access the data through the system. I can AE and pull data no problem, but I cannot use the Envision Line Editor (ELE) to access the data. I realize that I'll need to get this file back into position (DATA/DATA_X) but am uncertain how to do this and not wind up with another file that I can't read. I created this file using the file creation tool provided and am unable to COPY FROM DICT A26.CHECKS.RECON TO DICT A26.CHECK.RECON ALL. I can to a straight COPY FROM A26.CHECKS.RECON TO A26.CHECK.RECON ALL - but this results in an unusable file. Any suggestion would be greatly appreciated. Greg From: Glorfield, Gordon gglorfi...@vertisinc.com To: 'U2 Users List' u2-users@listserver.u2ug.org Date: 06/21/2011 03:47 PM Subject:Re: [U2] Intergration of an existing file? Sent by:u2-users-boun...@listserver.u2ug.org What do you mean your system does not recognize the file? Do you mean UniData doesn't recognize it? Is there a VOC item pointing to the file? -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Tuesday, June 21, 2011 3:44 PM To: U2 Users List Subject: Re: [U2] Intergration of an existing file? Hi guys, Quick question: I've got a custom Unidata file that my system does not recognize. The file is a HASH Type 0 - which should be compatible with the system... Any suggestions what I might try to get the system to recognize this file or to do a CREATE.FILE and COPY and end up with a recognizable file? As always - Thanks! Greg ___ 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] Intergration of an existing file?
Bob, Yep, you are correct - this is all about Envision. As Jeff Butera mentioned - there is no simple way to do this. I've gotten a couple of suggestions - I'll give them a shot. Thanks, Greg From: Bob Woodward bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/21/2011 04:43 PM Subject:Re: [U2] Intergration of an existing file? Sent by:u2-users-boun...@listserver.u2ug.org So your definition of unusable is incorrect. You just can't use your ELE editor on it. The word proprietary kind of comes up as a possible reason for limitations. If you can edit the data using AE, it has nothing to do with Unidata's ability to access the file. Talk to the Envision support and see what they say. I'd bet that there is a reason you can't edit this file, just from the name of it. But that's just a guess, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Tuesday, June 21, 2011 1:17 PM To: U2 Users List Subject: Re: [U2] Intergration of an existing file? Gordon, Thanks for getting back... I am using a proprietary version of Unidata (Envision). The VOC can see the file: :ELE VOC A26.CHECKS.RECON 3 lines long. : P 0001: F 0002: DATA/DATA_X/A26.CHECKS.RECON 0003: DATA/DATA_X/D_A26.CHECKS.RECON Bottom at line 3. : But the 'System' cannot. I've tried to replicate the file by building one within the system which the system does recognize. :ELE VOC A26.CHECK.RECON 3 lines long. : P 0001: F 0002: A26.CHECK.RECON 0003: D_A26.CHECK.RECON Bottom at line 3. : But when I attempt to copy data to this file I cannot access the data through the system. I can AE and pull data no problem, but I cannot use the Envision Line Editor (ELE) to access the data. I realize that I'll need to get this file back into position (DATA/DATA_X) but am uncertain how to do this and not wind up with another file that I can't read. I created this file using the file creation tool provided and am unable to COPY FROM DICT A26.CHECKS.RECON TO DICT A26.CHECK.RECON ALL. I can to a straight COPY FROM A26.CHECKS.RECON TO A26.CHECK.RECON ALL - but this results in an unusable file. Any suggestion would be greatly appreciated. Greg From: Glorfield, Gordon gglorfi...@vertisinc.com To: 'U2 Users List' u2-users@listserver.u2ug.org Date: 06/21/2011 03:47 PM Subject:Re: [U2] Intergration of an existing file? Sent by:u2-users-boun...@listserver.u2ug.org What do you mean your system does not recognize the file? Do you mean UniData doesn't recognize it? Is there a VOC item pointing to the file? -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Tuesday, June 21, 2011 3:44 PM To: U2 Users List Subject: Re: [U2] Intergration of an existing file? Hi guys, Quick question: I've got a custom Unidata file that my system does not recognize. The file is a HASH Type 0 - which should be compatible with the system... Any suggestions what I might try to get the system to recognize this file or to do a CREATE.FILE and COPY and end up with a recognizable file? As always - Thanks! Greg ___ 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] Selecting a List
Hi All, Again, I need a little help. The following PROCEDURE LINE works just fine. In this case I'm just inserting the variable V.CALENDAR.YEAR to complete my file suite and I am going after 2 alphanumeric records ('P2021422' 'P2083158'). PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = 'P2021422' 'P2083158' The problem arises when I attempt to select from a LIST (below) PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = : VL.JS.LIST.VAR1 Of course the system does not like the Value Marker so I need to get rid of it... VL.JS.LIST.VAR1 = ':CONVERT (@VM,' ',VL.JS.LIST.VAR1):' The hope here is to replace @VM with ' ' and then place the ' at each end... but CONVERT will only switch one for one - one @VM for a single single quote (') which results in a quote mismatch. Any suggestions? Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a List
Guys, As always a number of great options! I was able to throw in SWAP with the least effort and it's working great! Thanks again, Greg From: Bob Woodward bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/08/2011 12:06 PM Subject:Re: [U2] Selecting a List Sent by:u2-users-boun...@listserver.u2ug.org I'm assuming this is in a basic program and you want to use CHANGE instead of CONVERT. In Unidata, anyway. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, June 08, 2011 9:00 AM To: U2 Users List Subject: Re: [U2] Selecting a List On 08/06/11 16:47, Greg Coelho wrote: Hi All, Again, I need a little help. The following PROCEDURE LINE works just fine. In this case I'm just inserting the variable V.CALENDAR.YEAR to complete my file suite and I am going after 2 alphanumeric records ('P2021422' 'P2083158'). PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = 'P2021422' 'P2083158' The problem arises when I attempt to select from a LIST (below) PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = : VL.JS.LIST.VAR1 Of course the system does not like the Value Marker so I need to get rid of it... VL.JS.LIST.VAR1 = ':CONVERT (@VM,' ',VL.JS.LIST.VAR1):' The hope here is to replace @VM with ' ' and then place the ' at each end... but CONVERT will only switch one for one - one @VM for a single single quote (') which results in a quote mismatch. Any suggestions? Yes. I think you need the ?REPLACE? function. There is a function that replaces one string with another. It might be EREPLACE instead. Anyways. Read the BASIC manual - it is there. Cheers, Wol ___ 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] Selecting a List
Jeff, Thanks for the info on EREPLACE! It looks like this would allow me to replace a specified number of the substrings - something I've been wrestling with on another assignment... Thanks again, Greg From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/08/2011 12:11 PM Subject:Re: [U2] Selecting a List Sent by:u2-users-boun...@listserver.u2ug.org EREPLACE function? SYNTAX EREPLACE (expression, substring, replacement [,occurrence [,begin]] ) DESCRIPTION Use the EREPLACE function to replace substring in expression with another substring. If you do not specify occurrence, each occurrence of substring is replaced. occurrence specifies the number of occurrences of substring to replace. To replace all occurrences, specify occurrence as a number less than 1. Glorfield, Gordon wrote: What about SWAP? SWAP str.expr1 WITH str.expr2 IN var The UniBasic SWAP command replaces all occurrences of one substring with a second substring. The search string does not have to be the same length as the replacement string. SWAP supports mulitbyte languages. -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Selecting a List Hi All, Again, I need a little help. The following PROCEDURE LINE works just fine. In this case I'm just inserting the variable V.CALENDAR.YEAR to complete my file suite and I am going after 2 alphanumeric records ('P2021422' 'P2083158'). PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = 'P2021422' 'P2083158' The problem arises when I attempt to select from a LIST (below) PROCEDURE LINE SELECT GLA.:V.CALENDAR.YEAR: WITH GLA.REF.NO = : VL.JS.LIST.VAR1 Of course the system does not like the Value Marker so I need to get rid of it... VL.JS.LIST.VAR1 = ':CONVERT (@VM,' ',VL.JS.LIST.VAR1):' The hope here is to replace @VM with ' ' and then place the ' at each end... but CONVERT will only switch one for one - one @VM for a single single quote (') which results in a quote mismatch. Any suggestions? Greg ___ 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot 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] Uniquery
U2 Users! I am trying to pass in arguments into a UniQuery form using JSPARAMS. This works fine when I working with a SELECT LIST: V.JS.VAR1 = Smith PROCEDURE LINE SELECT PERSON WITH LAST.NAME EQ :V.JS.VAR1 But when I try to pass this into a literal statement such as a HEADER - things go haywire (process goes into a loop) X.LIST.STMT:= \HEADER AR Invoices with customer last name :V.JS.VAR1: and customer first name John.\ Does anyone have any clues as to what I should be looking for - UDT.OPTIONS, HEADING settings? Also, when I pass in a V.JS.DATE.VAR to the HEADER I get the internal date regardless how I try to format it. Any insight would be greatly appreciated. Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users