Re: [U2] Global Catalog: Universe vs. Unidata

2012-03-09 Thread Charles Stevenson
The concept is similar, but there's an additional step. See UV 11.1 Administering Universe pdF, Chapter 18, & UniAdmin pdf, Chapter 16, Managing Catalog Shared Menu. Most UV shops in my experience don't bother with it, but I think it's a good tool and not difficult to master. cds On 3/9/20

Re: [U2] FYI - Another UV shop going away...

2012-02-04 Thread Charles Stevenson
Lab Force was my own intro to PI & MV. 1981-83. When I started the office was 2 adjacent suites in the Dallas Best Western Hotel next to Love Field. The room air conditioner just barely handled the Prime 400. Jerry advertized for someone with lab experience & who knew Fortran. My lab experienc

u2-users@listserver.u2ug.org

2011-11-29 Thread Charles Stevenson
You can also get elapsed time by subtracting that ID date-time stamp from the os's date-time-modified stamp, which is when the job ended. (if the job writes to the &PH& log as it ends.) On 11/29/2011 4:01 PM, John Thompson wrote: Yep... need more sleep. Thanks. On Tue, Nov 29, 2011 at 4:58 P

Re: [U2] [UV] Suppress "not found" in RetrieVe

2011-11-16 Thread Charles Stevenson
That has been a longstanding UV enhancement request. I don't understand what their aversion is. You can surround the select with HUSH ON, HUSH OFF. Make sure VOC HUSH <4> contains a "K" for "Keep select list active". Example: PA or in a pgm: SELECT VOC CMDS = "SELECT VOC

Re: [U2] Using 'MATCH'

2011-11-04 Thread Charles Stevenson
case LOCATE) for the job always helps! On 01/11/2011 15:05, Charles Stevenson wrote: What Wol & George Smith said. MATCH's raison d'etre is _PATTERN_ matching. That means: (a) MATCH is relatively expensive to use for comparing simple literals. (b) For MATCH, you need to enclose

Re: [U2] Using 'MATCH'

2011-11-01 Thread Charles Stevenson
What Wol & George Smith said. MATCH's raison d'etre is _PATTERN_ matching. That means: (a) MATCH is relatively expensive to use for comparing simple literals. (b) For MATCH, you need to enclose the pattern's literals in embedded quotes to ensure that it is not interpreted as a pattern. Per Wo

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-30 Thread Charles Stevenson
I am not sure where the locks are on the file system, but I wonder if Dummy already existed before you edited, whether this would be different. Also it would be worth test the difference of using READL and READU. David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-29 Thread Charles Stevenson
kvia WRITE or DELETEwould show up at the 3rd section of LIST.READU EVERY, even as the typical READU (or FILELOCK, RECORDLOCKU) does. The original test was request was this: On 10/24/2011 4:11 PM, Charles Stevenson wrote: UV 10.2.10 on Windows is behaving differently from what I recall. Ar

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-26 Thread Charles Stevenson
On 10/26/2011 7:45 AM, Robert Porter wrote: Accountants... How about a ER doc waiting on lab results for cardiac enzymes? I can hear it now: "Sorry Doc, something else locked the record. Your patient's test request was skipped so we could implement a trivial solution that was suggested for dead

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-25 Thread Charles Stevenson
While Will's articledoes give a good, clear example of a deadly embrace, and remediating faulty code is not trivial, the solution is conceptually trivial and it is exactly the LOCKED clause that saves us. If you write new code, deadlocks are easy to prevent. Testing is non-trivial. It generall

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-25 Thread Charles Stevenson
nation, but you can't avoid deadlocks with LOCKED clauses. Maybe what you meant was something like "You can try to think of some strategy to deal with them when they occur." -Original Message- From: Charles Stevenson To: U2 Users List Sent: Tue, Oct 25, 2011 4:15 pm Subje

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-25 Thread Charles Stevenson
But if there is explicit READUs in both processes, that one of them will fail in 20 minutes? -Original Message- From: Charles Stevenson To: U2 Users List Sent: Tue, Oct 25, 2011 3:12 pm Subject: Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explic

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-25 Thread Charles Stevenson
On 10/24/2011 4:11 PM, Charles Stevenson wrote: --- [snip] --- I have not yet explored what the deadlock daemon does. Deadlock daemon ignores these WRITEs w/o explicit locking before hand. I ran these 2 pgms simultaneously so that they both tried to lock or write the lock that the other held

