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

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

Re: [U2] Selecting a List

] 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

Re: [U2] Selecting a List

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

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

Re: [U2] Intergration of an existing file?

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

Re: [U2] Intergration of an existing file?

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

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

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 =

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

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

Re: [U2] Using 'MATCH'

...@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

Re: [U2] Using 'MATCH'

, 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

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'

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

Re: [U2] Using 'MATCH'

...@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

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

Re: [U2] Unwanted Duplicated

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

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

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

Re: [U2] ASCII ^010^013 Removal (LF CR)

: 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

Re: [U2] ASCII ^010^013 Removal (LF CR)

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

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

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

Re: [U2] Searching for 'Bad' Dates

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

Re: [U2] Searching for 'Bad' Dates

-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

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

Re: [U2] How do I find the code?

, 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

Re: [U2] How do I find the code?

: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

Re: [U2] How do I find the code?

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

Re: [U2] How do I find the code?

, 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

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

Re: [U2] How to copy only @ID from one file to anothers

, 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