Re: [U2] How many will be selected?
From HELP BASIC SELECTINFO: | SELECTINFO function | | | | _| | | | | | SYNTAX | | | | SELECTINFO (list, key) | | | | DESCRIPTION | | | |Use the SELECTINFO function to determine whether a select list| |is active, or to determine the number of items it contains. | Best regards, Henry Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, October 19, 2010 10:41 AM To: U2 Users List Subject: [U2] How many will be selected? UV here I open a file, then use SELECT filevarible then proceed to do a LOOP/READNEXT/REPEAT to scan through the file. OPEN ,SOMEFILE TO F.TEST ELSE STOP SELECT F.TEST LOOP READNEXT ID ELSE EXIT REPEAT Is there any way to know how many records WILL BE processed in that loop before scanning? @selected doesn't work, it only returns the number of items in the last group that was read I tried using SELECT filevariable TO list.variable but you can't do a DCOUNT on that variable you can only READNEXT FROM list.variable Aside from EXECUTE SELECT filename RTNLIST in place of the SELECT filevariable so that @selected would return with the actual number selected (which does do what I want) Any other methods? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Lock the record before you write it. Henry Unger Sent from my iPad On Jul 30, 2010, at 2:47 PM, Jeff Schasny jscha...@gmail.com wrote: So far so good. Trigger installed. Trigger blows up. My trigger program calls the *MAIL.SEND routine (which works when called from other programs in this account) which is apparently blowing up when attempting to write an item to the current directory (UFD) at line 214. Anyone have a guess on what this means? Program *MAIL.SEND: Line 214, FATAL: The locks necessary for database operations at the current isolation level (0) are not held by this process. Error performing trigger for /upg/CUBUPG/CO.TF -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
I was wondering if that's what you're up to. I'm not at my computer, but try PHANTOMing it. Henry Unger Sent from my iPad On Jul 30, 2010, at 3:48 PM, Jeff Schasny jscha...@gmail.com wrote: Thank you all. After much putzing with the various parts involved it is beginning to look like my original plan of having an email message sent when someone adds a new record to this file is not to be. Apparently executing an SH verb in a trigger program is not going to happen (Verb SH illegal when a transaction is active.). Boom Splat. Henry Unger wrote: Lock the record before you write it. Henry Unger Sent from my iPad On Jul 30, 2010, at 2:47 PM, Jeff Schasny jscha...@gmail.com wrote: So far so good. Trigger installed. Trigger blows up. My trigger program calls the *MAIL.SEND routine (which works when called from other programs in this account) which is apparently blowing up when attempting to write an item to the current directory (UFD) at line 214. Anyone have a guess on what this means? Program *MAIL.SEND: Line 214, FATAL: The locks necessary for database operations at the current isolation level (0) are not held by this process. Error performing trigger for /upg/CUBUPG/CO.TF -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] PI/open installation question
Hi Natasha, I suspect the problem is a missing link to the HP-UX kernel. The location moved between HP-UX 9.x and HP-UX 10.x. It's documented in the installation readme: 5.4 Support for PI/open on HPUX 10.0 Release 3.6.1 is expected to work on HPUX release 10.0. At HPUX release 10, the default shell is a posix compliant shell, not the Bourne shell as it was in previous releases. PI/open relies on a Bourne shell for many shell scripts and commands. To insure a consistent Bourne shell, a link has been made in /bin to a bourne shell. This is done at both release 9.0 and 10.0, and is located in /bin/pish. You must not delete this link. If you upgrade from HPUX 9.0 to HPUX 10.0 without reinstalling PI/open, this link will no longer be valid. To solve this situation, either completely reinstall PI/open from tape or issue the following command: ln /usr/old/bin/sh /bin/pish At HPUX release 10, the kernel file /hp-ux will no longer exist by default. PI/open needs the file /hp-ux to exist in order for it to be booted. If this file does not exist on HPUX 10, you must create this link yourself. This can be done with the command: ln /stand/vmunix /hp-ux At this point, PI/open should run without any other changes needed. Just out of curiosity, why haven't you moved to UniVerse? Best regards, Henry Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Natasha Zagsky Sent: Thursday, July 22, 2010 9:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] PI/open installation question [Also posted to Usenet newsgroups: comp.sys.prime, comp.databases.pick] I'm setting up a test server and I am running into a problem during the installation process. If you're familiar with installing PI/open, please help. Database: PI/open Rev. 3.6.2.r6 Operating System: HP-UX B.10.20 Hardware: HP 9000 Series 800 System From PI/open Installation Menu (UNIX script ./pi_install)I execute option 6 updateisys Update ISYS accountand receive this error message: Updating /usr/isys ...updateisys: Failed to bootstrap shared PI/open. The message (OS: No such file or directory) in PILOG WARN.0 is obviously suspicious, but I have no indication what file or directory it refers to. Can anyone with experience installing PI/open make any suggestions? Thank you in advance, Natasha Zagsky zag...@hotmail.com _ Look 'em in the eye: FREE Messenger video chat http://go.microsoft.com/?linkid=9734386 ___ 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] problem - Attempted WRITE with record ID larger than file/table maximum
Perhaps the index is defined as single-valued when it should be defined as multi-valued. Best regards, Henry Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, June 09, 2010 8:34 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] problem - Attempted WRITE with record ID largerthan file/table maximum Yeah that could be it but I just did a restore of last nights pre-cycle data. An interesting thing I noticed in regards to the table GENACCTRN (the one we're having issues with) and noticed the following errors with the index: Restoring c:\LIVE/I_GENACCTRN/INDEX.005 (19:34:23) Restoring c:\LIVE/I_GENACCTRN/INDEX.006 (19:34:23) Unable to write item 9ý3136FJMA6ý912828DC1ý3136FJQU8. Unable to write item 361448AG8ý362311AH5ý36966RV60ý4165X0MJ6ý4165X0NK3ý44181EW79ý620076AH2ý620076AP4ý925524AQ3ý92923WAA8ý025816BA6ý3136FHSC0ý3136F3R32ý3128X9YC8. Unable to write item 220905202ý94979B204ý38144X500ý17306N203ý369622519ý46623D200ý95709T704ý59021V839. Unable to write item 165069AS4ý25271CAK8ý260543BJ1ý50075NAC8ý650094CA1ý3135A1GD3ý3136FHR23ý3136FJME8ý3128X9XG0ý00206RAB8ý035229CT8ý053332AF9ý06550XDM2ý06406JCU7ý219350AS4. Restoring c:\LIVE/I_GENACCTRN/INDEX.MAP (19:34:23) 'unable to write' to the index. I guess this index will need to be rebuilt? Date: Wed, 9 Jun 2010 11:24:18 -0400 From: slestak...@gmail.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] problem - Attempted WRITE with record ID larger than file/table maximum On 6/9/2010 10:46 AM, Chris Austin wrote: I believe that is the problem, the key for record '15500*60431*EJK' must have more than 255 characters. Is there a way to check the # of characters on a key from a telnet prompt? I'm confused why the key would be so big? There must be 'historical encoding of record locks' or something behind the scenes being stored. Basically it's a record we have in table #1 that we are writing to table #2. Would there be anything to check on the record? Thanks. ttp://listserver.u2ug.org/mailman/listinfo/u2-users I have done this by accident before. If you are getting your key from a multivalue list and have the wrong delimiter chosen, you will send the dynamic array as the key and that can be too long. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ The New Busy think 9 to 5 is a cute idea. Combine multiple calendars with Hotmail. http://www.windowslive.com/campaign/thenewbusy?tile=multicalendarocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_5 ___ 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] U2-Users Digest, Vol 14, Issue 3
IBM AIX supports WPARs, which allows us to run multiple instances of UniVerse on the same server. Perhaps UniData will work as well. Best regards, Henry Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Thursday, June 03, 2010 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2-Users Digest, Vol 14, Issue 3 On 6/3/2010 3:00 PM, u2-users-requ...@listserver.u2ug.org wrote: Message: 6 Date: Wed, 2 Jun 2010 17:30:53 -0700 From: Boydell, Stuartstuart.boyd...@spotless.com.au To: U2 Users Listu2-users@listserver.u2ug.org Subject: Re: [U2] SB+ PA Compare Message-ID: 7ee7790a950e094399b01520071826a20106b48d6...@sg1rd3xvs031.red003.local Content-Type: text/plain; charset=us-ascii Hi Steve, Perforce for source control combined with virtual machines for development and test. The use of Perforce was mainly because it has a great API and fits well with the spectrum of development. It's not all about U2 here. I haven't looked at any of the distributed VCS components so I can't offer any advice there. As a suggestion, I cannot recommend highly enough the use of VMs for dev and test. Using a VM will give you a system based replication of your production environment and data. This means rather than creating development and test accounts, you can develop and test in your production environment with all the same file pointers, account names, security settings etc. There are numerous other advantages to VMs. They can be provisioned and torn down again rapidly. Depending on your VM platform they can be snap-shot and rolled back during bug fixing, install dev/tests and scenario testing. You can have an app developed and installed with*exactly* the same set of artefacts and instructions for test and prod. And it also which means you can reduce the number of accounts you need to maintain. Cheers. S I would love to use vm's, however, we are using udt on aix. there isnt any guest ability for aix :). I could maybe use rhel test accts, but the conversion of files each time could be a problem. The endian problems, etc. For those Prelude users out there, I did hack up a PSICOPY that uses rsync so I can psicopy remotely. That still wont help with the conversion issues of mixing x86 and ppc. ___ 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] Pick on Mac
Yes. OpenQM by Ladybridge Systems. http://www.openqm.com ...available on Windows, Linux (Red Hat, Fedora, Debian, Ubuntu), FreeBSD, Mac OS X and Windows Mobile. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Monday, March 29, 2010 12:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Pick on Mac Are there are native implementations of a Pick system on Macs? Or are all Mac connections just terminal emulators into a Windows/Unix system? I know there is or used to be an emulator by Carnation that rode on a Mac. But have all such implementations been to have it talk with a Pick system living on a Windows or Unix box? Does Universe have any sites where users are connecting using Macs as their PC? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Using UNIVERSE Triggers for MYSQL?
Hi Ara, We have used UniVerse triggers to replicate UniVerse tables to Microsoft SQL Server, MySQL, and Oracle. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of ARAMAIES BAGHDASRAIAN Sent: Tuesday, March 23, 2010 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] Using UNIVERSE Triggers for MYSQL? Good day, I would like to learn on Universe Triggers for MYSQL. using Universe 10.3 . I have read the materials and there were issues on speed, dailiung to update if trigger fails, or Clearfile where the trigger does not get activated. Please let me know if you have used the Universe triggers in production environment to update MYSQL tables? Best regards, Ara ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] logging
Hi Steve, We've defined a simple interface to syslog() that is called from Basic with the priority, a message format, and four parameters. The C part: void SYSLOG(int priority, const char *message, const char *arg1, const char *arg2, const char *arg3, const char *arg4 ) { syslog( priority, message, arg1, arg2, arg3, arg4 ); } The Basic part: EQU LOG.WARNING TO 4 EQU LOG.USERTO 8 syslog = '$SYSLOG' priority = LOG.USER + LOG.WARNING call @syslog( priority, 'arg1 %s arg2 %s arg3 %s arg4 %s', arg1, arg2, arg3, arg4 ) We use grep for analysis. :) Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, March 17, 2010 12:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] logging Henry, I've got everything worked out Except actually writing to the log. My plan is to make a single canned routine that will take Label and Message. It needs to check/get the current debug level from somewhere (named common, control record, not sure). How are you writing? I think I am going to settle on rsyslog. I want to setup a central logging server to log first by date, then by host so I can keep logs clean using any number of tools. I was going to use syslog-ng, but: 1, i got advice not to replace aix's syslog, not necessary, just forward it to remote. 2, i was going to use centos in a vm, however it doesnt have an official syslog build (it may now, but centos is not my first choice) 3, rsyslog looks good, and is the default on ubuntu-server. A jeos vm fits into this role well, since it has almost no services enabled or installed. Just logging is all I want. What do you use for analysis? Splunk? LogMuncher? Regards, Steve Steve ___ 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 - Error Logging
We use syslog in UniData and UniVerse to log all kinds of application events. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, March 16, 2010 12:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD - Error Logging Nothing prevents us from using syslog right? Ive been thinking about logging a lot lately. Specifically, syslog-ng or rsyslog. Any unix db should log to syslog. ___ 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] Keep a running total in a listing
Such things were so simple in PI/open: SORT VOC @ID FMT 32L SIZE EVAL @1+SIZE;@ COL.HDG Running COL.SPCS ID.SUP Length @ID. (in Bytes) Running... # 3 3 $INCLUDE 5 8 % 4 12 4 16 ACCOUNTS 45 61 BASIC.HELP 49110 CREATE.WIDGET.FILE 1,184 1,294 DELETE.WIDGETS 755 2,049 DEVICES43 2,092 DEVLIST43 2,135 EDFS.HELP 47 2,182 EDITOPTIONS47 2,229 ENTER.WIDGETS 616 2,845 GUI.HELP 45 2,890 LIST.WIDGETS 1,070 3,960 MAP35 3,995 MODIFY.WIDGETS 578 4,573 PARTFILES 47 4,620 Perhaps someone knows of a similar trick for UniVerse. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, February 24, 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] Keep a running total in a listing George ED DICT BOOK_TITLES RUNNING_TOTAL This is a Type I Descriptor last compiled on 23/07/09 at 16:35. 20 lines long. : p 0001: I 0002: SUBR('RT','RUNNING_TOTAL',UNITS) 0003: MD0 0004: Run 0005: 10R 0006: S ED BLP RT 19 lines long. : p 0001: SUBROUTINE RT(ANS, WHICH, VALUE) 0002: COMMON /RT/ RT.NAMES,RT.VALUES 0003: 0004: IF @NI = 1 THEN 0005: RT.NAMES = '' 0006: RT.VALUES = '' 0007: END 0008: LOCATE WHICH IN RT.NAMES SETTING POS THEN 0009: TOTAL = RT.VALUESPOS 0010: END ELSE 0011: TOTAL = 0 0012: RT.NAMES-1 = WHICH 0013: POS = DCOUNT(RT.NAMES,@FM) 0014: END 0015: 0016: TOTAL += VALUE 0017: RT.VALUESPOS = TOTAL 0018: ANS = TOTAL 0019: RETURN LIST BOOK_TITLES RUNNING_TOTAL UNITS 04:37:46pm 23 Jul 2009 PAGE1 Key.. Run... Units 10 2222 11 23 1 12 30 7 13 35 5 14 41 6 15 46 5 16 47 1 17 49 2 18 52 3 Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 23 February 2010 3:07 PM To: U2 Users List Subject: [U2] Keep a running total in a listing How would you produce a running total column on a report? I've done this once before, and can not remember how I set it up. This is running UV 10 Ex. LIST SOMEFILE F1 @IDF1 1 2 2 5 3 8 4 11 What I want to do is: LIST SOMEFILE F1 TOTAL(F1) @IDF1 TOTAL 1 2 2 2 5 7 3 815 4 11 26 Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2705 - Release Date: 02/23/10 19:34:00 ___ 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] Keep a running total in a listing
Brian, Wow. It does work! Sorry. I should have tried it. Now I remember what it was that I was thinking of that doesn't work, but I won't bore you with the details. a) There are lots of things in UniVerse that are not documented, or documented in non-obvious places. b) It's kind of like a magic trick. Once you know the secret, it's like Duh!. c) I really doubt it's going to change. There are way too many things that are dependent on that behavior. Best regards, Henry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, February 24, 2010 10:15 AM To: 'U2 Users List' Subject: Re: [U2] Keep a running total in a listing Hi Henry Yes Universe supports the @1 approach but it's a) undocumented, b) non-obvious and c) could always change some day - okay not likely but it's not an 'official' feature or that's what I was told.. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: 24 February 2010 6:09 PM To: 'U2 Users List' Subject: Re: [U2] Keep a running total in a listing Such things were so simple in PI/open: SORT VOC @ID FMT 32L SIZE EVAL @1+SIZE;@ COL.HDG Running COL.SPCS ID.SUP Length @ID. (in Bytes) Running... # 3 3 $INCLUDE 5 8 % 4 12 4 16 ACCOUNTS 45 61 BASIC.HELP 49110 CREATE.WIDGET.FILE 1,184 1,294 DELETE.WIDGETS 755 2,049 DEVICES43 2,092 DEVLIST43 2,135 EDFS.HELP 47 2,182 EDITOPTIONS47 2,229 ENTER.WIDGETS 616 2,845 GUI.HELP 45 2,890 LIST.WIDGETS 1,070 3,960 MAP35 3,995 MODIFY.WIDGETS 578 4,573 PARTFILES 47 4,620 Perhaps someone knows of a similar trick for UniVerse. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Wednesday, February 24, 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] Keep a running total in a listing George ED DICT BOOK_TITLES RUNNING_TOTAL This is a Type I Descriptor last compiled on 23/07/09 at 16:35. 20 lines long. : p 0001: I 0002: SUBR('RT','RUNNING_TOTAL',UNITS) 0003: MD0 0004: Run 0005: 10R 0006: S ED BLP RT 19 lines long. : p 0001: SUBROUTINE RT(ANS, WHICH, VALUE) 0002: COMMON /RT/ RT.NAMES,RT.VALUES 0003: 0004: IF @NI = 1 THEN 0005: RT.NAMES = '' 0006: RT.VALUES = '' 0007: END 0008: LOCATE WHICH IN RT.NAMES SETTING POS THEN 0009: TOTAL = RT.VALUESPOS 0010: END ELSE 0011: TOTAL = 0 0012: RT.NAMES-1 = WHICH 0013: POS = DCOUNT(RT.NAMES,@FM) 0014: END 0015: 0016: TOTAL += VALUE 0017: RT.VALUESPOS = TOTAL 0018: ANS = TOTAL 0019: RETURN LIST BOOK_TITLES RUNNING_TOTAL UNITS 04:37:46pm 23 Jul 2009 PAGE1 Key.. Run... Units 10 2222 11 23 1 12 30 7 13 35 5 14 41 6 15 46 5 16 47 1 17 49 2 18 52 3 Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 23 February 2010 3:07 PM To: U2 Users List Subject: [U2] Keep a running total in a listing How would you produce a running total column on a report? I've done this once before, and can not remember how I set it up. This is running UV 10 Ex. LIST SOMEFILE F1 @IDF1 1 2 2 5 3 8 4 11 What I want to do is: LIST SOMEFILE F1 TOTAL(F1) @IDF1 TOTAL 1 2 2 2 5 7 3 815 4 11 26 Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733
Re: [U2] Keep a running total in a listing
Interestingly enough, it is for PI/open but not for UniVerse. The reason why this works is because in both PI/open and UniVerse the @n variables persist between successive evaluations of I-types. In PI/open, they are in a common block. I haven't studied the mechanism in UniVerse. Henry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Wednesday, February 24, 2010 10:51 AM To: U2 Users List Subject: Re: [U2] Keep a running total in a listing Both EVAL @1+item and EVAL @1+item;@ gave the same result. Is the ;@ required? How does this work? I used to using @1 in I descriptors to reference the first value, but how does this reference the previous value? Thanks -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Wednesday, February 24, 2010 1:47 PM To: 'U2 Users List' Subject: Re: [U2] Keep a running total in a listing Brian, Wow. It does work! Sorry. I should have tried it. ___ 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] Any Ideas
uvsh followed by the (cataloged) program works well for us. e.g.: C:\uvsh ZUSERS Input editing enabled for ALL input, starting in INSERT mode. UniVerse users: 1 (maximum: 2) Other processes: 1 No User | No User | No User | No User 488 NT AUTHO | 6332 | | Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave R Sent: Thursday, December 17, 2009 5:25 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Any Ideas I am looking for a command in Windows that will launch a UniVerse Basic Command. Dave R. eFax (815)4259364 ___ 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 Ubuntu
I've installed the UV PE edition on my Dell Latitude 2100n netbook running the desktop version of Ubuntu 9.10. There are a few things you have to do pre- and post-installation, but otherwise, it works great. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd Sent: Thursday, November 12, 2009 4:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV Ubuntu Does anyone on the list know if it is possible to run UV on Ubuntu server? If so, I would love to be able to discuss off-line. Thanks! Boyd Boyd Parks ___ 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 Ubuntu
10.3.3: http://www.rocketsoftware.com/u2/downloads Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Cypress Support Sent: Thursday, November 12, 2009 12:33 PM To: 'U2 Users List' Subject: Re: [U2] UV Ubuntu What version of UV PE did you use? Support: James F Thompson Senior Systems Analyst Cypress Business Solutions 678.494.9353 supp...@cypressesolutions.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Henry Unger Sent: Thursday, November 12, 2009 1:44 PM To: 'U2 Users List' Subject: Re: [U2] UV Ubuntu I've installed the UV PE edition on my Dell Latitude 2100n netbook running the desktop version of Ubuntu 9.10. There are a few things you have to do pre- and post-installation, but otherwise, it works great. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Parks, Boyd Sent: Thursday, November 12, 2009 4:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV Ubuntu Does anyone on the list know if it is possible to run UV on Ubuntu server? If so, I would love to be able to discuss off-line. Thanks! Boyd Boyd Parks ___ 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] U2 is now Rocket U2
Funny you should ask. Andy Youniss, Rocket's CEO, was asked the question of the origination of Rocket last night at dinner, and the short answer was that at the time 20 years ago, he liked it. Although it may feel retro to some, I disagree that it carries a negative connotation. One of the leading companies in the commercialization of space today, Space Exploration Technologies, uses the term in its material on http://www.spacex.com. In addition, NASA is a Rocket customer. The reason that rocketship has not been used in science fiction in decades is for decades it has been fact, not fiction. Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Wednesday, October 07, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] U2 is now Rocket U2 I wonder what is the marketing idea behind the name Rocket ? To me it invokes late 1950 - 1960's Sputnik/Apollo technology to an epoch when cars designs were made to look like rockets, when there was a hockey player nicknamed Maurice The Rocket Richard and people watched Flash Gordon on a black and white television. When I hear Rocket I think retro like a LP Player, a typewriter, a PDP-1. Wouldn't one want a software product to sound more state of the art ? Sci-fi hasn't used the term Rocketship in decades. Jacques ___ 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] Indexing
Yes indeed, however it was removed. Hopefully, it will reappear. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Clifton Oliver Sent: Monday, September 14, 2009 4:26 PM To: U2 Users List Subject: Re: [U2] Indexing I seem to recall that they added the CONCURRENT option to BUILD.INDEX several years back but didn't document it except in the patch file for that release. Does anyone else remember this? Regards, Clif -- W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com On Sep 9, 2009, at 2:43 , Dan Fitzgerald wrote: Building indices means exclusive locks on the file, i.e., downtime. The good news is that the builds are usually very quick. ___ 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][UX] @USERNO @LOGNAME/PID ;...
Call !GET.USERS. It's documented in the UniVerse BASIC manual and the UniVerse BASIC Reference manual. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes Sent: Friday, September 11, 2009 1:33 AM To: U2 Users List Subject: [U2] [UV][UX] @USERNO @LOGNAME/PID ;... Hi all, When I perform a READU ... LOCKED ... I can use the STATUS() to retrieve the USERNO which maintain the requested lock. Into BASIC, from a USERNO value, how to retrieve the @LOGNAME and the @PID ?? Any idea ? Manu ___ 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] Looking for an OCONV/ICONV
I don't recall anything built-in, but... Here is an I-type expression that will strip everything except hexadecimal notation characters from @RECORD: @RECORD; CONVERT('0123456789ABCDEF', '', @1); CONVERT(@2, '', @1) Change @RECORD to some other field as desired. If you really want to create an ICONV/OCONV function, you can do that too if you are using UniVerse. Something like this: FUNCTION U( STATUS, VALUE, TYPE ) IF TYPE THEN * ICONV() TEMP = CONVERT('0123456789ABCDEF', '', VALUE) RESULT = CONVERT(TEMP, '', VALUE) END ELSE * OCONV() RESULT = VALUE END STATUS = 0 RETURN (RESULT) END Catalog as $ and use as the conversion in the dictionary as U. Best regards, Henry Unger Hitech Systems, Inc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Thursday, September 03, 2009 11:43 AM To: U2 Users List Subject: [U2] Looking for an OCONV/ICONV Is there an OCONV/ICONV I could use to filter out characters invalid for an hexadecimal notation ? Ei anything other than 01234567890ABCDEF ? I had a cheat sheet for special ICONV/OCONV statements but I've seemed to have misplaced it. ___ 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] Passing varibles between processes
In theory, if you open a socket to a Unix file descriptor in a UniVerse program using a GCI function, and then PHANTOM a new process, that Unix file descriptor will still be open in the phantom. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, August 27, 2009 12:15 PM To: U2 Users List Subject: [U2] Passing varibles between processes ok. I'm toying with making a socket server I have program A, which receives the socket requests, then I want to fire off a phantom to process the socket when it comes in. How can I pass the SOCKET handle from the main program to the phantom process. Because it's a phantom, it gets a whole new workspace, and named commons won't do the job. This is on UV 10 / linux George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Telephony and U2
We do similar things in a U2 platform-independent server-centric form in order to support telephony operations in emergency (e.g. 9-1-1) communication centers. We generally use the PBX vendor's native API if it is platform-independent. Our most recent implementations use vendors' JTAPI interfaces with a small Java program, with which we communicate using UniVerse via an inter-process communication mechanism. In addition to JTAPI, we have done Avaya Definity using ASAI, Nortel Meridian, NEC, Matra using CSTA, and others. The busiest center running this application handles about 80,000 calls per day, although in theory it should be able to handle well over 1,000 calls per second, which is far greater than the capacity of most PBXes. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jim Sent: Wednesday, August 26, 2009 7:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] Telephony and U2 Importance: High Has anyone implemented Microsoft TAPI in a Universe application? Typical initial requirement: U2 program receives data identifying calling customer/person. U2 user sees customer(s) incoming call on screen, clicks to answer. Incoming phone number allows automatic U2 data display. More elaborate options are needed if the simple things are reliable. I'd be interested in developers who have done this or have already developed U2 software available. Specific user references to discuss their experience would be great. ___ 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] Help with encryption
Try MX0C. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of m3p Sent: Tuesday, August 11, 2009 12:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Help with encryption Hello all, The code below: RESULT = '' STATUS = DIGEST('MD5','THIS IS A TEST',1,RESULT) PRINT 'STATUS = ' : STATUS PRINT 'RESULT = ' : OCONV(RESULT,'MX') works fine, except... I keep getting binary data displayed, despite the OCONV(RESULT,'MX') Anyone have an idea how to turn the RESULT into a string of Hex characters? Replies are much appreciated, thanks. IT-Laure Hansen wrote: Does anyone know how to cause MD5 hashing in Universe? UV 10.2.3 on Win2003 server. I am hoping for a Basic command that I can run on a desired piece of data. Reading documentation so far hasn't helped, am I wanting to do something that is not available to me? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- View this message in context: http://www.nabble.com/Help-with-encryption-tp23508833p24924344.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV PE for Linux
I asked that very question of the U2 people last week. As I recall, the answer was sometime this month. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Little Sent: Monday, August 10, 2009 1:26 PM To: U2-Users@listserver.u2ug.org Subject: [U2] UV PE for LInux I don't see UniVerse PE for Linux available for download anymore. I seem to recall a few years ago when IBM pulled it until they could get some licensing issues ironed out. Does anyone have any further information on when it might become available again? Bob Little UniVerse Developer Market America Greensboro, NC 336-478-1694 ___ 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] 386 Conversion
I can't imagine why it wouldn't boot on a 486DX. Worth a try. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Results Sent: Friday, July 24, 2009 9:46 AM To: u2-users@listserver.u2ug.org Subject: [U2] 386 Conversion All, This is likely to go nowhere, as the client is cash constrained, but I have to ask... I have a client still running a 386 Pick implementation. The system died. The closest thing I have is a 486, but I don't believe I can simply put the harddrive in a 486 and get Pick to boot. (If I'm wrong, tell me). So, does anyone out there have the ability to take a 386 flavor Pick-formated PC harddrive and pull the data into something more modern (U2, QM, D3...)? If so, what would it cost? - Chuck 386 Reasons to Upgrade Barouch ___ 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] Error 4 22 from PHP exec of uv on AIX
Permissions, perhaps? Running it using syscalls might provide some clues. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Morrissey Sent: Friday, July 24, 2009 2:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Error 4 22 from PHP exec of uv on AIX This is a bit of a stumper (for me, anyway). I'm having issues trying to exec uv from PHP on AIX. Things work just fine in Windows (Apache or IIS) or Linux (Apache) so I know my PHP syntax is fine. On the AIX (5.2 uv 10.2.7) box: Using PHP, I can exec 'echo 1 + 2 | bc' and get 3 I can run this at the shell as user nobody: 'cd /u2/uv/HS.SALES; /u2/uv/bin/uv display 42' I can get a CGI script to return 'cd /u2/uv/HS.SALES; /u2/uv/bin/uv display 42' correctly With PHP, I can't exec ' /u2/uv/bin/uv display 42' (after a chdir). UV throws this error (into the Apache logs): An error has occurred during uniVerse initialization Please contact the system administrator Error code: 4 22 The codes translate into: 4. System V semaphores are probably not configured in the kernel. 22. (EINVAL) Invalid argument. Here are some examples of invalid arguments: dismounting a nonmounted device, mentioning an unknown signal in signal, reading or writing a file for which seek has generated a negative pointer. EINVAL is also set by math functions. Has anyone else bumped into this? IBM support suggested it might be an issue with SIGTTOU but this seems unlikely to me - especially for a one-line command. PHP is a bit outside their bailiwick. Thanks, Ross. ___ 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] Universe Retrieve
DATE() is not a constant, but rather a function that will return a different value each day. You can see the object code that is produced using VLIST and examine it for optimizations. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Thursday, July 16, 2009 8:39 AM To: U2 Users List Subject: [U2] Universe Retrieve Question: If you are doing a select statement and within the statement you have a eval phrase and this eval phrase contains all constants (ie, DATE() - 14), does Universe recalculate that constant value with each record iteration or is it smart enough to know that this is a constant value and therefore only calculates it once ? Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility 16/7/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ 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] Universe Retrieve
Hi Martin, I was under the impression that an EVAL calls the same compiler that an I-type does, and that any expression optimization would be done therein. Expanding beyond that, it would be interesting if the I-type compiler was able to detect that a particular expression does result in a constant value and flag the object code as not requiring repeated evaluation by the query processor. Here are some empirical results using UniVerse 10.2.7: TIMEIT 50 COUNT VOC WITH F1 = 'V' COUNT VOC WITH F1 = 'V' Elapsed 1.3006 TIMEIT 50 COUNT VOC WITH F1 = EVAL 'V' COUNT VOC WITH F1 = EVAL 'V' Elapsed 5.135 This suggests that the query processor does not detect that the result of the evaluation is a constant and optimize its execution. Best regards, Henry TIMEIT: sent = @SENTENCE rest = trimf(field(sent, ' ', 2, len(sent))) word = field(rest, ' ', 1) if word matches 0N then n = int(word) sent = trimf(field(rest, ' ', 2, len(rest))) end else n = 1 sent = rest end print sent t0 = time() for i = 1 to n execute sent capturing output next t1 = time() print 'Elapsed ' : t1 - t0 end Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, July 16, 2009 9:30 AM To: U2 Users List Subject: Re: [U2] Universe Retrieve Hi Henry, You can see the object code that is produced using VLIST and examine it for optimizations. The particular optimsiation that Barry is looking for would not show in the object code. For a truly constant I-type expression, the query procesor could evaluate it just once and store the result instead of doing it on every use. Although not common, such I-types do exist. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +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
Re: [U2] Universe Retrieve
Hi Martin, I did say not, so we are saying the same thing. I like that QM is smart about it. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, July 16, 2009 12:36 PM To: U2 Users List Subject: Re: [U2] Universe Retrieve Hi Henry, I was under the impression that an EVAL calls the same compiler that an I-type does, and that any expression optimization would be done therein. As far as I know, EVAL does indeed call the same compiler. As I think you realise, the point is that an I-type expression such as 1: I 2: SPACE(3) (which I have seen used to get differing column spacings) will compile to a pcode sequence that produces a string of three spaces. This does not tell us how the query processor will then go on to use it. A normal I-type expression, whether from the dictionary or from use of EVAL, would be executed for each occurrence of it in the report, typically once per record. In the case of my spacing expression above, the query processor would actually only need to evaluate the expression once and then drop it into the report as a constant item. I think that this is what the original poster was asking about. I have no idea whether UV does this (QM does). Your experiment seems to tell us. Here are some empirical results using UniVerse 10.2.7: TIMEIT 50 COUNT VOC WITH F1 = 'V' COUNT VOC WITH F1 = 'V' Elapsed 1.3006 TIMEIT 50 COUNT VOC WITH F1 = EVAL 'V' COUNT VOC WITH F1 = EVAL 'V' Elapsed 5.135 This suggests that the query processor does not detect that the result of the evaluation is a constant and optimize its execution. No, I think that this is actually showing the opposite. The query was considerably faster where your test was a simple literal WITH F1 = 'V' whereas the EVAL expression added a further four seconds to your query. If the query processor detected that EVAL 'V' was a constant and optimised it I would expect both queries to take the same time. It does look as though it is evaluating the expression for every record. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +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
Re: [U2] Universe Retrieve
Good point, Andy. I had considered that, but guessed that it would not be a significant factor. Just in case, I created a file with a million records, and reran the tests. Here are the results: COUNT TESTFILE WITH F1 = 'V' Elapsed 7.4796 COUNT TESTFILE WITH F1 = EVAL 'V' Elapsed 23.2558 Seems pretty consistent with the earlier tests. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of andy baum Sent: Thursday, July 16, 2009 2:52 PM To: U2 Users List Subject: Re: [U2] Universe Retrieve Henry, EVAL compiles the expression and writes the result into the dictionary, runs the query and then deletes the dictionary item. For your test to be valid you would need to ignore the overheads of the compile, write to and delete from dictionary which in your example are significant compared to the number of records counted. You could probably get more accurate results by choosing an example that runs against a file with millions of records. Cheers, Andy - Original Message From: Henry Unger hun...@hitech.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, 16 July, 2009 18:36:27 Subject: Re: [U2] Universe Retrieve Hi Martin, I was under the impression that an EVAL calls the same compiler that an I-type does, and that any expression optimization would be done therein. Expanding beyond that, it would be interesting if the I-type compiler was able to detect that a particular expression does result in a constant value and flag the object code as not requiring repeated evaluation by the query processor. Here are some empirical results using UniVerse 10.2.7: TIMEIT 50 COUNT VOC WITH F1 = 'V' COUNT VOC WITH F1 = 'V' Elapsed 1.3006 TIMEIT 50 COUNT VOC WITH F1 = EVAL 'V' COUNT VOC WITH F1 = EVAL 'V' Elapsed 5.135 This suggests that the query processor does not detect that the result of the evaluation is a constant and optimize its execution. Best regards, Henry TIMEIT: sent = @SENTENCE rest = trimf(field(sent, ' ', 2, len(sent))) word = field(rest, ' ', 1) if word matches 0N then n = int(word) sent = trimf(field(rest, ' ', 2, len(rest))) end else n = 1 sent = rest end print sent t0 = time() for i = 1 to n execute sent capturing output next t1 = time() print 'Elapsed ' : t1 - t0 end Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: Thursday, July 16, 2009 9:30 AM To: U2 Users List Subject: Re: [U2] Universe Retrieve Hi Henry, You can see the object code that is produced using VLIST and examine it for optimizations. The particular optimsiation that Barry is looking for would not show in the object code. For a truly constant I-type expression, the query procesor could evaluate it just once and store the result instead of doing it on every use. Although not common, such I-types do exist. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +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
Re: [U2] Simple Export to Excel
Let's not forget what the RS stands for. In addition, there were many applications that went far beyond anything contemplated by it, kind of like off-label uses for prescription drugs. Your mileage will vary. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.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, July 07, 2009 1:51 PM To: U2 Users List Subject: Re: [U2] Simple Export to Excel Got it. Thanks everyone. I didn't know that. I still think I'll stick with tab delimiters though. lol, standards are made to be broken :) We used to joke about the RS-232 'standard.' It was such a great standard because there were so many different ways to implement it. 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] Auto-updating of secondary indices.
Do the subroutines do anything that have temporal dependencies? That is, are the values dependent on anything other than @ID and @RECORD, such as an external value coming from somewhere? _ From: Ken Ford [mailto:ken.f...@firstmac.com.au] To: u2-users@listserver.u2ug.org [mailto:u2-us...@listserver.u2ug.org] Sent: Sun, 17 May 2009 19:15:20 -0700 Subject: [U2] Auto-updating of secondary indices. From my reading of the Universe documentation, secondary indices should be automatically updated. I have a case where a file has about 8 secondary indices, some of which are updated automatically, and some seem not to be. A complete rebuild is done on all these indices each night. There does not seem to be anything significantly different about the ones that don't update automatically. They are I-descriptors that call a subroutine, but others like these update automatically. Any suggestions? I am thinking I should delete the indices in question, recreate them, and rebuild them. Regards, Ken Ford Universe Software Engineer [cid:image001.gif@01C9D7B2.503A0520]http://www.firstmac.com.au/ Phone: (07) 3013 8686 Email: ken.f...@firstmac.com.aumailto:mark.b...@firstmac.com.au Web: www.firstmac.com.auhttp://www.firstmac.com.au/ ### ## This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. FirstMac Limited (ABN 59 094 145 963) (AFSL 290600) ### ## [demime 1.01d removed an attachment of type image/gif which had a name of image001.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help with encryption
We link over 300 C functions that we have written into UniVerse using its GCI. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G Sent: Tuesday, May 12, 2009 5:27 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Help with encryption From: Tom Whitmore We use gpg to provide a level of one-way encryption. It's not the best, but it is the only option we could find. Does Universe or Unidata have a way to link custom functions into the monitor? This would facilitate in-process execution of code directly from BASIC. For example in D3 we can link in MD5 encryption from an external C library and then run it using: success=%md5(valuein,valueout,options) or use common libraries like this: result=%curl(url,page,options) etc... Not many people use this functionality but the benefit is that a new process doesn't need to be created and destroyed on every execution, as is the case with something like this: EXECUTE SH -C gpg :PARAMS: CAPTURING OUT This functionality opens the door to all sorts of possibilities - allowing us to make use to a world full of function libraries when people here are always trying to reinvent the wheel with BASIC. Unfortunately because of geeky words like C, link, and monitor, this topic is hardly ever discussed. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services Visit PickWiki.com! Contribute! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.1.22; Dynamic File question
You can create the dynamic file with the desired size. From HELP CREATE.FILE: MINIMUM.MODULUS n This value is also the initial value of the modulo (sic) of the dynamic file. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: Thursday, April 23, 2009 11:21 AM To: .U2 List Subject: [U2] UV 10.1.22; Dynamic File question As I understand it, Dynamic files split single groups as you add records to the specific group. So, if you add a large number of records to a file that's properly sized, it will (potentially) split multiple times as you go along. If I know in advance that I'm adding a large number of records to a file, is there any way to force the file to grow in advance? If it were a static file, I'd simply resize it to a new guesstimated modulo. Since it's dynamic, I don't see any way to do this other than to convert it to back to a static file, then resize it to a dynamic file with a minium modulus. It seems as though there must be a better way... Thanks. -- Allen Egerton aegerton at pobox dot com PGP Key ID 0x8EA57261 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV to SAP migration disaster
Really. From whom did you hear that? Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Laurie Blain Sent: Monday, April 20, 2009 9:29 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV to SAP migration disaster I heard that IBM bought Unidata and Universe to kill them off. To their surprise many of us are refusing to let the U2 die. Laurie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 Users Digest V1 #2599
The issue is that if you send a 1024 byte message through a TCP socket, you may eventually get 1024 bytes out the other end, but you may not get them all at once. The message may be broken up into lots of pieces, i.e. if you do a read(), you may get 1024 bytes, or you may get a lot less, and have to read() again. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, April 09, 2009 4:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: U2 Users Digest V1 #2599 Kevin, aren't you describing UDP communication, not TCP? Packets can be fragged and move through any number of different channels w/ UDP, but they're reassembled as a part of being received through TCP. If you sent a 1024 packet over UDP I would expect exactly what you've stated. Send a 1024 packet through TCP and I'd expect 1024 to arrive, and in order, as long as there's no failure. Of course, failures can occur with any protocol, even those that self-negotiate, so timeouts, dropouts, disconnects, and other failures have to be addressed in the implementation. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Does anybody have a hot backup server?
There are quite a few ways to get there, depending on facilities. 1) If you have fiber connecting the sites, then simply mirror the drives, or, if using an array, mirror two arrays using built-in operating system functions. 2) You can do mirroring at the volume level using a number of third party products, such as Veritas Volume Replicator. 3) You can use rsync with a cron job. It is really efficient as it only sends deltas. 4) You can use the IBM U2 publish/subscribe facilities. 5) We have been implementing hot backup servers using the DBMS (Prime INFORMATION, PI/open, and UniVerse) using triggers to perform asynchronous updates for about 20 years now, keeping the data up to date within a few seconds. It was really efficient in PI/open, but requires a lot of horsepower in UniVerse due to the trigger implementation in UniVerse. Regarding options 4 and 5, I don't recall the particulars of the licensing, but in theory you could have a two user U2 license on the backup site, and switch to a cold backup of the primary license on the backup system if you ever need to use it. From what I remember, cold backup licenses are not chargeable. I'd have a conversation with IBM about it. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Powell Sent: Wednesday, March 18, 2009 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] Does anybody have a hot backup server? I am trying to put together a backup strategy that involves keeping a standby server within two data hours of the primary. The idea is to be able to have users log into the backup server and keep the business running in the event of a crash. I'd like to hear what solutions others have found for this. I've been trying to contact IBM for the last 6 months but they haven't answered and my ERP vendor doesn't know how to do this. Any ideas are appreciated. TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML Escape function
I don't know if there is one, but, for text nodes in XML documents, you could do: value = change( value, '', 'amp;' ) value = change( value, '', 'lt;' ) value = change( value, '', 'gt;' ) value = change( value, '#xD', '#xD;' ) according to RFC 3076: Text Nodes - the string value, except all ampersands are replaced by amp;, all open angle brackets () are replaced by lt;, all closing angle brackets () are replaced by gt;, and all #xD characters are replaced by #xD;. Other node types, notably attribute nodes, have other requirements that differ from the above. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Ben Souther Sent: Wednesday, February 25, 2009 12:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] XML Escape function Years ago, I thought I saw an XML escape function in Unibasic but I can't seem to find it now. I thought it was mentioned in the Unidata Extensions PDF but I'm not able to find it. Does anyone know if such a function exists? Thanks, -Ben --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV 10.2
It means that UniVerse is unable to perform a memory allocation from the per-user shared memory segment of the requested size for that user. Printer memory is a euphemism. This is sometimes caused by memory leaks in UniVerse. Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jpb-u2ug Sent: Thursday, October 16, 2008 3:23 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV 10.2 Anybody know what it means when your program goes into a break condition and it says: Printer memory out of space Or something like that, and not doing anything with a printer. We are processing several hundred thousand records but not any print files. Jerry Banker Senior Programmer Analyst IBM Certified Solutions Expert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PI/Open on UNIX problem
Check the permissions on /var/tmp. Programs such as trace, tusc, and truss are useful for tracking down such problems. On my system, this is what happens (edited for brevity): open(/var/tmp/aaa_8ai91, O_WRONLY|O_CREAT|O_TRUNC, 0666) = 12 write(12, p w d , 4)= 4 write(12, \n e c h o $ ?/ v.., 28) = 28 close(12) = 0 fork() open(/var/tmp/baaa9ai91, O_RDONLY)= 12 read(12, 0\n, 2048) = 2 close(12) = 0 unlink(/var/tmp/aaa_8ai91)= 0 unlink(/var/tmp/baaa9ai91)= 0 Henry Henry P. Unger Hitech Systems, Inc. [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: Saturday, February 02, 2008 09:41 To: u2-users@listserver.u2ug.org Subject: [U2] PI/Open on UNIX problem I hope there are some old-timers on the list who will have some thoughts about a PI/Open problem one of my clients is having. In PI/Open you can define a verb to execute O/S level commands. Here's an example: LS 0001: V 0002: ls 0003: PR The PR in field 3 defines the verb as a primitive; i.e. an O/S level command. Problem is that when any user other than root executes the command (or any other primitive) it fails and puts this sort of warning into the PILOG file: # cat WARN.26835 [PI/open Rev. 3.7.6] [Copyright (c) 1992 Prime Computer, Inc.] [Copyright (c) 1994 VMark Software, Inc.] User name : jaftest PI User number : 12 Process ID : 10934 Hostname : dtcc271 ISYS pathname : /u/isys VOC pathname : ./VOC ACCOUNT path : /u/isys WARN.26835 logged at Thu Jan 31 17:01:38 2008 *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. *** Status 13 (OS: Permission denied), severity WARNING Detected by the DISKIO subsystem in fds_os_open at location 3. Called from fds_open at location 4. The warning implies a permissions problem; but all the components to the user account, including the VOC, have permissions of 777 (read/write/execute) for everyone. At the UNIX level there is no problem executing the command, so this is a PI/Open issue. The problem occurs across the board, in all accounts. I've set 777 permissions on everything in the isys directory as well. Feels like some sort of PI/Open security thing... If anyone has thoughts I'd sure appreciate it! Jeff Fitzgerald Fitzgerald Long, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/