Re: [U2] UniBasic Question

2011-10-25 Thread Charles Stevenson
benefit of the index is washed out. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Tuesday, October 25, 2011 2:39 PM To: U2 Users List Subject: Re: [U2] UniBasic Question True on UV, too. Compare

Re: [U2] UniBasic Question

2011-10-25 Thread Charles Stevenson
that in a long time. On Tue, Oct 25, 2011 at 5:42 PM, Woodward, Bob wrote: Add a second selection criteria and the benefit of the index is washed out. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Steve

Re: [U2] UniBasic Question

2011-10-25 Thread Charles Stevenson
True on UV, too. Compare output of these using EXPLAIN keyword: LIST FILE WITH indexed_field = "soemthing" EXPLAIN LIST FILE WITH indexed_field = "soemthing" EXPLAIN NO.INDEX Or forget EXPLAIN, but do it with a large file and notice the speed differnce. On 10/25/2011 4:29 PM, charles_shaf..

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-25 Thread Charles Stevenson
Yes. Today, deadly embraces can be avoided via LOCKED clauses. In days of yore, Pick's READU syntax did not allow a LOCKED clause. BTW, I advocate 2 Programming Standards: 1. If a lock is taken (READU, RECORDLOCKU, FILELOCK, etc.), a LOCKED clause must be present. 2. A lock must be se

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-24 Thread Charles Stevenson
riginal Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, October 24, 2011 2:12 PM To: U2 Users List Subject: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu. UV 10.2.10 on Win

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-24 Thread Charles Stevenson
Maybe UD is where I am remembering this from. On 10/24/2011 4:19 PM, Dave Davis wrote: I don't know about UV but in UD, LIST.QUEUE shows waiters. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stev

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-24 Thread Charles Stevenson
uld expect to see a LOCKED clause on the WRITE statement like there is on the READU. For that matter, I'd expect to see a WRITEU command as well and the standard WRITE to completely ignore locking. Just my guess, though. BobW -Original Message- From: u2-users-boun...@listserver.u2u

