Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question
I believe it was just an "X" on Reality. And the prestore commands under Pick were lots of fun you could do complex multirecord changes or major damage On Thu, 6 Feb 2014 10:36:12 -0600, George Gallen wrote: I don't remember if that was on the Editor in Reality, or if it came along with Prime Information And eventually into UV George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Thursday, February 06, 2014 11:33 AM To: 'U2 Users List' Subject: Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question ABSOLUTELY!!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, February 06, 2014 11:27 AM To: U2 Users List Subject: Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question But you left out THE ABSOLUTE most important feature "OOPS" George ___ 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] Working with accented characters
If it's for internal use, I'd set up my own function (or subroutine) with the one - to - one relationships between each lower case accented letter and it's upper case equivalent. If the idea is to send info to a third party, or to use in a different database within you company, be careful that: a) not all third parties are able to recieve accented characters, b) It is completely acceptable and frequenty used in spanish speaking countries to strip accents off upper-case letters. If is quite common to see JOSE rather than JOSÉ, c) Make sure that the ascii equivalents in UV for the accented letters coincide with what your third party recieves. Perhaps you send char(xxx) as a Á, but the recieving party expects char(yyy). Regards, Marc On Mon, 25 Nov 2013 14:36:48 -0600, George Gallen wrote: Any consideration of converting the accented character to an unaccented character first? Not perfect but it works 99% of the timeand then when you export the name to another company All they get are unaccented letters. George SUBROUTINE REMOVE.ACCENT(INDATA,OUTDATA) * UAE=CHAR(140):CHAR(198) LAE=CHAR(156):CHAR(230) DEGREE=CHAR(176) * NULL1=CHAR(128):CHAR(129):CHAR(130):CHAR(131):CHAR(132):CHAR(133):CHAR(134):CHAR(135):CHAR(136):CHAR(137) NULL2=CHAR(139):CHAR(141):CHAR(143):CHAR(144):CHAR(145):CHAR(146):CHAR(147):CHAR(148):CHAR(149):CHAR(150) NULL3=CHAR(151):CHAR(152):CHAR(153):CHAR(155):CHAR(157):CHAR(160):CHAR(161):CHAR(162):CHAR(163):CHAR(164) NULL4=CHAR(165):CHAR(166):CHAR(167):CHAR(168):CHAR(169):CHAR(171):CHAR(172):CHAR(173):CHAR(174):CHAR(175) NULL5=CHAR(177):CHAR(178):CHAR(179):CHAR(180):CHAR(181):CHAR(182):CHAR(183):CHAR(184):CHAR(185):CHAR(187) NULL6=CHAR(188):CHAR(189):CHAR(190):CHAR(191) NULLX=CHAR(186):CHAR(216):CHAR(222):CHAR(240):CHAR(247):CHAR(248) * UPA=CHAR(192):CHAR(193):CHAR(194):CHAR(195):CHAR(196):CHAR(197) LWA=CHAR(224):CHAR(225):CHAR(226):CHAR(227):CHAR(228):CHAR(229) RUA=STR('A',LEN(UPA)) RLA=STR('a',LEN(LWA)) UPE=CHAR(200):CHAR(201):CHAR(202):CHAR(203) LWE=CHAR(232):CHAR(233):CHAR(234):CHAR(235) RUE=STR('E',LEN(UPE)) RLE=STR('e',LEN(LWE)) UPI=CHAR(204):CHAR(205):CHAR(206):CHAR(207) LWI=CHAR(236):CHAR(237):CHAR(238):CHAR(239) RUI=STR('I',LEN(UPI)) RLI=STR('i',LEN(LWI)) UPO=CHAR(210):CHAR(211):CHAR(212):CHAR(213):CHAR(214) LWO=CHAR(242):CHAR(243):CHAR(244):CHAR(245):CHAR(246) RUO=STR('O',LEN(UPO)) RLO=STR('o',LEN(LWO)) UPU=CHAR(217):CHAR(218):CHAR(219):CHAR(220) LWU=CHAR(249):CHAR(250):CHAR(251):CHAR(252) RUU=STR('U',LEN(UPU)) RLU=STR('u',LEN(LWU)) SS1=CHAR(138):CHAR(142):CHAR(154):CHAR(158):CHAR(159):CHAR(199):CHAR(208):CHAR(209):CHAR(221):CHAR(223):CHAR(231) SR1="SZszYCDNYBc" SS2=CHAR(241):CHAR(253):CHAR(170):CHAR(215) SR2="nyax" * EXPR1=UPA:LWA:UPE:LWE:UPI:LWI:UPO:LWO:UPU:LWU:SS1:SS2 EXPR2=RUA:RLA:RUE:RLE:RUI:RLI:RUO:RLO:RUU:RLU:SR1:SR2 NULCHARS=NULL1:NULL2:NULL3:NULL4:NULL5:NULL6:NULLX:DEGREE * LIN=INDATA * LIN=CHANGE(LIN,CHAR(223),"SS") CONVERT EXPR1 TO EXPR2 IN LIN CONVERT NULCHARS TO "" IN LIN LIN=CHANGE(LIN,CHAR(230),"AE") LIN=CHANGE(LIN,UAE,"AE") LIN=CHANGE(LIN,LAE,"ae") * OUTDATA=LIN RETURN STOP END -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little Sent: Monday, November 25, 2013 3:10 PM To: U2 Users List [u2-users@listserver.u2ug.org] Subject: [U2] Working with accented characters To convert the first character of a regular ASCII string to uppercase, I'd use OCONV("STRING",'MCT') so that "STRING" is output as "String". However, this doesn't seem to work for Spanish accented characters. The machine is UV 11.1.11 with NLS enabled. What is the most elegant way to convert a name, such as JOSÉ to José ? I'm not a sys admin, so if it requires setting up an NLS map or something along those lines, I'm probably out of luck. bob little applications architect independent contractor market america, inc. 1302 pleasant ridge rd. greensboro, nc 27409 Phone: 336-698-4367 Cell: 248-675-5515 Skype: boblittle904 ___ 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] UniAdmin - Where is Any Account directive written to
Good afternoon, I'm installing a UV windows 11.1 and am trying to change the login policy to "Any Account", but when I press the Save button, I get a message saying that UniAdmin is unable to save the info. I'm supposing it might be a permissions problem, even though I'm accessing with administrative privileges. I'm using UniAdmin. ¿Any clues? ¿Can someone tell me where UV writes this info to? Thanks, Marc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] More than one way to list the "Number of licensed users" ?
SYSTEM(36) in Basic CONFIG from TCL On Mon, 9 Sep 2013 16:14:41 -0400 (EDT), Wjhonson wrote: STATUS NETWORK on Universe, will list "Number of licensed uniVerse users: 110" Are there other ways to get this number? ___ 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] ED PERMISSIONS subroutine
Dianne, Does your login to telnet sessions also have this same delay? We experienced this problem (with ED and with Login); never fixed it. The company was a multinational that managed user priveleges at an international corporate level, so even though we are in Argentina, supoosedly there was some validation going on at a server in the US or elsewhere. The multinational sold local operations to a local company and the problem went away when we left the corportate network. On Thu, 15 Aug 2013 09:25:35 -0500, George Gallen wrote: To me, if it is causing a delay that was not there before - raises red flags and back hairs of read disk errors (or gonna be errors soon). Can you do a disk scan? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Thursday, August 15, 2013 9:51 AM To: U2-Users@listserver.u2ug.org Subject: [U2] [UV] ED PERMISSIONS subroutine Does anyone know anything about the -PERMISSIONS subroutine used by the ED verb in Universe? Running 11.1.12 on Windows, the ED verb has a huge delay and we've tracked it down to that subroutine call in the basic ED program. If I could look at that subroutine to see what it's doing, maybe I can figure out what's causing that delay. Thanks! -Dianne >ED BP ED.B The file "BP" is read-only and cannot be updated. 3988 lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS' : L 0308: CALL @PERMISSIONS(EDIT.FILE,EDIT.PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT) : EX ___ 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] LIST reports and Fields that Do reads
The READ is executed each time, but if the record being read is in virtual memory, this second "read" doesn't occur at the disk level. If the file being read is relatively small (ex.: descriptions) it will probably end up in memory quick enough and not provoke performance issues. On Fri, 19 Jul 2013 20:14:38 +, Israel, John R. wrote: Yes, the read will be done each time the record is LISTed (SORTed, SELECTed, etc). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of randyleesmith Sent: Friday, July 19, 2013 4:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] LIST reports and Fields that Do reads Lets say you have a field that calls a subroutine. In this routine you do a read to lookup a description which it what is passed back. When you do a LIST to create a report with this field will the read be done each time? I was just wondering how the Universe system handle's this. Dose the system store the first read in it's in memory and just uses that instead of doing a read each time? -- View this message in context: http://cp.mcafee.com/d/5fHCNApdEIzC4T666kPtPqdQkTXETjd79J6WarZQkQjhOrhKyC_t6XdPqdQkPhO-OMMqejsGhTN68agQJeIadHv6loYKrgQJeIadHv6loYKrtsIqejhPWb_nVBUQsII9FZuVtdCVEVVZxZVVZXBHEShjlhKVOEuvkzaT0QSyrjdTdTdw0SQOXs96vzjOXs98rfuhKep76zB_EfZ3i10_-nMaxEM2iYvmH6t2-MgbyYLfgEnCjSpseGnz-EkbPmohpKNMedJFBSWv6xsxlK5LE2zVkDjUCvzPqrp7w09JCUVUSqmMCCqnjh05gQo19EwzWRoPEq8dwwq81unDEkd44OuPd40tkQgh_ka6XCNmg4PG4Da_d Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://cp.mcafee.com/d/avndygQ86QmhP2rz33apKVJ6WarZQrFCzASzt5d-Waq9EVdEThjvKztCVJ6WapEVvpood79Kl8XUz458qmDm56RLzaIundEqmDm56RLzaIundKKmd79EVZ5_HYOYqemm4Q-LsKCPsQsY-M-YY-ZORQr8FGETsVkffGhBrwqrjdFCXCXCM0pYGjFYjfNVJdIzM071dnoovaAVgtHzqptKDNErrjbJQ-d2V2Hsbvg57OFeDNc_7CQSOf00jrdNPNIQJxdcQKCy0axEM2jh17RGNDgQgr10Qg2YLfgEq89AZCq80WFEwz-EkdTdQm8A9a7I ___ 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] uniobjects.net
If the supposed access time for these records is rather quick, 200 records is a relatively small record set. Although there are technically more elegant ways of doing this, why cant you just stick with your proven basic subroutine call? On Mon, 3 Dec 2012 14:59:43 -, Symeon Breen wrote: Ahh yes - upto about 200 ish -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of mhilb...@ppcsoftware.com Sent: 03 December 2012 14:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects.net For me the key is in how many is "a number of records"? On Mon, 3 Dec 2012 14:48:45 -, Symeon Breen wrote: Hi - I have been using uniobjects.net for many years now, however I usually use it to call a basic subroutine on the u2 server. I now have a little project where I need to get a number of records from a file, ideally like the output of a list command as I have some itypes I also need to get. I could do this via a select list and read the ids into a unidataset and then call other programs to get the itype data, or I could do a unixml probably a few other ways. So what is the best way to do this ? Thanks Symeon. ___ 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 - No virus found in this message. Checked by AVG - www.avg.com Version: 2012.0.2221 / Virus Database: 2634/5433 - Release Date: 12/02/12 ___ 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] uniobjects.net
For me the key is in how many is "a number of records"? On Mon, 3 Dec 2012 14:48:45 -, Symeon Breen wrote: Hi - I have been using uniobjects.net for many years now, however I usually use it to call a basic subroutine on the u2 server. I now have a little project where I need to get a number of records from a file, ideally like the output of a list command as I have some itypes I also need to get. I could do this via a select list and read the ids into a unidataset and then call other programs to get the itype data, or I could do a unixml probably a few other ways. So what is the best way to do this ? Thanks Symeon. ___ 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)
To continue along these lines, and if you want your code to be compact, if KEY.LIST were equal to RAISE(KEY.LIST) you could do this: NEW.LIST = "" SELECT KEY.LIST LOOP WHILE READNEXT UTILITY.ID DO GOSUB GET.UTILITY.RECORD IF INDEX(UTILITY.NAME,LAST.NAME,1) THEN NEW.LIST<-1> = UTILITY.ID REPEAT UV 10.2 Regards, Marc On Thu, 12 Jul 2012 09:22:11 +0100, Brian Leach wrote: Well, If you're deleting from a list you want to be iterating backwards. If you're on UniVerse you want to be using field not value level (for hint mechanism) or use revremove. It assumes LAST.NAME is not empty. Since I don't know your data I do know if using index will stuff it if is not a unique part of a field, or if it more efficient to build a new key list or take from the current (are there more deleted than kept?) You can use the new (ugly, ugly but potentially useful) U2 Dynamic Objects to make a dictionary structure to ensure uniqueness.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 12 July 2012 01:10 To: u2-users@listserver.u2ug.org Subject: [U2] trimming a list (a test of your ability) 1295 FOR DISPLAY.LOOP = 1 TO KEY.COUNT 1296 UTILITY.ID = KEY.LIST<1,DISPLAY.LOOP> 1297 GOSUB GET.UTILITY.RECORD 1298 IF INDEX(UTILITY.NAME,LAST.NAME,1) = 0 THEN 1299KEY.LIST = DELETE(KEY.LIST,1,DISPLAY.LOOP,0) 1300DISPLAY.LOOP -= 1 1301KEY.COUNT -= 1 1302 END 1303 NEXT DISPLAY.LOOP Comments? ___ 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] T30File parameter in Universe 10.3.7
Yes, we ran into this limit some time ago at a client site, we set it to 1200. No problems. On Fri, 06 Jul 2012 14:15:00 -0400, Allen Egerton wrote: The default value for T30Files is 200, and it's described as controlling the number of dynamic files that can be open on a system at any point in time. Has anyone had practical experience with increasing this limit? And yes I'm asking because we just crashed into this wall --- and it wasn't pretty. Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] File error
If this were a dynamic file, you would have to create a new file adding the phrase 64BIT. I don't know if the phrase is valid for non-dynamic files. On Mon, 2 Jul 2012 10:20:13 -0500, Holt, Jake wrote: We are getting the message: Warning: Attempt to extend file "GJ/INV" beyond the 2 gigabyte file limit. 32-bit static hashed or dynamic files cannot exceed a file size of 2 GB. Use a distributed or 64-bit file. I get why we're getting the message, I'm wondering, what is the easiest/safest way to fix it? I could purge records if necessary but they would prefer not doing this. We're running 10.0.21 on Windows server 2003 32 bit. Thanks, Jake ___ 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] Detecting idle time in INPUT statement.
Check INPUTIF, this will return a value if the input buffer has something. If after 2 minutes of checking INPUTIF you have nothing it's because the user isn't active. If you do a LOOP with INPUTIF inside be careful to put an RQM or something similar in the loop. On Tue, 27 Mar 2012 06:26:38 -0700 (PDT), Don Robinson wrote: Hello all, We are running Universe 10.1 on AIX with about 500 users. We have a problem with users opening up a record which puts a lock on it and just letting it sit at the INPUT statement for a long time. Most of the locking within the application does not use the LOCKED clause so when a second person needs the locked record, their session waits. What is the best way to detect the user hasn't typed anything for a period of time, say 2 minutes? This needs to be simple as we have no desire to rewrite the application! IIRC, some other MV systems have a timeout on the INPUT but I can't find anything about this in the UV manual. Thanks, Don Robinson ___ 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] Video Quirk
John, The data you are managing probably has control character sequences. For display purposes, you should replace all characters below char(32) with ".". For reseting the colors, try HELP BASIC @ Regards, Marc On Tue, 31 May 2011 11:18:25 -0400, Israel, John R. wrote: I have written a program that runs from TCL to look for "bad" E-mail addresses in various files. This info is then E-mailed to the user running the program (i.e. me) with an attachment of the problems found. It then asks if you wish to fix the data. If you say yes, it populates WORK<1> with all the invalid E-mails, then invokes a stand-alone SB screen that displays the problems (WORK<1>) on the left and allows you to enter the corrects on the right (WORK<2>). When you exit this screen (either with F2 or ESC), it exists out of SB and updates the data as desired. The problem I am having is that the video changes colors. While not a disaster, it is a little distracting. Nothing else is impacted, and typing MM to go back into SB re-sets the colors correctly. Does anyone know how to manually re-set the colors to go back to the normal ones? John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 ___ 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] Special Character Handling
I know I'm not answering the original question "Is there a tool ", but if the validation is on-line, it would be best to manage a list of valid characters, rather than do converts of specific characters. Bearing in mind that users can copy-paste into your input field, or type Alt+nnn you can easily get trash in your database, that later comes back to haunt you when you export to excel, try to put together an SQL query, etc. If it's a web-based app, there are security issues and you definitely should have a set of valid characters. Regards, Marc On Wed, 12 Jan 2011 04:10:52 -0600, George Gallen wrote: Depends on which special charactersIf you mean accented letters, I use a subroutine that converts the accented high ASCII code to it's non-accented letter. (EX. e' to e). Basically, it's just a bunch of converts. But it's good for converting data that was entered via a website text entry where foreign letters can be entered. The hard part is collecting all the possible accented letters. George George Gallen Senior Programmer/Analyst Accounting/Data Division ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings [ron_hutchi...@hotmail.com] Sent: Tuesday, January 11, 2011 6:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Special Character Handling Is there a tool to remove special characters from a text file? Other than a roll your own with convert or replace in a program? ___ 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