[U2] Re: U2 Users Digest V1 #896

2005-10-25 Thread Russ DeWitt
I will be out of the office on business, Monday 10/24/2005 thru Wednesday 10/26/2005. During this time I will not have access to my email. If you need to contact me, please call me on my cell phone. Thanks, Russ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please

Re: [U2] U2 SQL cache

2005-10-25 Thread u2
[EMAIL PROTECTED] wrote: I'm only a novice when it comes to SQL/RDBMS so forgive me if I sound clueless here. I'm considering recommending UniData as our next MV platform, and have been asked this question: Does UniData do 'result caching' or 'query caching'? Umm ... this is a catch 22

RE: [U2] UniData and multi-core chips.

2005-10-25 Thread John Jenkins
UniData and UniVerse both work file on multi-processor systems - they let the O/S deal with the hardware and just deal with the O/S.. A point of note - each LPAR is to all intents and purposes a separate server - so if you have UniData installed in separate LPARs you need separate UniData

RE: [U2] UniData and multi-core chips.

2005-10-25 Thread James.E.Hogan
When you start up, in the case of a dual/quad-processor, my understanding is that process is 'bound' to whatever CPU the OS kicked it off on... So, in theory, you do get some advantage of multiple processors, but the load is not dynamically balanced based on usage. Therefore, if all your heavy

RE: [U2] Creating Multiple page RTF documents

2005-10-25 Thread Maresh, Mel
I did something similar a few years and just created the source documents in Word with embedded tokens to be replaced dynamically by information from the database. The documents were then saved in .rtf format. Thus page soft breaks were handled by Word and, as I recall, Word would

[U2] NESTING EVAL

2005-10-25 Thread Kevin Michaelsen
Can I nest when using the EVAL command. Here is my statement that doesn't work. Do I need to put extra quotes somewhere or do I need to put brackets somewhere or is it not possible? LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS = Y) THEN EVAL IF(H.HCG.AWARDED.ALL 0) THEN 1 ELSE 0 ELSE 0 Any

RE: [U2] NESTING EVAL

2005-10-25 Thread DAWES, Ray
I would think that you do that as just one EVAL - remove the second EVAL. Ray -Original Message- From: Kevin Michaelsen [mailto:[EMAIL PROTECTED] Sent: 25 October 2005 16:01 To: u2-users@listserver.u2ug.org Subject: [U2] NESTING EVAL Can I nest when using the EVAL command. Here is my

[U2] Running Totals Universe

2005-10-25 Thread Anthony Dzikiewicz
Is there a way to display a running total in Universe within LIST RECORD... ? I am looking thru the docs and I came across TRANSPORT. At first, it looked like the ticket. After giving it a try, I have come to the conclusion that it is not. Then I started to wonder what TRANSPORT would

RE: [U2] NESTING EVAL

2005-10-25 Thread rbl000
You don't nest EVAL's, you nest IF's. I would rewrite your expression for clarity this way: LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS NE Y) THEN 0 ELSE IF(H.HCG.AWARDED.ALL 0) THEN 1 ELSE 0 Or perhaps: LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS = Y) * (H.HCG.AWARDED.ALL 0) THEN 1 ELSE

Re: [U2] U2 SQL cache

2005-10-25 Thread Don Kibbey
Be carefull how you explain that to the unwashed masses. I can just see the typical PHB exclaiming that UV/UD does not have this feature, therefore it must be inferior! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] File index problem on Unidata

2005-10-25 Thread Kevin Yoders
Hello all, I have a client that migrated from True64 to AIX a few weeks ago (I wasn't involved with the migration). They are currently having a problem with an index corruption on a static file. Unidata will not allow me to do a LIST, LIST.INDEX, DELETE.INDEX, or anything else I've tried

[U2] [OT] BREAKING NEWS

2005-10-25 Thread Richard Taylor
Rich Taylor is back in the office. For all my fans that breathlessly awaited the next automatic response...Sorry folks, forgot to set the exceptions list Rich Taylor | Senior Programmer/Analyst| VERTIS 250 W. Pratt Street | Baltimore, MD 21201 P 410.361.8688 | F 410.528.0319 [EMAIL

RE: [U2] NESTING EVAL

2005-10-25 Thread Ray Wurlod
Nested EVAL is not supported. However, nested IF is supported, at least to a certain level of complexity. LIST CS.2005 TOTAL EVAL IF (H.CS.NEXT.CLASS = 'Y') THEN IF(H.HCG.AWARDED.ALL 0) THEN 1 ELSE 0 ELSE 0 Or, even easier, since 1 is true and 0 is false: LIST CS.2005 TOTAL EVAL

Re: [U2] Running Totals Universe

2005-10-25 Thread Ray Wurlod
Running totals happen automatically at breakpoints on any field for which the field modifier TOTAL is specified. So one technique would be to BREAK.ON @ID DET.SUP You can also create EVAL expressions or I-descriptor expressions that keep a running total and display same. Here you can make use

RE: [U2] [OT] BREAKING NEWS

2005-10-25 Thread Caryl Lange
We missed you so...:) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Tuesday, October 25, 2005 1:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] [OT] BREAKING NEWS Rich Taylor is back in the office. For all my fans that