Re: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-24 Thread Charles Stevenson
un...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, October 24, 2011 2:12 PM To: U2 Users List Subject: [U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu. UV 10.2.10 on Windows is behavin

[U2] [UV] LIST.READU EVERY's "waiters" when there are writes w/o explicit readu.

2011-10-24 Thread Charles Stevenson
UV 10.2.10 on Windows is behaving differently from what I recall. Are my expectations out of line? Suppose Session A holds a readu lock; and Session B attempts a WRITE to same record withOUT!!! 1st explicitly getting the readu lock. Session B waits for Session A to release the lock before writi

[U2] NORMAL (was: SLOW)

2011-10-07 Thread Charles Stevenson
What is NORMAL? How do you benchmark your U2 system to determine what your "Normal" is? If there are a set of metrics already well-defined, then when there are complaints or when monitoring recent deliberate changes, you can then take a snapshot and throw it against "Normal". The more things

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread Charles Stevenson
My experience is a couple years old. FAST is a solid tool. Shoes for the cobbler's children. Automates IT. What a concept. But I added my own history component to FAST so I could see file trends over time. This trending history helped me take a system that was always crying for more resize

Re: [U2] I-type Subvalue question

2011-09-15 Thread Charles Stevenson
r 15, 2011 9:05 AM To: U2 Users List Subject: Re: [U2] I-type Subvalue question On 15/09/11 14:38, Charles Stevenson wrote: Allows you to reference this I-descriptor from another I-descriptor in the future. UV doesn't let you do that if there are multiple expressions separated by

Re: [U2] I-type Subvalue question

2011-09-15 Thread Charles Stevenson
. How do you point to the previous expression? @<-1> -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, September 15, 2011 9:05 AM To: U2 Users List Subject: Re: [U2] I-type Subvalue questio

Re: [U2] I-type Subvalue question

2011-09-15 Thread Charles Stevenson
Likewise, late in the day, but on UniVerse, to extract the (lowered) 2nd value, instead of: TRANS('ORDERS', ORDKEY, LINES, 'X')*_; @_*<1,1,2> do: TRANS('ORDERS', ORDKEY, LINES, 'X')<1,1,2> Reason: Allows you to reference this I-descriptor from another I-descriptor in the futur

[U2] SkyBot Scheduler. Was: Job scheduling in UniVerse

2011-09-13 Thread Charles Stevenson
Has anyone used "SkyBot Scheduler"? It's a commercial non-MV-based product we're considering for non-UV reasons. If we go that route, I will also schedule UV jobs under it, too, scripting as for cron or windows scheduler as others have written. On 9/13/2011 3:52 AM, Symeon Breen wrote: If you

Re: [U2] [UV] Adding a multi-vaue using SQL UPDATE

2011-09-13 Thread Charles Stevenson
None here. I've been lurking to hear the answer. Seems a reasonable request. Ask Rocket. On 9/13/2011 8:26 AM, Perry Taylor wrote: Hrm... no bites?? Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Ta

Re: [U2] Job scheduling in UniVerse

2011-09-13 Thread Charles Stevenson
Phantoms do not consume a UV license. Otherwise everything Glen says is right. What the others say about cron & windows scheduler is fine, too. There are a couple fancy commercial scheduling products built to run under UV, too, depending on how elaborate your needs are (multiple queues, prior

Re: [U2] Ardent programmers

2011-09-09 Thread Charles Stevenson
.. (borderline humor) -Original Message- From: Charles Stevenson I heard he designed and implemented the original Universe. He left a rather hefty manual. It was updated after his last visit. On 9/9/2011 8:23 AM, Glenn Sallis wrote: I guess he must be freelance. Am 09.09.2011 15:21, schrieb

Re: [U2] Ardent programmers

2011-09-09 Thread Charles Stevenson
I heard he designed and implemented the original Universe. He left a rather hefty manual. It was updated after his last visit. On 9/9/2011 8:23 AM, Glenn Sallis wrote: I guess he must be freelance. Am 09.09.2011 15:21, schrieb George Gallen: That JC programmer must work in a lot of placesb

Re: [U2] [UV] Cross-flavor code

2011-06-25 Thread Charles Stevenson
What Ed & Wols said. And there's another flavour-related gotcha with common (labeled or not) having to do with whether or not the common variables are considered "assigned", regardless of $OPTIONS or where compiled. For example, this will run differently in Pick & Ideal different flavoure

Re: [U2] [UV] Break and debug

2011-06-25 Thread Charles Stevenson
Dianne, Mark is right, but when he says "your VOC", the only thing that matters is the QUIT.KEY, INTR.KEY, SUSP.KEY in the particular VOC that you hit when you 1st enter UV. You can subsequently LOGTO anywhere else, or edit those original VOC records all you want, and none of that will ef

Re: [U2] Conversion Code for Date

2011-06-04 Thread Charles Stevenson
m.au > > 0007: dwamdby[", ",,2", "] U2 Users List Oct 2005 Subject: [U2] Date Conversion Codes From: Richard Lewis And did you know you can get that result without multiple conversions? Try: DYMD[4'',2'',2] instead of: DYMD[4,2,2]}

Re: [U2] Conversion Code for Date

2011-06-03 Thread Charles Stevenson
Tangentially, ICONV( '20110603', 'D' ) = '15860'(15860 is internal date for Jun 3, 2011.) ICONV( '110603', 'D' ) = '15860' OCONV('15860', 'DYMD[4,2,2]': @VM: 'MCN' ) = '20110603' OCONV('15860', 'DYMD[2,2,2]': @VM: 'MCN' ) = '110603' I went many years before discove

Re: [U2] uv 2 ud

2011-05-28 Thread Charles Stevenson
I concur with Rich completely. On 5/28/2011 4:51 AM, Richard A. Wilson wrote: I believe it would be quicker for you to pick up UV then converting to UD The little differences will take much more time to deal with. Rich ___ U2-Users mailing list U2-

Re: [U2] [UV] Emulate SQL MAX() function at TCL

2011-05-27 Thread Charles Stevenson
ly distributed -- isn't too taxing compared to the occasionally need for that max. Probably reasonable assumptions, all. cds On 5/27/2011 10:34 AM, Wols Lists wrote: On 27/05/11 14:33, Charles Stevenson wrote: I am going to assume we are talking about a HUGE file, otherwise efficiency wo

Re: [U2] [UV] Emulate SQL MAX() function at TCL

2011-05-27 Thread Charles Stevenson
I am going to assume we are talking about a HUGE file, otherwise efficiency wouldn't much matter. I don't know a GOOD way outside basic or sql to prevent a sort-selected list from being created. For humongous files, that may be painful. Here is a way, not a GOOD way, just a way. I just ca

Re: [U2] Why should we NOT upgrade to UV11.1.1 ?

2011-05-23 Thread Charles Stevenson
Many thanks for the update. On 5/19/2011 1:59 AM, Bob Witney wrote: This is just for info really and following on from a thread of last week: We tried to upgrade to Universe 11.1.0 at the weekend. The first time that we tried we had an unreadable file in the download that Rocket supplied to ou

Re: [U2] Why should we NOT upgrade to UV11.1 ?

2011-05-19 Thread Charles Stevenson
so this may, or may not be relevant. LIST.READU does not report a pid in 11.1.1. This is a "known" issue and is fixed in 11.1.3 I am told. How you go about finding any known issues, I have yet to establish. HTH Brett "Charles Stevenson" wrote in message news:<4dd

[U2] Why should we NOT upgrade to UV11.1.1 ?

2011-05-18 Thread Charles Stevenson
UV11.1 has been available for AIX for 7 month; for Linux only 3.. I don't know how widely used it is yet. I have not seen a rash of complaints about 11.1. We are currently on 10.2.10 / Windows and contemplating migrating to Linux. UV choices are: 10.3.9 & 11.1.1. We do not have a burning need

Re: [U2] serial #

2011-05-07 Thread Charles Stevenson
Also, uniAdmin > License > Update Serial # is listed. Hit "Cancel" No harm. On 5/7/2011 12:30 PM, Dan Fitzgerald wrote: Someone asked me the other day how they could determine their uv serial number. I didn't know, and can't find it when I RTFM on uvlictool. Anyone know? __

Re: [U2] in DICT - how to make this 'yes'.

2011-05-05 Thread Charles Stevenson
Chris, It just means that there isn't a dictionary item called "POLICY", or at least not one that is the same as it once was when the index was created. It's probably looking for DICT POLACCTRN_POSTED POLICY 01: D 02: 1 03: n/a 04: n/a 05: should have an "L" for left-justifie

Re: [U2] Verify all indexes

2011-05-05 Thread Charles Stevenson
Many releases ago we had suspect indexes, so I routinely retrieved the previous night's mirrored backup so I had a quiet copy of file and its indexes and checked integrity. It turned out to be fastest if I saved off the index somewhere, then rebuilt it, then compared the saved to the newly bu

Re: [U2] [UV] Marking New Index as Built

2011-05-05 Thread Charles Stevenson
So, Perry, what did you finally decide to do? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] [UV] Marking New Index as Built

