Re: [U2] FW: Universe just quits

2009-07-23 Thread jpb-u2ug
It also cleans the session up and leaves a system message (050005) in the errlog file of the uv folder so you can track who has been leaving their sessions active. Jerry Banker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On

Re: [U2] Converting from mvBase to Universe

2009-07-23 Thread Dave Taylor
Hmm, Does this suggest that the UV (or other database) telnet server will be listening on each of these non-standard ports ( the std telnet listening port is 23? In UV, the telnet server port can be changed to any port no. other than 23, but only to one other port no. afaik. From that telnet

Re: [U2] Converting from mvBase to Universe

2009-07-23 Thread Martin Phillips
Hi Dave, afaik, mvBase is the only mv database that supports more than one telnet server port, and mvBase ties each telnet server port to one or more (a pool) of mvBase user connections, so this could be done on a one-to-one basis in mvBase. QM can do it too with the PORTMAP configuration

[U2] FW: Running total from UniData dict

2009-07-23 Thread Kebbon Irwin
I read this with great interest as I have an identical requirement. However, I use Unidata and this technique does not seem to work, in either ECLTYPE. Does anybody have a UDT solution? Cheers, Kebbon From: bernard.lu...@pentanasolutions.com To: u2-users@listserver.u2ug.org Date: Tue,

Re: [U2] Converting from mvBase to Universe

2009-07-23 Thread Dave Taylor
Hi Martin, Thankyou, that's good to know! Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.com - Original Message - From: Martin

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Martin Phillips
Hi Kebbon, I read this with great interest as I have an identical requirement. However, I use Unidata and this technique does not seem to work, in either ECLTYPE. Does anybody have a UDT solution? 0001: I 0002: @1...@record8 0003: MD2 0004: RUNNING TOT 0005: 10R I was quite surprised that

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Edward Brown
Don't have a good answer for this, but one hacky way would be to call a program passing the value to be accumulated which in turn maintains a named common variable. Only problem would be knowing when to reset it... Ed -Original Message- From: u2-users-boun...@listserver.u2ug.org

Re: [U2] FW: Universe just quits

2009-07-23 Thread Oaks, Harold
David, Henry: In my original testiing it seemed ineffective, with the following occurring if running our menu program in my testing: Your program has aborted from the application Please contact your system administrator Enter Q to log out or any key to continue= Just hitting the Enter key

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Charles Stevenson
Yes, Kebbon. Years ago, I hit this difference when contemplating a PI to UD migration. My fix isn't not very pretty to read, but it made conversion easier. If I didn't have the construct to convert, I don't know that I would use it, except that it's a nice bit of functionality. Off the

Re: [U2] Performance reports on 4 Terabyte files vs Distributed Files

2009-07-23 Thread Baker Hughes
Thanks Ross and Tony for your insights. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread David A. Green
Here is what I use. Maybe someone will add it to pikwiki for me. SUBROUTINE RUNNING_TOTAL(CUR.TOT, AM.PTR, AMT, RESET.DATA) * RUNNING_TOTAL Keeps a Running Total for Reports * by David A. Green -- 9/12/01 * www.DAGConsulting.com (480) 813-1725 * * AM.PTR for

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Brian Leach
Hi Similar to Charles' but not exactly the same, this was for uv (clearer than using @n) but should work for UDT as well: 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)

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Charles Stevenson
This it's ilk have always been an Undocumented Feature in both PI UV. 001: I 002: @1...@record8 If it ever stops working, The pitchforks are coming out. Recent versions of the documentation have added a bit of a disclaimer, rather than embracing the feature: Note: If you use @ in the first

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Martin Phillips
Hi Chuck, I take it QM does not support this use of the @n buffers, then? If I may change the subject slightly, how about nested compound I-descriptors? We have the @n variables but they are local to the specific I-type expression and hence don't persist from one evaluation to the next. We

[U2] I-descriptor @n techniques. ( was: Running total from UniData dict)

2009-07-23 Thread Charles Stevenson
David's Brian's running total subroutine are fine specific solutions to the particular unidata question, but for the record there are oh-so-many more things that you can do by this UV technique of referencing previous values. Here is an example of comparing a preveious record to the current

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Charles Stevenson
As long as we're on the subject, how about a running average? [running average] = [running total] / [number of items so far] @NI is the item counter as the LIST command proceeds. Using any of the methods discussed so far to get the running total, divide by @NI: DICT ORDER.DETAIL RUNAVG

Re: [U2] Universe just quits

2009-07-23 Thread Oaks, Harold
Ross: Interesting idea! I will try it both ways and see which is faster. Thanks so much- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, July 22, 2009 6:42 PM To: U2 Users List

Re: [U2] FW: Running total from UniData dict

2009-07-23 Thread Kebbon Irwin
Thanks all. I agree that it would be really handy if the UniVerse technique worked in UniData, but it is hardly surprising that it doesn't. It is equally surprising that an alternative is not available, but, then again, why haven't I felt the absence of such a function more keenly in the 17

Re: [U2] FW: Universe just quits

2009-07-23 Thread Hona, David
Harold, You can define the global (or default) value for AUTOLOGOUT by creating a UV.LOGIN paragraph in the VOC file in the UV account. The UV.LOGIN paragraph gets executed before the LOGIN paragraph. This merely enforces a default autologout value, for all UV sessions system-wide. It isn't

[U2] [Fwd: Re: FW: Running total from UniData dict]

2009-07-23 Thread Bill Haskett
Unfortunately, in UD the @ITEM.COUNT calculates values for LIST only. Therefore, if you do a SORT the 1st item listed may have an item count of 5675, the second listed might be 352, etc. Thus, it's very hard to figure out when you're starting the list in order to initialize the named

Re: [U2] Performance reports on 4 Terabyte files vs Distributed Files

2009-07-23 Thread Symeon Breen
I have a customer with files at the 600 gig level, we did not go the 64 bit route (for various reasons) but made the files dynamic (this is on udt where dynamic files are held in a directory with separate data blocks as files so you do not get a file over 2 gig). Write performance is fine as it