Re: [U2] uniobjects.dll on Notes 8.3
Shot in the dark... Did you install the Uniobjects package or just copy the dll... makes a difference. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Tuesday, September 18, 2012 2:24 PM To: U2 Users List Subject: Re: [U2] uniobjects.dll on Notes 8.3 The error message is Cannot create automation object. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] A better LISTU
Rocket should supply a system function, API etc to give DETAILED log-in information... We'll take it from there same with detailed locking, detailed port status blah blah. Bit off-topic... but frustration vented ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, September 05, 2012 11:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] A better LISTU By the way, the Universe (on Windows) LISTU gives under the Login Time column, the month, day, and military time. For some reason they didn't pad out the *day* if it's short (1, 2, 3, 4) with an extra 0, so if you have processes which logged in on the 27th, and then some on the 1st, then what happens is the time of day moves one character further over. Annoying. That's why I have the TIMEDATE and then I parse it on blanks to figure out the date versus the time. By the way, this will break over the end of a year as I'm only considering the current year. Maybe someone has a patch code for that situation too. -Original Message- From: Baakkonen, Rodney A (Rod) 46K (Rod) 46K rodney.baakko...@cigna.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Sep 5, 2012 7:44 am Subject: Re: [U2] A better LISTU It is taking some work to make it function in Unidata. But thanks for the framework. -Rod -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, September 04, 2012 1:06 PM To: u2-users@listserver.u2ug.org Subject: [U2] A better LISTU WLISTU pulls up the list sorted by date and time, and allows you to resort it by PID. It could be easily modified to allow sorting on any of the columns FFT.BP 'WLISTU' BASIC 71 lines Level: 3 0001 * 0002 * Writen Aug 2012 by Will Johnson 0003 * This routine sorts the LISTU table by date and then by time 0004 * Builds a multi-sub-valued table, so the times get sorted right 0005 * Then swaps the SVMs for VMs so it becomes a regular table 0006 * Then it also allows you to resort it by PID 0007 * 0008 EQUATE FALSE TO 0, TRUE TO 1 0009 TODAY = DATE() ; THIS.YEAR = OCONV(TODAY,'DY') 0010 SWITCH = DATE ; EXIT.PROGRAM = FALSE 0011 LOOP 0012 EXECUTE LISTU, OUT RESULTS 0013 SELECTV RESULTS TO L.RESULTS 0014 DONE = FALSE ; CNT = 0 ; HEADERS = '' ; TABLE = '' 0015 LOOP 0016 READNEXT LINE FROM L.RESULTS ELSE DONE = TRUE 0017 UNTIL DONE DO 0018 CNT += 1 0019 T.PID = LINE[16,5] 0020 T.TIMEDATE = LINE[62,13] 0021 T.DATE = OCONV(T.TIMEDATE,'G0 2'):' ':THIS.YEAR 0022 T.TIME = OCONV(T.TIMEDATE,'G2 1') 0023 IF SWITCH = DATE THEN GOSUB BY.DATE.AND.TIME 0024 IF SWITCH = PID THEN GOSUB BY.PID 0025 REPEAT 0026 TABLE1 = HEADERS:@VM:TABLE1 0027 TABLE = CONVERT(@SVM,@VM,TABLE) 0028 * 0029 S.TABLE = DCOUNT(TABLE1,@VM) 0030 FOR I.TABLE = 1 TO S.TABLE 0031 IF TABLE1,I.TABLE # '' THEN 0032PRINT I.TABLE'R%2':' ':TABLE1,I.TABLE 0033 END 0034 NEXT I.TABLE 0035 DISPLAY SORT BY (D)ATE, (P)ID, OR (Q)UIT : ; INPUT ANYTHING 0036 BEGIN CASE 0037 CASE ANYTHING = 'Q' ; EXIT.PROGRAM = TRUE 0038 CASE ANYTHING = 'P' ; SWITCH = 'PID' 0039 CASE ANYTHING = 'D' ; SWITCH = 'DATE' 0040 END CASE 0041 UNTIL EXIT.PROGRAM DO REPEAT 0042 STOP 0043 * 0044 BY.DATE.AND.TIME: 0045 I.DATE = ICONV(T.DATE,'D') ; I.TIME = ICONV(T.TIME,'MT') 0046 IF STATUS() THEN 0047 HEADERS1,-1 = LINE 0048 END ELSE 0049 LOCATE I.DATE IN TABLE2,1 BY 'AR' SETTING W.DATE ELSE 0050 TABLE = INSERT(TABLE,1,W.DATE;'') 0051 TABLE = INSERT(TABLE,2,W.DATE;I.DATE) 0052 TABLE = INSERT(TABLE,3,W.DATE;'') 0053 END 0054 LOCATE I.TIME IN TABLE3,W.DATE,1 BY 'AR' SETTING W.TIME ELSE 0055 NULL 0056 END 0057 TABLE = INSERT(TABLE,1,W.DATE,W.TIME;LINE) 0058 TABLE = INSERT(TABLE,3,W.DATE,W.TIME;I.TIME) 0059 END 0060 RETURN 0061 * 0062 BY.PID: 0063 IF NUM(T.PID) THEN 0064 T.PID = TRIM(T.PID) + 0 0065 LOCATE T.PID IN TABLE2,1 BY 'AR' SETTING W.PID ELSE NULL 0066 TABLE = INSERT(TABLE,1,W.PID;LINE) 0067 TABLE = INSERT(TABLE,2,W.PID;T.PID) 0068 END ELSE HEADERS1,-1 = LINE 0069 RETURN 0070 * 0071END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- CONFIDENTIALITY NOTICE: If you
Re: [U2] Scrub HangUp Fixed
AMEN... Rocket has been the most responsive support I've experienced. *SOME* of the folks are a little slow getting it initially, but once they understand the problem... it's addressed. They have been very personable, friendly and professional in my experience. However, it's a tad difficult to solve a problem that's not submitted. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, August 30, 2012 4:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Scrub HangUp Fixed I can't even read this thread anymore. It just makes me go ballistic this attitude. -Original Message- From: Wally Terhune wterh...@rocketsoftware.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Aug 30, 2012 9:53 am Subject: Re: [U2] Scrub HangUp Fixed Rather than raising a stink, it would be best to just open a support case... Without personal knowledge of UV, I haven't been paying much attention to this thread. Wally Terhune Technical Support Engineer Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA t: +1 720 475 8055 **e: wterh...@rocketsoftware.com **w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, August 30, 2012 10:13 AM To: 'U2 Users List' Subject: Re: [U2] Scrub HangUp Fixed Ahahahahahahahahaha!! No!! Stop!! You're killing me!! But seriously... For the good of humanity, it's the duty of every person on the list to raise stinks to Rocket on stupid system behavior like this It's probably not that hard to fix and will avoid the NEXT person from having to live the trauma. ___ 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] [ud] Sub-second delay?
I used to walk into client site with 6 or more large tape reels -- to load new programs, data, backup results etc Now I walk in/out with my phone and a USB cable, or an $18 USB drive... entire systems onboard :-) (I don't miss the 150/300bps modems) (( yes I am that old )) ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Thursday, August 30, 2012 3:00 PM To: 'U2 Users List' Subject: Re: [U2] [ud] Sub-second delay? I was just talking with a client this morning that was lamenting the fact that our proposed SQL solution would require 4 VM machines to run a comparable system to his current one on UniData that doesn't have as much processing power as my iphone. (It may also not have as much memory, and is possible that it has less disk space than the phone has RAM...) Colin -Original Message- From: Rutherford, Marc Sent: August 30, 2012 10:19 AM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? Ah yes, Microdata - my first Pick machine. We were running a 32 user ERP on 64K of main memory and a 30MB drive. Marc Rutherford ___ 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] [ud] Sub-second delay?
Thank GOD someone is older ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, August 30, 2012 3:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? From: David L. Wasylenko (I don't miss the 150/300bps modems) (( yes I am that old )) And old enough to forget that it was 110baud. haha ___ 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] Scrub Hangs Up
Port.status ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 3:20 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When it hangs... I am unable to get it to terminate via Ctrl Break Break: Option (A,C,L,Q,?) = None of the break options work... --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, August 28, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] Scrub Hangs Up When I do a LOGTO HS.ADMIN HS.ADMIN 5. Run HS.SCRUB on a File/Table.. [F]ix Most of the files here work ok. This one (important) data file INVOICE... it starts an... Analyzing: *and then just sits there. I looked at the dictionary and purged a bunch of extraneous } characters from several the NAME fields. I expect to resize the file but... it is not like the file is badly oversized. This is on UniVerse v10.1 running on HP-Ux Itanium. Suggestions would be appreciated. --Bill ___ 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] [ud] Sub-second delay?
NAP 500 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, August 27, 2012 10:46 AM To: U2 Users List Subject: [U2] [ud] Sub-second delay? Is there anything in Unidata (7.1, in particular) that can do a sub-second delay, like maybe a half second? ___ 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] Variable Interpolation
Or... 0001 VERB=TRY ;* Or whatever you called this program 0002 SENT=@SENTENCE 0003 PTR=INDEX(SENT,VERB,1) ; LLEN=LEN(SENT)-PTR-LEN(VERB) 0004 SENT=SENT[PTR+LEN(VERB)+1,LLEN] 0005 * 0006 F.FILE=FIELD(SENT, ,1) ; LLEN =LLEN-LEN(F.FILE)-1 0007 SENT=SENT[LEN(F.FILE)+2, LLEN] 0008 * you now have a clean sentence... 0009 CRT DQUOTE(F.FILE) 0010 CRT DQUOTE(SENT) 0011 * 0012END ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, August 24, 2012 5:55 PM To: u2-users@listserver.u2ug.org; donr_w...@yahoo.com Subject: Re: [U2] Variable Interpolation Oops there's a bug. Right after the line that starts OFFSET += 1 should be yet another OFFSET += 1 so the corrected version should read IF VERB = 'RUN' OR VERB = 'RAID' THEN OFFSET += 1 ; N.FILE = FIELD(SENT,' ',OFFSET) OFFSET += 1 END ELSE OFFSET += 2 ; N.FILE = 'BP' -Original Message- From: Wjhonson wjhon...@aol.com To: donr_work donr_w...@yahoo.com; u2-users u2-users@listserver.u2ug.org Sent: Fri, Aug 24, 2012 3:40 pm Subject: Re: [U2] Variable Interpolation FFT.BP 'TRY' BASIC 27 lines Level: 9 * * Run any BASIC code typed at TCL * Writen Aug 2012 by Will Johnson based on a comment by Don Robinson * Released under CC-BY-2.0 license * SENT = @SENTENCE OFFSET = 1 ; VERB = FIELD(SENT,' ',OFFSET) IF VERB = 'RUN' OR VERB = 'RAID' THEN OFFSET += 1 ; N.FILE = FIELD(SENT,' ',OFFSET) END ELSE OFFSET += 2 ; N.FILE = 'BP' OPEN N.FILE TO F.FILE ELSE DISPLAY 'Cannot open file ':N.FILE:'' END OFFSET += 1 ; WHAT = FIELD(SENT,' ',OFFSET) ; C.WHAT = COL2()+1 L.SENT = LEN(SENT) ; WHAT = SENT[C.WHAT,L.SENT] WRITE WHAT:@AM:END ON F.FILE,'TRYCODE' EXECUTE 'BASIC ':N.FILE:' TRYCODE' EXECUTE 'RUN ':N.FILE:' TRYCODE' * END -Original Message- From: Don Robinson donr_w...@yahoo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Aug 24, 2012 12:20 pm Subject: Re: [U2] Variable Interpolation Guys, I may be way off base but I have a program that takes basic code from the command line, compiles and runs it. For example: 01 RUNBASIC CRT SYSTEM(2) ; CRT SYSTEM(3) 79 24 RUNBASIC is the program and CRT SYSTEM(2) ; CRT SYSTEM(3) is the code in this example. 79 and 24 are the answers. The string of = signs are just for looks. This could be EXECUTEd from within a program but why? It is quite handy for testing bits of code at TCL and might be useful in a proc. RUNBASIC will do anything you can do with one line of code using ; to separate statements including FOR ... NEXT and LOOP ... REPEAT. Code is free as long as you don't critisize it. Don Robinson From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Friday, August 24, 2012 1:38 PM Subject: Re: [U2] Variable Interpolation The impression I get from this thread is something like Oh I've just read on the HELP pages that System(2) tells me the width of my CRT screen. Let me ask my process what it has as the value for System(2). Oops I have to write a program just to tell me that that's too much trouble. Why can't it just have a way to *tell* me ? Why -Original Message- From: Martin Phillips martinphill...@ladybridge.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Aug 24, 2012 10:11 am Subject: Re: [U2] Variable Interpolation Hi, I am intrigued by this thread, mostly because I have not understood why I would want it. If I can write CALL @SUB FOO(X,Y);Y=X+1;RETURN( 3, VAL ) as suggested, why don't I just write the code inline in my program. What have I missed? Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ 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
Re: [U2] [ud] Sub-second delay?
SLEEP 1 and NAP xxx will do the same... I've had processes hogging resources... added NAP 1 and it played very nicely with the system afterward. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rutherford, Marc Sent: Monday, August 27, 2012 11:23 AM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? While OT to your question, I miss the true RQM (release quantum) from the OS days. A nice way to make a resource-hungry program more courteous to other users. 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 Kevin King Sent: Monday, August 27, 2012 8:46 AM To: U2 Users List Subject: [U2] [ud] Sub-second delay? Is there anything in Unidata (7.1, in particular) that can do a sub-second delay, like maybe a half second? ___ 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] [ud] Sub-second delay?
Universe only supports an integer for the SLEEP command... Try this in unidata: 001 CRT TIMEDATE() 002 FOR I=1 TO 5 003 SLEEP 0.5 004 NEXT I 005 CRT TIMEDATE() I've no idea if it's supported... but it's worth a shot to test. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, August 27, 2012 11:30 AM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? RQM is still supported by UniData, but it's now merely a synonym for SLEEP. NAP is a UV thing, with millisecond granularity. SLEEP, in both UV and UD, like the *nix sleep command, only counts in whole seconds. Larry Hiscock Western Computer Services RQM was supposed to be merely a command to release quantuum which means to pause until I come back up in the time-slicing round-robin. At some point I wonder if they didn't just replace this with a Sleep 1 but that's not really what it was *supposed* to be. ___ 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] [ud] Sub-second delay?
If you are trying to unload a heavy processs... how about sleeping one second every 100 records or every 1000 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, August 27, 2012 11:51 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? How interesting. RQM isn't even in the online help for Universe 10, but it does compile. -Original Message- From: David L. Wasylenko d...@pickpro.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Aug 27, 2012 9:41 am Subject: Re: [U2] [ud] Sub-second delay? Universe only supports an integer for the SLEEP command... Try this in unidata: 001 CRT TIMEDATE() 002 FOR I=1 TO 5 003 SLEEP 0.5 004 NEXT I 005 CRT TIMEDATE() I've no idea if it's supported... but it's worth a shot to test. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of lar...@wcs-corp.com Sent: Monday, August 27, 2012 11:30 AM To: U2 Users List Subject: Re: [U2] [ud] Sub-second delay? RQM is still supported by UniData, but it's now merely a synonym for SLEEP. NAP is a UV thing, with millisecond granularity. SLEEP, in both UV and UD, like the *nix sleep command, only counts in whole seconds. Larry Hiscock Western Computer Services RQM was supposed to be merely a command to release quantuum which means to pause until I come back up in the time-slicing round-robin. At some point I wonder if they didn't just replace this with a Sleep 1 but that's not really what it was *supposed* to be. ___ 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] [ud] Sub-second delay?
You will get a delay... but you won't reduce work-load. In fact, a tight loop like that will take over and make system performance crawl. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marco Antonio Rojas Castro Sent: Monday, August 27, 2012 12:00 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? H = SYSTEM(12) ;* TIME IN MILISECONDS LOOP H2 = SYSTEM(12) IF H2 - H 500 THEN EXIT ;* 500 MS ELAPSED REPEAT Date: Mon, 27 Aug 2012 10:17:01 -0600 From: ke...@precisonline.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] [ud] Sub-second delay? Ah crap, this client is Unidata 6.1 and NAP is not supported. I'm not seeing it in the 7.1 or 7.2 docs either. Looks to be a UV thing, right? On Mon, Aug 27, 2012 at 9:41 AM, David L. Wasylenko d...@pickpro.com wrote: NAP 500 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, August 27, 2012 10:46 AM To: U2 Users List Subject: [U2] [ud] Sub-second delay? Is there anything in Unidata (7.1, in particular) that can do a sub-second delay, like maybe a half second? ___ 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] Array Types
Speed There is a *long* thread here demonstrating the difference between *DAYS* of processing and seconds, using large records for demonstration. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 27, 2012 10:16 AM To: U2 Users List Subject: [U2] Array Types I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --Bill ___ 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] Array Types
That answer would require a book. Simple read, use a field, discard - prob. no difference or a net loss in performance since a MAT READ must parse all @AM marks during read operations. If you work with multiple fields in a record, the performance gain increases with #users , #records since you do not rehash attribute positions when working with the record. It's already done during the MAT READ operation, maintaining attribute positions for you. The savings while working with large records will be obvious to a single user within a single program. The net savings on a multi-user system over the course of a day can be huge. Again, look back in the prior posts... processes that would take hours to days were reduced to seconds. There are program examples, run-time results, records-per-second figures and technical descriptions. DIM arrays are not for nostalgia or some sentiment throw-back... they are there for real and important reasons. An example in Universe... create a record of 10,000,000 bytes and edit the record. Performance is amazing, after the initial read/setup. Try scrolling through the data using a program and a dynamic array and see what you get! :-) You will get bored waiting for the display to refresh after a few dozen pages. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jbut...@hampshire.edu Sent: Friday, July 27, 2012 10:24 AM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] Array Types I understand the performance trade off between dynamic and dimensioned arrays but I'm curious about quantifying. I know the answer will depend on hardware and load, but in general at what point (length) do dimensioned arrays become better performing than dynamic? 1000? 1? 10? Any examples or benchmarks appreciated. Jeff Butera Sent from my iPhone On Jul 27, 2012, at 11:14 AM, David L. Wasylenko d...@pickpro.com wrote: Speed There is a *long* thread here demonstrating the difference between *DAYS* of processing and seconds, using large records for demonstration. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 27, 2012 10:16 AM To: U2 Users List Subject: [U2] Array Types I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --Bill ___ 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] Running a command in a different account
OPEN BAT.FL TO BAT.FL * BAT= BAT-1=C: BAT-1=cd \...\...\path\to\remote\account BAT-1=...uv\bin\uv TCL_CMD_TO_RUN * BAT.KEY=REMOTE_@USERNO:.BAT WRITE BAT ON BAT.FL, BAT.KEY TCL=DOS /c :DQUOTE(...\PATH\TO\BAT\FILE\:BAT.KEY) EXECUTE TCL CAPTURING OUTPUT Where: BAT.FL can be a type19 file somewhere on your system. ..\..\path\to\remote\account is the physical path to the remote account. TCL_CMD_TO_RUN will be a program, proc, etc. to run on the remote account. ..uv\bin\uv is path to the uv.exe program. This will launch a session, execute the command and return the output to you. You will need to check the @TTY of the remote account to prevent launching the 2nd session into a menu etc. (Console) ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of bpa...@serta.com Sent: Friday, July 27, 2012 10:42 AM To: u2-users@listserver.u2ug.org Subject: [U2] Running a command in a different account Greetings! We have a program that runs in one account, but under certain conditions it is becoming necessary for that program to execute a command in another account, and then continue on its merry way doing other things. One fairly simplistic example might be that the process might find it necessary to create a file in another account. We have come up with a number of different ways of accomplishing this, but all involve a phantom LOGTO of some sort -whether it be through working with the UV.ACCOUNT file, the LOGIN paragraph, or some combination of the above. While this will do what is necessary, there are timing issues to consider, control and response issues, error checking, etc. It can be done, but it's not pretty. Does anyone have a more elegant and efficient way of accomplishing this? Thanks in advance! Brian F. Paige _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material not intended for Public use. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is strictly prohibited. If you received this communication in error, please notify the sender and delete the material from any and all computers or devices. ___ 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] Array Types
DIM saves time on read and write... Direct reference to an attribute as a discrete variable is where the time-savings is realized. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, July 27, 2012 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Array Types I would suggest that random writing would have a substantial impact. Reading doesn't have to move the string around, I suggest that's where your real savings comes in. -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jul 27, 2012 10:25 am Subject: Re: [U2] Array Types Here's a quick proggy I've scrudged together to get a rough indication - results on my system are: Dynamic Dimensioned Read/random access 18.4 14.2 Read only3.9 4.6 This is with small records: obviously with larger ones the gaps should widen. Brian PROGRAM testdim DIM SALESREC(10) Open 'BOOK_SALES' To F.SALES Else STOP * Ignore the first run as it loads the file into memory Crt First dummy run Fin = @False Select F.SALES Loop ReadNext Id Else Fin = @True Until Fin Do Read SalesRec From F.SALES, Id Else Null Repeat * Now the real one, read and randomly access fields Crt Dynamic Array Now = Time() For I = 1 To 100 Fin = @False Select F.SALES Loop ReadNext Id Else Fin = @True Until Fin Do Read SalesRec From F.SALES, Id Else SalesRec = '' End For J = 1 To 100 Attr = Rnd(9) + 1 Temp = SalesRecAttr Next Repeat Next Crt Time taken : : (Time() - Now) Crt Dimensioned Array Now = Time() For I = 1 To 100 Fin = @False Select F.SALES Loop ReadNext Id Else Fin = @True Until Fin Do MatRead SALESREC From F.SALES, Id Else Mat SALESREC = '' End For J = 1 To 100 Attr = Rnd(9) + 1 Temp = SALESREC(Attr) Next Repeat Next Crt Time taken : : (Time() - Now) * Now just read overheads no access to fields Crt Dynamic Array Read Only Now = Time() For I = 1 To 100 Fin = @False Select F.SALES Loop ReadNext Id Else Fin = @True Until Fin Do Read SalesRec From F.SALES, Id Else SalesRec = '' End Repeat Next Crt Time taken : : (Time() - Now) Crt Dimensioned Array Read Only Now = Time() For I = 1 To 100 Fin = @False Select F.SALES Loop ReadNext Id Else Fin = @True Until Fin Do MatRead SALESREC From F.SALES, Id Else Mat SALESREC = '' End Repeat Next Crt Time taken : : (Time() - Now) STOP -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jbut...@hampshire.edu Sent: 27 July 2012 16:24 To: U2 Users List Cc: U2 Users List Subject: Re: [U2] Array Types I understand the performance trade off between dynamic and dimensioned arrays but I'm curious about quantifying. I know the answer will depend on hardware and load, but in general at what point (length) do dimensioned arrays become better performing than dynamic? 1000? 1? 10? Any examples or benchmarks appreciated. Jeff Butera Sent from my iPhone On Jul 27, 2012, at 11:14 AM, David L. Wasylenko d...@pickpro.com wrote: Speed There is a *long* thread here demonstrating the difference between *DAYS* of processing and seconds, using large records for demonstration. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, July 27, 2012 10:16 AM To: U2 Users List Subject: [U2] Array Types I am surprised that anyone uses dimensioned arrays. I use dynamic arrays for everything. If there are any advantages that dimension arrays have over dynamic... please let me know... without getting sentimental. --Bill ___ 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] UV Triggers / SQL
LOGTO the account - it'll work there. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:06 PM To: U2 Users Subject: [U2] UV Triggers / SQL I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find TABLE table I have this account setup in UV_SCHEMA already (for another trigger), And the TABLE table is a Q pointer to another filename, which does not exist in THIS account. Do I need to setup the other account in UV_SCHEMA, and then create the trigger From that account on the file from within the account it resides? ___ 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] UV Triggers / SQL
You don't need a schema... Triggers are allowed w/o schema. It's a pain here too, separate account for DATA / programs... Create a control record of files/triggers/programs etc. Then write a program to perform bulk maintenance. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:17 PM To: U2 Users List Subject: Re: [U2] UV Triggers / SQL Can I have tables from multiple UV accounts in the same SQL Schema? Or will Have to Maintain multiple Schemas and use the schema.table notation when referring to it? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Tuesday, July 24, 2012 3:04 PM To: U2 Users List Subject: Re: [U2] UV Triggers / SQL LOGTO the account - it'll work there. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, July 24, 2012 2:06 PM To: U2 Users Subject: [U2] UV Triggers / SQL I'm trying to setup a trigger on a UV File. I created the cataloged subroutine, I'm running as user uvsql I type in CREATE TRIGGER name AFTER INSERT ON table FOR EACH ROW CALLING '*subroutine'; And it says it can't find TABLE table I have this account setup in UV_SCHEMA already (for another trigger), And the TABLE table is a Q pointer to another filename, which does not exist in THIS account. Do I need to setup the other account in UV_SCHEMA, and then create the trigger From that account on the file from within the account it resides? ___ 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] trimming a list (a test of your ability)
Nope; Has to do with how systems handle system delimiters. Dynamic arrays maintain pointers to attribute locations, but not the @VM pointers. The system already has buffering, memory management etc. for string manipulation. However, what makes it fast is the routine makes use of 1,000 different memory locations, each being vastly smaller than the final resulting record. Each element of the array is smaller string, resulting in less paging, heap manipulation etc. The following example uses ONE variable instead of the previous 1000; Execution time is 21.735 seconds compared to the prior version: 3.75 seconds 01:D.ARRAY= ; START.TIME=TIME() 02:FOR PTR=1 TO 100 03: GOSUB H.ADD; * add to array 04: ! IF NOT(MOD(PTR,1000)) THEN CRT PTR 05:NEXT PTR 06:GOSUB H.RESULT 07:END.TIME=TIME() 08:CRT END.TIME, START.TIME, END.TIME-START.TIME 09:STOP 10: ** 11: H.ADD:* add to array 12: ** 13:D.ARRAY-1=PTR 14: * 15:RETURN 16: ** 17: H.RESULT:* construct resulting array 18: ** 19:D.ARRAY=CHANGE(D.ARRAY,@AM,@VM) 20: * 21:RETURN 22: * 23: * end of job 24: * 25: END . david . David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, July 12, 2012 3:20 PM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) You are probably thinking about the technique of pre-allocating the chunk of memory first, then manually overwriting sections instead of appending to the end. This saves on system calls to allocate new memory. I think there used to be something on pick wiki about it. Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Thursday, July 12, 2012 12:58 PM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) I recall using attributes can be faster... This ran in 4.297 seconds with the display AND 3.75 without the progress display. But it took 24.656 seconds using @VM as delimiter. 01:DIM BIG(1000) ; MAT BIG= 02:D.ARRAY= ; START.TIME=TIME() 03:FOR PTR=1 TO 100 ;* one million 04: GOSUB H.ADD; * add to array 05: IF NOT(MOD(PTR,1000)) THEN CRT PTR ;* progress display 06:NEXT PTR 07:GOSUB H.RESULT 08:END.TIME=TIME() 09:CRT END.TIME, START.TIME, END.TIME-START.TIME 10:STOP 11: ** 12: H.ADD:* add to array 13: ** 14:SEG.PTR=MOD(PTR,1000)+1 15:BIG(SEG.PTR)-1=PTR ;* alternate BIG(SEG.PTR)1,-1=PTR 16: * 17:RETURN 18: ** 19: H.RESULT:* construct resulting array 20: ** 21:MATBUILD RESULT FROM BIG USING @AM 22:MV.RESULT=CHANGE(RESULT,@AM,@VM) 23: * 24:RETURN 25: * 26: * end of job 27: * 28: END . david . David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, July 12, 2012 1:50 PM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) Yes, exactly. If you starting breaking down what would be happening behind the scenes, you can see why X-1=I will be faster than X:= @AM:I will be faster than := X:@AM:I Hint, it is all about memory management, temporary variables, individual byte code ops and big O complexity (not necessarily in that order). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Thursday, July 12, 2012 10:25 AM To: 'U2 Users List' Subject: Re: [U2] trimming a list (a test of your ability) Ah, but try it with := instead of Y = Y: David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Thursday, July 12, 2012 8:56 AM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) ROUNDS = 1 LOOP X = '' ; Y = '' START.TIME = TIME() FOR I = 1 TO ROUNDS X-1 = I NEXT I END.TIME = TIME() CRT END.TIME-START.TIME : vs : START.TIME = TIME() FOR I = 1 TO ROUNDS Y = Y:CHAR(254):I NEXT I END.TIME = TIME() CRT END.TIME-START.TIME ROUNDS *= 2 REPEAT Results suggest that you should od -1, not the multiple concatenation. Dan McGrath Product Manager Rocket Software 4600 S. Ulster Street ..Suite 1100 ..Denver, CO 80237 . USA t: +1.720.475.8098 . m: +1.617.630.7392 . e:dmcgr...@rocketsoftware.com w: rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2
Re: [U2] trimming a list (a test of your ability)
JUST FOR FUN... I bumped the iteration count to 10,000,000 And the DIM BIG() to 10,000 Ran in 60 seconds with 157,094 to 355,618 iterations per second. Total byte count of the resulting @MV list was 78,888,896 bytes NOT too shabby ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Thursday, July 12, 2012 4:57 PM To: U2 Users List Subject: Re: [U2] trimming a list (a test of your ability) Not exactly. Current position of EACH unique variable... And a DIM BIG(1000) has/is 1,000 unique variables. So 1,000 unique pointers. And the writing whole string --- yes it would, if the size outstrips the memory allocated. By using 1,000 smaller strings, the move is triggered much less often, allowing the append operation VS reallocation of a new, larger memory buffer. With REC-1 or REC1,-1 syntax: Using a *single* variable, 1,000,000 iterations: @am delimited = 21.719 seconds, ranging from 41,545 iterations a second to 45,161, very consistant @vm delimited = ( Had to stop it at 100,000 iterations, 235.561 seconds) from 12,787 iterations a second at start down to 449 per sec at 100,000 values, consistently slower and slower Just using REC-1 saved a HUGE amount of time. Using a DIM(1000) variable: @vm delimited = 24.859 seconds 39,553 to 317,460 per second; wide swing but much faster than a single variable @am delimited = 3.781 seconds245,158 to 425,531 per second; the big winner The @VM delimiter will continually get slower and slower using either method, however, the slowdown occurs only 1,000 times. So in either case, the savings is significant using @AM - the DIM() concept is icing and the best method I've seen. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, July 12, 2012 4:16 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] trimming a list (a test of your ability) I beg to differ. The runtime maintains a pointer to *your current attribute*, as I understand it. Not to *each* attribute location. One buffer location, not a thousand. If it maintained a pointer to *each* attribute location, you could jump around in the variable at random and has access as quick as a dimensioned array gives you. But I believe that is not the case. By-attribute insertion is quick *only* because you are always inserting at the current position (or the next). Change this to a locate with insertion and it should dramatically slow down. This is because the entire string is being picked up and put down on each insert. The whole string. I think in the case of insertion at the end (the current position) it doesn't actually pick up and rewrite the whole string on each append. Just the end of the string. -Original Message- From: David L. Wasylenko d...@pickpro.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Jul 12, 2012 2:09 pm Subject: Re: [U2] trimming a list (a test of your ability) Nope; as to do with how systems handle system delimiters. ynamic arrays maintain pointers to attribute locations, but not the @VM ointers. he system already has buffering, memory management etc. for string anipulation. However, what makes it fast is the routine makes use of 1,000 different memory ocations, ach being vastly smaller than the final resulting record. Each element of the array is smaller string, resulting in less paging, heap anipulation etc. The following example uses ONE variable instead of the previous 1000; xecution time is 21.735 seconds compared to the prior version: 3.75 seconds 01:D.ARRAY= ; START.TIME=TIME() 2:FOR PTR=1 TO 100 3: GOSUB H.ADD; * add to array 4: ! IF NOT(MOD(PTR,1000)) THEN CRT PTR 5:NEXT PTR 6:GOSUB H.RESULT 7:END.TIME=TIME() 8:CRT END.TIME, START.TIME, END.TIME-START.TIME 9:STOP 0: ** 1: H.ADD:* add to array 2: ** 3:D.ARRAY-1=PTR 4: * 5:RETURN 6: ** 7: H.RESULT:* construct resulting array 8: ** 9:D.ARRAY=CHANGE(D.ARRAY,@AM,@VM) 0: * 1:RETURN 2: * 3: * end of job 4: * 5: END david . David L. Wasylenko resident, Pick Professionals, Inc ) 314 558 1482 l...@pickpro.com Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Daniel McGrath ent: Thursday, July 12, 2012 3:20 PM o: U2 Users List ubject: Re: [U2] trimming a list (a test of your ability) You are probably thinking about the technique of pre-allocating the chunk of emory first, then manually overwriting sections instead of appending to the nd. This saves on system calls
Re: [U2] How to Upload data from my pc to my account
Ohhh my; Here come the flames... ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of SUDHEER RAMISETTI Sent: Monday, July 02, 2012 11:31 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] How to Upload data from my pc to my account Hi:Could you plese tell me how to upload data from pc to my account. Thank you. sudheer ___ 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] ACH Functionality in ManFact
INTERESTING POINT; The work required would be about the same, shifting *some* of the liability / responsibility to a 3rd party is interesting. You would still be responsible for transferring $10,000 instead of $1,000.00 however, if ya miss a MD2/MR2 conversion however! :-) I wonder what the setup costs, monthly costs etc would be above the $0.35 or so per transaction VS: Adding an umbrella insurance policy for $1,000,000.00 for a hundred bucks a year and going direct if there is such a thing via the banks. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, June 22, 2012 11:09 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ACH Functionality in ManFact Don't do it. A must better solution, is to contract with an outside 3rd party, so they can absorb all the liability that comes with ACH processing. Who cares if they charge 35 cents per transaction, its a fair price to pay to avoid all the headaches. -Original Message- From: John Varney jvar...@soft-target-tech.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 8:35 am Subject: [U2] ACH Functionality in ManFact I've been tasked with writing a bolt on module to give ManFact the ability o utilize ACH processing. Has anyone done this already? If so, any words of isdom? __ 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] DICT Whacked in VOC
Logging out and back in actually can fix this issue... has for me. You should have a 'DICT' item in your VOC however, THIS from my main account CT MD DICT DICT 0001 K 0002 20 And this from my 'UV' account: CT MD DICT DICT 0001 Keyword - Specify the dictionary (distinct from the data) part of a file 0002 20 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, June 22, 2012 5:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DICT Whacked in VOC Starting and stopping Universe, and rebooting will do nothing to fix your problem. ED VOC SOH (not voc dict) The third line in SOH is a pointer to the dict location generally the VOC entry will read 001 F 002 SOH 003 D_SOH probably your third line is just screwed up, you can edit it and fix the entry. -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Jun 22, 2012 3:32 pm Subject: [U2] DICT Whacked in VOC DICT got messed up when I was trying to copy a dictionary... when trying to ecover a file. Now... list DICT SOH 0 records listed. DICT not found. ED VOC DICT ew record. : Q ED DICT SOH nable to open DICT, not a file in VOC. ile name= I did not yet try to stop and restart UniVerse. Also, I did not try to reboot the HP-Ux host. Suggestions would be appreciated. --Bill __ 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] Why did this compile??
Exactly correct... ~:TRIM(LINE4) would be used as an output formatting string. Just like TEST.STRING = 12345.678R2#10 would result in the string 12345.68 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Thursday, June 07, 2012 2:16 PM To: U2 Users List Subject: Re: [U2] Why did this compile?? I believe that it saw the second tilde as a format string. On 6/7/2012 2:47 PM, David Wolverton wrote: Look at this line of code... TEST.STRING = TRIM(LINE1):~:TRIM(LINE3)~:TRIM(LINE4) See how it is missing the : between 3)~ ?? Neither did I ... and the program compiled and ran without a complaint in UniData 7.2.12 -- but Obviously I was getting bogus results on the other side!! I'm trying to figure out why this was 'allowed' ... I'm ready this and thinking this should have tripped a compile message of SOME type! Just one of those 'how weird is this' things I thought I'd share since it cost me about an hour to find!! DW ___ 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] Monthly Multivalue Inserts and Speed
3k isn't large. #1 thing to look at is file size. Change the file-type to dynamic. It will not give the best performance compared to monitoring file size of a static file type, but over the long-term, avoids sizing issues that are the #1 reason for bad performance. Can you perform an ANALYZE.FILE {filename} and post the result? ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Friday, June 01, 2012 9:30 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Monthly Multivalue Inserts and Speed I have a file that is taking a very long time to update, seemingly longer and longer each month. Here is briefly how the attributes are organized, a relatively simple example: Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm 12-03 etc. Attributes 2 through 30 are dependent on attribute 1 and contain a variety of dollar amounts that are accumulated for the respective period in attribute 1. At the end of each month, a new G/L Period is inserted into the multivalued position of attribute 1 as well as each of the respective multivalued positions in attributes 2 through 30. Nothing complicated. My question is this and is aimed largely at the technicians at Rocket ... If, at the beginning of the year, I were to insert each of the 12-periods into their respective multivalues in attribute 1 and insert respective null multivalues into attributes 2 through 30, thus performing all of the 'inserts' at once, will the processing each month run faster as numbers are simply accumulated into attributes 2 through 30 and no inserting of new multivalues will have to be performed? A couple nuggets of information: This is only an example. In the actual file, these records contain many other attributes and the records overall are relatively large, averaging lengths of about 3,000 according to FILE.STAT These are not my files so reorganizing them is not an option. The heart of this question is, as a (numeric) number is accumulated in an attribute, multivalue or subvalue, what causes the record to 'stretch' in length, thus presumably impacting performance? I would like to think that numeric information is stored in a more 'compact' method than strings, thus using less space within the database ... but what I 'like' and what 'is' are often quite different. Thanks! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com http://www.hubbardsupply.com Delivering Products, Services and Innovative Solutions ___ 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] Monthly Multivalue Inserts and Speed
What's the record count and total byte count? ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Friday, June 01, 2012 9:41 AM To: U2 Users List Subject: Re: [U2] Monthly Multivalue Inserts and Speed Results of the ANALYZE.FILE: Dynamic File name = WHSE.STAT Number of groups in file (modulo) = 67801 Minimum groups of file= 67801 Hash type = 0, blocksize = 16384 Split load = 10, Merge load = 5 Split/Merge type = KEYONLY Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David L. Wasylenko Sent: Friday, June 01, 2012 10:32 AM To: U2 Users List Subject: Re: [U2] Monthly Multivalue Inserts and Speed 3k isn't large. #1 thing to look at is file size. Change the file-type to dynamic. It will not give the best performance compared to monitoring file size of a static file type, but over the long-term, avoids sizing issues that are the #1 reason for bad performance. Can you perform an ANALYZE.FILE {filename} and post the result? ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Friday, June 01, 2012 9:30 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Monthly Multivalue Inserts and Speed I have a file that is taking a very long time to update, seemingly longer and longer each month. Here is briefly how the attributes are organized, a relatively simple example: Attribute 1 is multivalued with our G/L Period, i.e. 12-01 vm 12-02 vm 12-03 etc. Attributes 2 through 30 are dependent on attribute 1 and contain a variety of dollar amounts that are accumulated for the respective period in attribute 1. At the end of each month, a new G/L Period is inserted into the multivalued position of attribute 1 as well as each of the respective multivalued positions in attributes 2 through 30. Nothing complicated. My question is this and is aimed largely at the technicians at Rocket ... If, at the beginning of the year, I were to insert each of the 12-periods into their respective multivalues in attribute 1 and insert respective null multivalues into attributes 2 through 30, thus performing all of the 'inserts' at once, will the processing each month run faster as numbers are simply accumulated into attributes 2 through 30 and no inserting of new multivalues will have to be performed? A couple nuggets of information: This is only an example. In the actual file, these records contain many other attributes and the records overall are relatively large, averaging lengths of about 3,000 according to FILE.STAT These are not my files so reorganizing them is not an option. The heart of this question is, as a (numeric) number is accumulated in an attribute, multivalue or subvalue, what causes the record to 'stretch' in length, thus presumably impacting performance? I would like to think that numeric information is stored in a more 'compact' method than strings, thus using less space within the database ... but what I 'like' and what 'is' are often quite different. Thanks! Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com http://www.hubbardsupply.com Delivering Products, Services and Innovative Solutions ___ 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] File Sizing using concurrent option AND FAREWELL
A company??? I wish I had the list to market into... work for life :-) ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Horacio Pellegrino Sent: Wednesday, May 23, 2012 2:16 PM To: U2 Users List Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL I remember a company that went bankrupt because they spent so much in SAP ( or was it Oracle? ) It was in the news. Anybody? HP On Wed, May 23, 2012 at 3:07 PM, Dawn Wolthuis dw...@tincat-group.comwrote: I have only seen SAP implementations from a bit of a distance and through reading stories, but in every case, my understanding was that those in charge of the project were gone before SAP went live. I have seen systems analysts and programmers survive the project, with plenty of stories once they do. It sounds like a really brutal ERP installation. I have not kept current on this front enough to know that people were still selecting it, although a whole lot of people are still maintaining it. Best wishes, Scott, and thanks for taking the time to write up your notes regarding some of those in the industry who have helped you. Cheers! --dawn On Wed, May 23, 2012 at 1:58 PM, Holt, Jake jh...@samsill.com wrote: I thought no one actually ever finished implementing SAP? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of iggch...@comcast.net Sent: Wednesday, May 23, 2012 1:31 PM To: U2 Users List Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL Don't worry, we're not going to implement anything that's going to do damage. Well, unless you call the outrageous cost a damage :) Any thoughts on the CONCURRENT option? - Original Message - From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Wednesday, May 23, 2012 2:14:19 PM Subject: Re: [U2] File Sizing using concurrent option AND FAREWELL Well you used to be. After SAP sucks ten years out of the life of your company, we'll see I am being moved to our corporate office to join a eam of 10 who will be learning, configuring, and customizing SAP to meet the eeds of the best wine and spirits distribution company in the world. Ok, I'm little partial... -Original Message- From: iggchamp iggch...@comcast.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 23, 2012 11:11 am Subject: [U2] File Sizing using concurrent option AND FAREWELL Hi All, uv 10.2.7 / hpux 11.11 First things first (skip this section if you don't care for goodbyes)... I wanted to say thanks to all of the contributors to this list. I have learned tremendous amount from all of you. The passion that many of you have for your ork is really inspiring. I am being moved to our corporate office to join a eam of 10 who will be learning, configuring, and customizing SAP to meet the eeds of the best wine and spirits distribution company in the world. Ok, I'm little partial... All of you deserve a great deal of credit for my pportunity as you have all contributed to the things that I've been able to ccomplish with my current system. Without the great system that we here in llinois have developed, I'm sure that noone would trust in my abilities to eliver in a different environment. blockquote special thanks to a couple of people I have been blessed to work directly ith. I cannot recommend their services enough! /blockquote blockquote ony Gravagno ( http://www.nebula-rnd.com/ ): When each division of SWS was sked to provide a web service that would interface our sales force automation nits to our business systems, I was terrified. I had never had the opportunity o work with web technology and, based on a heavy workload, did not have the ime to dive in at that time. I did take the web developer that Universe ffered for a spin. Pretty cool tool. While I was able to develop a web ervice that could work had I set the requirements myself, I could not get it to eet the requirements that corporate was developed. I even worked with one of he IBM engineers and he could not get it done. Keep in mind that I have always elieved in my abilities to provide solid solutions using the tools that we have n the multivalue world. It killed me to have to bring in a resource from the utside. I swallowed my pride and turned to Tony. I was amazed at the ncredible service that he provided. He developed a service for me that has een rock solid. I am still amazed that I have never had to revisit it after ears of pounding by our sales force. This is plug, play
Re: [U2] [UV] Connecting to a WebService with UV using Authentication Certificate
UniVerse also has ways of interfacing with a proxy. I do not have access to the code at the moment ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Tuesday, May 15, 2012 5:58 PM To: Jacques G.; U2 Users List Cc: U2 Users List Subject: Re: [U2] [UV] Connecting to a WebService with UV using Authentication Certificate UniVerse has BASIC API extensions that support calling http with secure sockets. I suspect this will do the job for you if the web service is exposed. Regards JayJay Sent from my iPad On 15 May 2012, at 15:14, Jacques G. jacque...@yahoo.com wrote: Hello, A need has come up where I work to connect to a web service using Universe however the Webservice needs a Authentification Certificate. Is there any way to do this all with Universe or does one need to make use of Java on the UV server ? (Are there any examples available that do something like this ?) Jacques G. ___ 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] Trim trailing attributes off records
Not if I remember correctly To prevent lost data, attributes above the DIM size are stuffed as dynamic array elements within the last element. ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 16, 2012 12:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trim trailing attributes off records Oh The DIM has to be *larger* than the attribute size. How curious. -Original Message- From: Dianne Ackerman dia...@aptron.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 16, 2012 10:36 am Subject: Re: [U2] Trim trailing attributes off records Will, your code gets the results you're seeing when I try it on UV, but f I change your code to have a large DIM of 100, it works the way you ant it to! Dianne On 5/16/2012 12:40 PM, Wjhonson wrote: 0001: OPEN VOC TO F.VOC ELSE STOP 0002: A = DOG:@AM:@AM:@AM:@AM 0003: PRINT CONVERT(@AM,!,A) 0004: WRITE A ON F.VOC,DOG 0005: READ B FROM F.VOC,DOG ELSE B = '' 0006: PRINT CONVERT(@AM,!,B) 0007: * 0008: DIM R.DOG(1) 0009: MATREAD R.DOG FROM F.VOC,DOG THEN 0010: MATWRITE R.DOG ON F.VOC,DOG 0011: END 0012: READ C FROM F.VOC,DOG THEN 0013: PRINT CONVERT(@AM,!,C) 0014: END Result: DOG DOG DOG -Original Message- From: andy baumandyb...@yahoo.co.uk To: U2 Users Listu2-users@listserver.u2ug.org Sent: Wed, May 16, 2012 12:34 am Subject: Re: [U2] Trim trailing attributes off records The manual states :- escription se the MATWRITE statement to write data from the elements of a dimensioned rray to a record in a UniVerse file. The elements of array replace any data tored in the record. MATWRITE strips any trailing empty fields from the ecord. 've run the following code in every flavor account on UV 10.3 CT BP TEST.MATWRITE TEST.MATWRITE 001 DIM REC(3) 002 OPEN '','VOC' TO VOC THEN 003 MATREAD REC FROM VOC,'MW' THEN 004 MATWRITE REC TO VOC,'MW' 005 END 006 END 007 END And get the following results Before CT VOC MW MW 001 FIELD 1 002 003 FIELD 3 004 005 006 007 008 009 010 RUN BP TEST.MATWRITE fter CT VOC MW MW 001 FIELD 1 002 003 FIELD 3 From: Wjhonsonwjhon...@aol.com o: u2-users@listserver.u2ug.org ent: Wednesday, 16 May 2012, 2:51 ubject: Re: [U2] Trim trailing attributes off records Sure but then *that* will not trim the trailing attributes. f you dim it to hold every element, and then write it back you just get the xact same problem with which you started. xtra empty attributes. The solution you already had, to matread it, blank rec(0), then matwrite it hat works. Original Message- rom: Wols Listsantli...@youngman.org.uk o: u2-usersu2-users@listserver.u2ug.org ent: Tue, May 15, 2012 5:59 pm ubject: Re: [U2] Trim trailing attributes off records n 15/05/12 20:50, Wjhonson wrote: Information Flavor o spaces in the fields, nothing in them at all, just a line of attribute rks with nothing in between. our trick below *does* work by the way, and it's essentially what I did. just set Rec(0) to nothing before the MATWRITE and that did it. But I was also surprised that Andy's trick of just matreading and then twriting didn't work. ou have to set Rec(0) to nothing in between 've just realised WHY that probably is ... Rec(0) is full of FMs ... f you dimension your array to hold every element of the record ithout* overflow, it'll work fine. I bet the MATWRITE tests if (0) is pty, and if it's got overflow in it ... heers, l Original Message- rom: Wols Listsantli...@youngman.org.uk o: u2-usersu2-users@listserver.u2ug.org ent: Tue, May 15, 2012 12:40 pm ubject: Re: [U2] Trim trailing attributes off records n 11/05/12 17:36, Wjhonson wrote: I thought that too. Tried that one. What it actually does is store all the trailing attributes in the header d en append them back to the record when it writes it out. Universe 10.3 at flavour? That ALWAYS worked for me on PI. et's say your dict declares up to, say, field 20 and you know there houldn't* be anything beyond it. ounds actually, like you are in PI mode so ... clare your MAT as 20 long :-) d a line before the write which says F CONVERT( REC(0), @FM: , ) EQ THEN REC(0) = ELSE PRINT ecord :ID: contains extra data! o basically, you're dumping what you don't want into element 0. The nvert checks that it really is nothing before zeroing it. 'm guessing it's not working for you because somehow there are actually aces in those fields you think are blank (ED gets rid of trailing
Re: [U2] Trim trailing attributes off records
RELLEVEL 001 X 002 10.1.23 003 REALITY 004 REALITY.FORMAT 005 10.1.23 ... david ... David L. Wasylenko President, Pick Professionals, Inc w) 314 558 1482 d...@pickpro.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 16, 2012 1:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Trim trailing attributes off records What system are you running? -Original Message- From: David L. Wasylenko d...@pickpro.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 16, 2012 10:56 am Subject: Re: [U2] Trim trailing attributes off records I've just run a test... OPEN FILE... IM REC(100) ATREAD REC FROM FILE... RT REC(1) RT REC(100) ND ALL extra attributes are in REC(100) ... David... __ 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] Trim trailing attributes off records
FILE.LIST=CUSTOMER FILE.LIST-1=... FILE.LIST-1=... * F.CNT=DCOUNT(FILE.LIST,@AM) FOR F.PTR=1 TO F.CNT F.NAME=FILE.LISTF.PTR OPEN F.NAME TO FILE.HANDLE THEN GOSUB H.PROCESS END ELSE CRT Cannot open file ':F.NAME:'. END NEXT F.PTR STOP * H.PROCESS:* * SELECT FILE.HANDLE LOOP WHILE READNEXT ID READU REC FROM FILE.HANDLE, ID LOCKED ... handle locked record, or skip END THEN REC=TRIM(REC,@AM,T) WRITE REC ON FILE.HANDLE, ID END ELSE ... handle missing record RELEASE FILE.HANDLE, ID END REPEAT * RETURN * * end of job * (do your own checking of this ad-hoc, untested method) ... david ... David L. Wasylenko President, Pick Professionals, Inc -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, May 10, 2012 5:21 PM To: U2 Users List Subject: Re: [U2] Trim trailing attributes off records I would write a little uniBasic program... to cleanse, purify, and rehydrate... testing it first in a sandbox. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, May 10, 2012 6:13 PM Subject: [U2] Trim trailing attributes off records Given that you have a file with thousands of records, each with dozens of trailing attributes which are empty. How can you pick up the file and drop it back down with all those empties trimmed off? ___ ___ 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] Proc question
If I follow your question: 001 PQN 002 MV %1 XX*YYYNN 003 O-- 004 T Input value:,%1 005 T Desired output:,%1:G1*1: 006 S2 007 IH%1:G1*1: 008 T Current content of %2:,%2 This will place 'YYYNN' into buffer %2 ... david ... David L. Waz Pick Professionals, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Jenkins Sent: Thursday, May 10, 2012 4:48 PM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] Proc question I use PQN PROCs regularly, including indirect buffer references (subscripts) and select buffer manipulation, UniData and UniVerse do have significant differences though. MV for primary and secondary input and output buffers is a staple, but sometimes the older style A\ and similar become invaluable. PROC on! The Jonathan Sisk references are a good start, I learned on Reality way back. I do recall a PL system being written in PROC at one time - and no, The explanation why is too improbable to believe, so I'll spare you. Regards JayJay On 10 May 2012, at 04:27, Ed Clark u...@edclark.net wrote: PQN procs are supported in unidata for sure. Just wasn't sure if the conversions on the MV command work there. You can use the universe proverb documentation as a starting point for working with procs in unidata, but there are a lot of differences, including some fundamental ones. For example, both PQ and PQN proc on universe use attribute marks to delimit fields in the buffers, but PQ proc in unidata uses the standard space delimiters.The universe proverb manual doesn't mention conversions on the MV command On May 9, 2012, at 11:23 AM, Brenda Ives wrote: Guide to ProVerb - UniVerse proc documentation. Brenda L Ives UniVerse Team Lead Rapid Response Team marketamerica.com/SHOP.COM Greensboro, NC 336-389-5950 RRT Team Red -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Wednesday, May 09, 2012 11:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Proc question Hi Ed,I am pretty sure that PQN procs are supported in Unidata, I have never used them or seen a manual for them. Like you I have not found anything in the udtdocs that addresses Proc eitherKebbon From: u...@edclark.net Date: Mon, 7 May 2012 22:58:31 -0400 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Proc question On May 7, 2012, at 4:45 PM, Kebbon Irwin wrote: Anyone know/remember how to do this:I have a string in my input buffer XX*YYYNNI want to place just YYYNN in my output bufferI feel I should be able to do this without writing my own user mode or a program that does a procread/procwriteThanks,Kebbon Unidata 7.1 Ecltype P ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users I don't know if unidata supports this (has anyone ever seen a unidata proc manual?) but in PQN proc on Reality, the MV command can apply a conversion: MV Purpose To copy data between the input buffer, output buffers, file buffers and select registers. Syntax MV destination source{,source}...{,*{n}}{,_} or MV destination source{*source}... Syntax Elements destinationis a direct or indirect reference to a buffer or select register that you want the data copied to. If the destination is a select register, the source can only be a direct or indirect reference to a file buffer. source is the data you want to copy. The source can be: * a direct or indirect reference to a buffer or select register that contains the data you want to copy. * a direct or indirect reference to a buffer followed by ';input-conversion;' or ':output-conversion:'. See the topic English Conversions for details. *a string of zero or more characters enclosed in single or double quotes. An uneven number of quotes now gives a syntax error. *a SYSTEM function that returns system/database information. * a single character expressed in one of two ways: Xxwhere x is a hexadecimal number in the range 00 to FF. Thus, XFD is a value mark. In where n is a decimal number in the range 0 to 255. Thus, I253 is a value mark. ,* copies all source parameters starting with the specified parameter. The destination buffer or select register is truncated after the last parameter is copied if * is the last operand in the source field. ,*n copies n further source parameters following (and in addition to) the specified parameter. ,_ specifies that the destination is truncated after the source is copied. *source concatenates