2011-05-05 Thread Charles Stevenson
In the end it seems to me that Rocket needs to come up with a completely new strategy for building/rebuilding an index. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Thursday, April 28, 2011

Re: [U2] [UV] Marking New Index as Built

2011-04-28 Thread Charles Stevenson
That should work. And then you can write your own update program to back-populate the index w/o having to do a build at all. But if your & my connivings are true, then why doesn't RocketSQ give that to us as a concurrent build option? A few years ago they (as IBM) declared that 7x24 uptime

[U2] [UV] ICONV, OCONV --> STATUS() = 3 = "Successful conversion of possibly invalid data"

2010-02-05 Thread Charles Stevenson
For ICONV & OCONV the UV documentation says: The STATUS function reflects the result of the conversion: Value Description 0 The conversion is successful. 1 An invalid string is passed to the OCONV function; the original string is returned as the value of the conversio

Re: [U2] Resize Question

2010-02-05 Thread Charles Stevenson
Before you go too far down that path, make sure your sorting & selecting works like you want. Are you more familiar with Pick-style A- & S-items? If so, you realize how, if you put a correlative or a conversion into the wrong spot, your sorts and selection criteria are goofy. The same will ha

Re: [U2] [UV] table of mv-handling functions

2010-02-02 Thread Charles Stevenson
ly a subroutine version, not a function form of the vector equivalent: CALL !MATCHES( result.mv, string.mv, pattern.mv ) <==> result = ( string, pattern ) On 2/1/2010 1:02 PM, Rick Nuckolls wrote: I should have said "sysdesc.pdf". On Feb 1, 2010, at 9:50 AM, Charles St