Re: [U2] U2 SQL cache

2005-10-25 Thread Anthony W. Youngman
In message [EMAIL PROTECTED], Don Kibbey [EMAIL PROTECTED] writes Be carefull how you explain that to the unwashed masses. I can just see the typical PHB exclaiming that UV/UD does not have this feature, therefore it must be inferior! That's why I thought quite hard about how to word it.

RE: [U2] File index problem on Unidata

2005-10-25 Thread colin.alfke
Make sure you're the only one accessing the file. Remove the X_filename file at the OS level. Copy another X_filename2 to X_filename (if you don't have a handy one just create an index on a small file. Then your DELETE.INDEX should work and you can re-create the index. Hht Colin Alfke Calgary

[U2] submitRequest

2005-10-25 Thread Barry Rogen
I realize as I type this that I may be asking a very general question to a scenario that may in fact be very case specific, but I am quite stumped and hope that some light can be shed on my dilema. EnvironmentUniVerse 10.0.19 on HPUX 11.0 I boldy

Re: [U2] File index problem on Unidata

2005-10-25 Thread Doug Miller
In the past when we had problems like this, we would create a small index on a file somewhere else. We would then copy the X_file to the appropriate name and location of the broken one. (There by substituting it temporarily) At that point you can do your DELETE.INDEX file ALL We (S7)

RE: [U2] Running Totals Universe

2005-10-25 Thread Tom Dodds
If you set up an I-Type that calls a subroutine with a named common where you keep adding the field you want the running total on into the named common variable and use the named common value as your answer it will give you a running total. 0001: I 0002: SUBR(RUNBABY,ANS) ... 0001: SUBROUTINE

RE: [U2] [OT] BREAKING NEWS

2005-10-25 Thread karlp
quote who=Caryl Lange We missed you so...:) ... but our aim will get better . . . -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Richard Taylor Sent: Tuesday, October 25, 2005 1:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] [OT] BREAKING

Re: [U2] File index problem on Unidata

2005-10-25 Thread Manuel Owens
Kevin, When we completed our migration from True64 to AIX we had the same problem. I had to delete all of the indexes and then rebuild them. First check to be sure that the index file is present where the VOC indicates it should be. If the file is there try deleting it at the system level

[U2] SIGPIPE Error on Universe

2005-10-25 Thread Peter S. Goldberger
Looking for help in clearing following error on printers (shows in LISTPEQS on several printers) ***Error: usd child received SIGPIPE signal. (10) Thanks in advance --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] [OT] BREAKING NEWS

2005-10-25 Thread Tony Gravagno
Rich Taylor is back in the office. For all my fans that breathlessly awaited the next automatic response...Sorry folks, forgot to set the exceptions list We don't need you anymore Richard, you've been replaced. We're now being comforted by frequent OoO notices from Russ DeWitt. 8^\ I'm

RE: [U2] U2 SQL cache

2005-10-25 Thread Allen E. Elwood
Interesting thought... I have my own TCL manager which is full screen editor/tcl manager and saves the commands to a file with the Logon*Account as the ID. That could be considered caching inquiry requests. The .L at tcl is caching inquiry requests, and you can save them to file (with a few

RE: [U2] [OT] BREAKING NEWS

2005-10-25 Thread Scott Ballinger
[snip] My solution is simply to filter any mail that contains text like out of office. Unfortunately I miss all the wonderful discussions people have about other people being out of the office... which will now include this one. Or with a name like tronic5... Oh, wrong list! ;) /Scott Ballinger

RE: [U2] NESTING EVAL

2005-10-25 Thread David Knight
Not being an expert on EVAL, I would put all the IF THEN ELSE etc into a dictionary item. Would that be simpler? -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of rbl000 Sent: Wednesday, 26 October 2005 3:51 AM To:

RE: [U2] UniData and multi-core chips.

2005-10-25 Thread David Wolverton
For Windows the processes float? Interesting!! I was just reporting what we were told eons ago -- that Processes were bound to a CPU on on startup on a Windows MultiProcessor... If that's not the case, even better ... Information in this area is hard to come by -- any authoritative information