[U2] [UV] table of mv-handling functions

2010-02-01 Thread Charles Stevenson
There is (used to be?) a very nice table of all the multivalue-handling functions, lining them up with their single-value equIvalents. It looks/looked something like: MV-handler function Single-valued equivalent --- CATS( X, Y ) ( X : Y ) GTS(

Re: [U2] PORT.STATUS affecting program

2009-12-08 Thread Charles Stevenson
Dan, I've seen something similar with very same port.status options where PORT.STATUS seemed to cause other uv telnet sessions to drop.. Maybe UV10.0 or earlier. I'm still not clear on whether you are ud or uv. It was during my most intensive use of the command ever. I did not pursue the bug, so

Re: [U2] Command logging in Universe 10.2.1

2009-10-23 Thread Charles Stevenson
Does windows have the equivalent to unix's "tee" command? I can tell you what I'd try on unix, because I don't think COMO will capture unix SH output. ("SH" for "shell" is UV's unix equivanent to "DOS" verb for windows.) I haven't used tee very much, but I *think* unix tee would capture stdo

Re: [U2] Connection Pooling Statement

2009-09-24 Thread Charles Stevenson
Exactly. It's been a while since I've been involved with RedBack, or been involved in the contracts, but webshares are paid for as part of RedBack, not UV or UD, aren't they? Dollars lost on the DB side are gained on the RedBack side. Since our Vendor De Jour owns both pieces, they don't m

Re: [U2] Connection Pooling Statement

2009-09-24 Thread Charles Stevenson
I'm missing something. We ran Redback without connection pooling. Is that an exception because it's a U2 product or were we in violation? Ross Ferris wrote: Doug, I fear that if you look at the terminology and description that (Rocket may change, but somehow I doubt it) use to describe a "co

Re: [U2] [UV] @Variables in Paragraph

2009-09-18 Thread Charles Stevenson
Let me change the subject from Rocket for a sec. It's always wise to listen when Mecki Foerhmann posts. A couple days he made some good points responding to something I'd written. He said: This reminds me of a guy I used to work with years ago. cds: See posts from July 8, 09 in u2-community

Re: [U2] Posted on Behalf of Susie Seigesmund

2009-09-18 Thread Charles Stevenson
I gotta admit it's fun watching Susie juggle all this with her new boss keeping quiet. Rock on, Susie. Oh dear, I feel another music pun coming on. Something about Rockettes to join Rocketman & U2. While we're a it let's ditch the U2UG Toucan for Buzz Lightyear, Master of the Univese.

Re: [U2] just a suggestion but ......

2009-09-18 Thread Charles Stevenson
I don't get it. Rocket is legally bound to say nothing, but the CEO is at U2 University. Silently? Oh, wait, no. He shared the keynote address and shared his vision with the attendees, . . . which would be . . . : _? Hang in there , Chuck. Chuck John, I'm working on talki

Re: [U2] Z_xxxxxxx not created

2009-09-17 Thread Charles Stevenson
How about D:\path...\ filling up, even just momentarilly? Are they monitoring for that? I don't know UD, but UV has UVTEMP to do something very similar with CAPTURING. Could process B get the message you describe, but it's really a downstream effect of process A, a different process indep

Re: [U2] Worst Case/Best Case

2009-09-17 Thread Charles Stevenson
Charlie Rubeor wrote: ... feels like getting traded from the Yankees to the Orioles. For those of you across the pond, think of being transferred from Chelsea to West Ham United. [snip] No offence was intended to West Ham United... so offence to Orioles is inferred? __

Re: [U2] GOOD NEWS From Susie

2009-09-16 Thread Charles Stevenson
Chuck, Impress upon Rocket the need for THEM to make a public statement. It's nice to hear news from you & from Susie, and I look forward to reading whatever you post, but, come on, Rocket! the new owners need to say something. Chuck All, I've been speaking to an executive at Rocket and mo

Re: [U2] [UV] @Variables in Paragraph

2009-09-16 Thread Charles Stevenson
Perry Taylor wrote: This is probaby one of those duh questions but... Is there a way in a paragraph to display the value of the supported @ variables? I.E. PA SELECT FILENAME WITH ... DISPLAY @SYSTEM.RETURN.CODE Not a 'duh' question, but answer: no. So I wrote an "ILPROMPT.DEF" utility ve

[U2] [UV] BUILD.INDEX CONCURRENT trustworthy? (was: Indexing)

2009-09-15 Thread Charles Stevenson
Are there any testimonials from anyone using it in production? We're like a flock of penguins waiting for the hungriest one to dive in first and not get eaten by seals. If there's no blood in the water, CONCURRENT is a welcome tool for high availability. Chuck jpb-u2ug wrote: I just tried it

Re: [U2] UV:basic readu lock promote to filelock when locktable is full !!

2009-09-07 Thread Charles Stevenson
Manu, 1. As to your specific question about figuring out how many locks your process or transaction owns, I don't know a quick function for that, but there is a little known "INTERNAL" keyword for LIST.READU (& PORT.STATUS). E.g., EXECUTE "LIST.READU USER nnn INTERNAL" CAPTURING XYZ then p

[U2] [Fwd: Re: Hmmmm...Learn something new every day!]

2009-09-04 Thread Charles Stevenson
Golly geewillikers, I do apologize for posting a serious reply, so close to the start of the US & Canadian 3-day Labor (Canadian: Labour) Day holiday weekend, but . . . Are you in INFORMATION flavour? UV 10.3 Basic Ref, pg 263: "In INFORMATION flavor accounts, the EXECUTE statement witho

Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-23 Thread Charles Stevenson
Bill, Yes, it sounds like a UV:UD difference, & yes, a UD deficiency. Unless UD-basic or maybe a switch in the VOC's V-item, or something else that can alter the default behaviour. I know there is something akin to uv flavours that affects how things run, "ECL-type" is it? See if the UD doc

Re: [U2] UD: Executing small part of subroutine code once from dictionary call

2009-08-22 Thread Charles Stevenson
An interesting note to this is I use a TCL shell written in BASIC; in fact, all of our application menus run in BASIC. Consequently, @DATE in the BASIC subroutine is always the same whenever I run the "SORT..." from the TCL shell. Bill, On UV -- I don't know about UD -- @date & @time are

Re: [U2] Performance counters

2009-08-04 Thread Charles Stevenson
You meant Windows' Performance Monitor, didn't you? The native UniAdmin one has been on my mind lately & I just umped. Sorry, can't help. cds. Brian, I'm not sure what you are asking. Are you saying when you start UniAdmin's Performance Monitor, then on it's menu choose Options:Configuration tha

Re: [U2] Performance counters

2009-08-04 Thread Charles Stevenson
Brian, I'm not sure what you are asking. Are you saying when you start UniAdmin's Performance Monitor, then on it's menu choose Options:Configuration that there are no parameters listed? Likewise if you click the plus button? Or are you saying the server side doesn't know what to do with the u

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

[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
This & it's ilk have always been an "Undocumented Feature" in both PI & UV. 001: I 002: @1...@record<8> 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

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 top

Re: [U2] More questions on indexing

2009-07-17 Thread Charles Stevenson
This cries for a ICONV / OCONV code: George Gallen wrote: In our case, we would also have to build a cross reference to all the 'F' VOC's whose actual filenames are different from their ID's, since we have a lot of longer filenames with truncated unix filenames. Or is there a system cross refer

Re: [U2] More questions on indexing

2009-07-17 Thread Charles Stevenson
One more thing that we do. We build a database of our indexes every night using a 'cron'. It does a find / \( -name 'idx001' -o -name 'X_*' \) at a UNIX level. UV's SET.INDEX INFORM acting on an active select list of F- & Q-pointers will give you somethiong similar. Contrary to syntax listed in

Re: [U2] SAVE-LIST [FILENAME] LISTNAME

2009-07-15 Thread Charles Stevenson
Cute. Just think what would have happened, if you had named your list "DATA.30" ! I can't think of a way to SAVE.LIST to a hashed file, other than 2 step: SAVE.LIST XYZ COPYI FROM &SAVEDLISTS& TO [hashed file] "XYZ" OVERWRITING DELETING HUSH Going the other direction, there are 2 w

Re: [U2] Trans() to a subroutine I descriptor

2009-07-14 Thread Charles Stevenson
0024: END ELSE 0025: TURNS = 0 0026: RETURN 0027: END 0028: IF AVG.INV # "0" AND NUM.PERIODS # "0" THEN 0029: TURNS = OCONV(ICONV(100*(TOT.SALES/AVG.INV),'MD0'),'MD2') 0030: END ELSE 0031: TURNS = 0 0032: END 0033: 0034: RETURN Anyone have any ideas? Charl

Re: [U2] Trans() to a subroutine I descriptor

2009-07-14 Thread Charles Stevenson
DAVID WADEMAN wrote: > Is there the ID of GM.SHF in GM.GMF file? If so then you could used: > >> ED DICT GM.GMF TURNS > 0001: I > 0002: SUBR('*CALC.TURNS',GMF.SHF.ID) Jeff's originally attempted TRA

Re: [U2] Trans() to a subroutine I descriptor

2009-07-14 Thread Charles Stevenson
Sorry, Jeff, you can't. Best you can do is: DICT GM.GMF TURNS 0001: I 0002: SUBR('*CALC.TURNS',SMF.LINK) 0003: 0004: TURNS 0005: 7R 0006: S I've always considered it a serious shortcoming. Theoretically it ought to be possible. It was a shortcoming for Prime, but UV & UD hav

Re: [U2] SQL Error / Trigger - Have to establish a lock first?

2009-07-13 Thread Charles Stevenson
Yes. Explicit READU or RECORDLOCKU before WRITE is always a good idea, but if I recall, a necessity for triggers. Said necessity for triggers may depend on how uvconfig ISOMODE is set, too. That I don't recall. If you do recordlocku, you should only hit the lock table in memory rather than th

Re: [U2] Calculation on multi-valued elements

2009-07-07 Thread Charles Stevenson
The semi-colon way of writing is more readable, but UV does not let you reference such an I-descriptor (as reusable code) from some future one. For example, next year you want to know how fast/slow certain programs run during certain times of the day. You'll want to use the RUN_TIME result withi

Re: [U2] Calculation on multi-valued elements

2009-07-07 Thread Charles Stevenson
As already stated, IFS, LTS, REUSE, and a bunch more are MultiValue Handling Functions documented in Universe Basic manual. Don't know where UD documents them. They can be called from I-descriptors. Unidata is similar, but I think you might need to call them from I-descriptors via SUBR(). Th

Re: [U2] Program Comments/Documentation/Notes/Revision History

2009-06-29 Thread Charles Stevenson
Dawn Wolthuis wrote: Just my two cents. cheers! --dawn How come Dawn's two cents are always worth more than my two cents? Don't answer that. All, I've found lurking on this whole thread informative & thought-provoking. Thanks. ___ U2-Users mai

Re: [U2] Mixed Case UV Basic Programming Standards.

2009-06-29 Thread Charles Stevenson
I started this thread and I thank those who have helped me think about it. Some good ideas there. But, hey guys, one of the thread's rules was: "2. NOT about GOTO. Take it outside." So if you don't stop, I will have to come down on this with my full authority. (My full authority consists

[U2] Mixed Case UV Basic Programming Standards.

2009-06-24 Thread Charles Stevenson
I don't like the way I use mixed case, so it tends to evolve. Not good, because consistency in programming style throughout an application makes for easier maintenance, & maintainability is the god of software quality. So I am wondering how others use mixed case. Do you capitalize/lower/mix ca

Re: [U2] [OT] STATUS() returning 4 digit uid, need to be 5 digits

2009-06-23 Thread Charles Stevenson
Here's a lead, not an answer. When we upgraded from 11.11 on HP Risc to 11.23 on HP Itanium, some of the permissions on files in /etc changed from rw-r--r-- to rw---. Owner remained root. That made a couple UV (not UD) utilities that relied on that unix info to yield up user counts stop

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Charles Stevenson
UV on HPUX. Disks were part of a huge SAN (vendor slips my mind at the moment) where our ap was just a small part of a mix of unix, windows, linux. I don't recall raid level. The SAN was administered by someone else. Tape backup was Legato. I really liked the idea of keeping the backups mirro

Re: [U2] FW: Valid Backup on Windows Universe

2009-06-23 Thread Charles Stevenson
Why do you think this? "The failure I see of this system is that even though the db is paused, it is not in a "safe" state for backup." Once you broke the mirror would it not be safe to backup that array?? The db is basically in "mid sentence". The commits are not atomic. If you restore

Re: [U2] LIST DICT.DICT

2009-05-18 Thread Charles Stevenson
One quick point is that this is one of the differences between Pick heritage & Prime heritage. See "Guide for Pick Users" in the UV doc set. If you were a Pickie, it helps UV make sense in a hurry. UV republished that guide after a long lapse, thanks to U2UG's pressure, iirc. For Primates, t

Re: [U2] Interest results on VOC file

2009-04-29 Thread Charles Stevenson
This I-descriptor or EVAL should help you: LIST VOC _ WITH EVAL "CONVERT( @AM:@VM:@SM:@TM, 'avst', @id )" # @ID _ ID.SUP EVAL "CONVERT( @AM:@VM:@SM:@TM, 'avst', @id )" (To be rigorous, char(247 thru 250) are also treated as system delimiters. You might test for them, too.) Is

Re: [U2] UV 10.1.22; Dynamic File question

2009-04-24 Thread Charles Stevenson
2. Use resize if you can get exclusive use of the file. (I don't think "CONCURRENT" works with dynamic files. but I'm wary with static too.) RESIZE will allow you to set the minimum modulus, but maybe not using the syntax as documented. And syntax differs according to acct flavour and OS (and

Re: [U2] I-descriptor subroutine / SELECT question

2009-04-24 Thread Charles Stevenson
Jeff Butera wrote: However, I've got to say that I cringe whenver someone proposes using an I-decriptor that, in turn, is performing it's own SELECT under the hood. This is really poor from both a design and performance point of view - there's got to be a more methodical means to get the data

Re: [U2] UV 10.1.22; Dynamic File question

2009-04-23 Thread Charles Stevenson
Allen Egerton wrote: The situation is that I'm potentially adding a million records to a dynamic file. That's not hypothetical, it's a real life scenario. And I don't want to wait while the file splits multiple times over the course of the add. I don't have that large a window. I want to forc

Re: [U2] UV 10.1.22; Dynamic File question

2009-04-23 Thread Charles Stevenson
While CREATE.FILE . . . MINIMUM.MODULUS does indeed reserver room in the primary "DATA30" file, it does NOT reserve any room in "OVER30" where large records (& group overflow) lives. But you can leverage that comment about purges: At some non-primetime convenient to you, create a bunch of du

Re: [U2] Record Size Limit in UV

2009-04-23 Thread Charles Stevenson
I've seen records at least an order of magnitude larger than that. Unix & Windows. Megabytes. I want to say much larger than that, but I can't verify that and when numbers get that big, my brain can't get around them. ( e.g., $1,000,000,000,000: www.pagetutor.com/trillion/index.html ) I d

Re: [U2] [UV] Config parameter for the READU

2009-03-23 Thread Charles Stevenson
Back in 2002, when I wrote that, I couldn't set it to 0 and disable it. Didn't know 0 now works. Good. I usually peruse the release notes and don't recall that change. I agree, setting it to 0 to turn it off makes sense. (By the way, Mr. Fillips, Stevenson has a "v" in it, not a "ph".) Chuck

Re: [U2] User count not correct

2009-03-04 Thread Charles Stevenson
What happens if a UV process shells out & executes a shell script that, in turn, invokes uv? I don't think it increments the user count, but I'm not sure. I do know it stomps all over the parent uv's "printer segment", so it's generally not a good idea. And, yes, look up uvlictool. there are "re

Re: [U2] Universe Index not working

2009-03-04 Thread Charles Stevenson
In a prior release 10.0 or earlier, I encountered a problem that could corrupt an index if a write was issued without an explicit readu preceding it. I don't think IBM ever corrected that because writing without explicitly locking is Bad Form. If I remember, when process A holds a lock on a record

Re: [U2] RE: UV - Error when using "WHEN" [not-secure]

2009-02-03 Thread Charles Stevenson
Yes, WHEN can be frustrating. 1st, make sure the multi-valued associated fields are properly defned with M's in field 6, association name in field 7 and, for good measure, create a phrase with said association name as the id of the phrase, and all the associated fields listed in <2>. Then add a BY

<    1   2   3   >