Re: [U2] Dynamic Concepts Unibasic ... Is this Pick ?

2014-04-24 Thread Charles Stevenson
& there's another outfit called "Unidata" in Colorado, too. It's part of a university or an NGO thing, maybe unifying data across several NGOs. Maybe an arm of the Amalgamated Organization of Federated Associations. (hat tip to Garrison Keillor.) On 4/24/2014 9:41 PM, Tom Whitmore wrote: Thi

Re: [U2] Left Outer Join Question

2014-03-04 Thread Charles Stevenson
Randy, It sounds like NSELECT is what you need. But MERGE.LIST is a handy thing to get working. I use it all the time, especially when researching bugs or bad data. What happens if you do other commands manipulating active select list 1? SELECT OLDMAS TO 1 SAVE.LIST X FROM 1 ? or LIST OLDMAS

Re: [U2] Recommended 11.1.point release to upgrade to.

2014-03-02 Thread Charles Stevenson
further 11.1.x releases so we can focus on the 11.2.x and .NEXT releases of UniVerse and moving the technology forward. > > I also misspoke on 11.2.4 as it was a mistake in our issue system. It is actually 11.2.3. > > Regards, > > Dan > > -Original Message- >

Re: [U2] Recommended 11.1.point release to upgrade to.

2014-02-28 Thread Charles Stevenson
'm happy to provide my workaround script to anyone who runs into this on a linux or unix box. Unfortunately, I'm not sure how one would craft a workaround on Windows. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org

Re: [U2] Recommended 11.1.point release to upgrade to.

2014-02-27 Thread Charles Stevenson
issionw wher I created the new uv\errlog. MAKE.MAP.FILE had errors on both dev & prod after 11.1.15 install. I re-catalogued a couple subroutines it cared about and it seems to be ok. It wasn't a permissions problem. Gracious thanks to those on this list who offered advice, Chuck Stev

Re: [U2] SELECTINDEX problem Universe 11.1.11

2014-02-22 Thread Charles Stevenson
Use BSCAN command. instead of SELECTINDEX. SELECTINDEX gets exact matches, whereas BSCAN gets you to a starting point , then you go forward from there. You'd BSCAN for MACKE, then loop with additional BSCANs until you are past what you care about. Or execute a SELECT statement: SELECT .

Re: [U2] wasted time on rs.com

2014-02-21 Thread Charles Stevenson
The question was "Why can't it be easy to find?" not "Where is it?" Searching Rocket website is difficult. The other day someone on this list was searching for Tech support Survivor's guide. Did he find it? We were told he needed a 2UBC login to get to it. Not for the riffraff. Try finding

Re: [U2] Debugging UNIX Segmentation Violations and Core Dumps (UV)

2014-02-18 Thread Charles Stevenson
You only allow that information out to people under maintenance contracts? Anyone can sign up at TechConnect. That isn't good enough? Original Message Robert, If you have a current maintenance contract with Rocket U2 you will be able to access this and many more resources from

Re: [U2] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question

2014-02-09 Thread Charles Stevenson
cases the difference matters. Scott Howder Assistant CIO Cedarville University howd...@cedarville.edu 937-766-7905 On Thu, Feb 6, 2014 at 4:48 AM, Charles Stevenson < stevenson.c...@gmail.com> wrote: & it's been that way for, oh I dunno, going back to PI, 30+ years? That'

[U2] "ED: The very finest of 1970s technology!" was: UniVerse Dictionary question

2014-02-06 Thread Charles Stevenson
& it's been that way for, oh I dunno, going back to PI, 30+ years? That's in input mode. Here are some related ED facts about edit-mode that I've found Pickies (vs. Primates) don't seem to know: Rreplaces current line with a blank line. Ithis is some text will insert a line "this is so

Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.

2014-01-30 Thread Charles Stevenson
Chuck On 1/29/2014 10:43 PM, Anthonys Lists wrote: On 28/01/2014 20:59, Charles Stevenson wrote: Anthony pretty much nailed how we're doing it. But my original question is still unanswered. I want to make sure it's a valid printer before I start printing to it. I think I problably

Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.

2014-01-30 Thread Charles Stevenson
Thanks, Brian. I was heading that general direction with net view \\[printserver] Then searching for the printer I'm looking for. You're right about the drivers, but I don't think I'll get a fatal error just because the printing is garbled or printer is offline, will I? We've been getting

Re: [U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.

2014-01-28 Thread Charles Stevenson
been declared to U2 - I did this all the time. The only printer UV was told about was DEFAULT, which didn't exist ... In fact, I suspect this syntax will list all the printers known to the server on which U2 is running, which could easily NOT include a valid printer the user is trying to print

[U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.

2014-01-28 Thread Charles Stevenson
SETPTR 0,80,60,3,3,1,AT \\Bad\PrinterName seems to execute w/o throwing an error. but an actual PRINT statement yields a fatal error: Program "PRT": Line 2, Printer name \\Bad\PrinterName is not recognized by the system. I'd like to verify we're printing to a good printer *before* attemptin

[U2] How do you verify windows printer is good before fatal error by PRINTing to a bogus printer.

2014-01-28 Thread Charles Stevenson
SETPTR 0,80,60,3,3,1,AT \\BAD\NAME seems to execute w/o throwing an error. but an actual PRINT statement yields a fatal error: Program "PRT": Line 2, Printer name \\BAD\PRINTERNAME is not recognized by the system. I'd like to verify we're printing to a good printer *before* attempting to d

Re: [U2] Logging program execution in Unidata?

2014-01-07 Thread Charles Stevenson
track OS's last access date on the object? On 1/7/2014 3:08 AM, McGowan, Ian wrote: We're looking into a major conversion late this year, which will involve checking out several thousand programs (mostly opens, reads or writes). Some programs are run many times a day, whereas some were throwaw

Re: [U2] JET

2014-01-06 Thread Charles Stevenson
Jet as a subset of Rocket instead or Rocket as a subset of Jet. It's a different universe. On 1/6/2014 8:00 PM, Daniel McGrath wrote: Have them contact their U2 support provider. Rocket has JET. Cheers, Dan McGrath Managing Director, U2 Servers Lab Rocket Software __

Re: [U2] REVISE - how do tou delete a mv association

2013-12-30 Thread Charles Stevenson
line 2 (PTR.LINO) and replace the existing value with ## to delete the value and associated values. HTH, Derek On Dec 27, 2013, at 3:14 PM, Charles Stevenson wrote: Somebody help me, please. I don't think I've used it since it was called ENTRO on PI. I can only see the command l

[U2] REVISE - how do tou delete a mv association

2013-12-27 Thread Charles Stevenson
Somebody help me, please. I don't think I've used it since it was called ENTRO on PI. I can only see the command line syntax for revise. I want to delete a set of values from several associated fields. CONTROL -Screen 1-FIRST SCREEN Fri Dec 27 15:03:03 2013 1 CONTROLBC.PRINTER S1 == FIRS

Re: [U2] Regarding: LISTING SUB-VALUES

2013-12-27 Thread Charles Stevenson
Anthony meant: 002: CUSTOMER.PHONE.NUMBER<1,3> On 12/27/2013 1:08 PM, Wols Lists wrote: CUSTOMER.PHONE.NUMBER.3 0001: I 0002: CUSTOMER.PHONE.NUMBER<3> <1,3> extracts the 3rd value from that single attribute. <3> extracts the 3rd attribute, which in this case would yield null. CUSTOMER.PHONE

Re: [U2] BASIC code - upper, lower, CamelCase, what say you?

2013-12-20 Thread Charles Stevenson
If you use mixed case, what search tools & comparitors do you use when researching your program libraries? Particularly if you have programs written in different styles over the years. What formatting tools do you use? On 12/20/2013 10:01 PM, Bobby Worley wrote: First off - Merry Christmas

Re: [U2] UniVerse Training

2013-10-25 Thread Charles Stevenson
Perry, you could just teach it instead. Actually, there's some significant changes in user management at 11.1. It looks like the Unidata-based Data Replication is pretty tightly integrated. There are some new logs, but that's pretty straightforward. I think I took an internals class back at ma

Re: [U2] [OT] Interview Questions

2013-10-08 Thread Charles Stevenson
Some of these responses have been really good. Thanks, all. Does anyone see any value in U2 Certification from Rocket? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users

Re: [U2] Dick Pick

2013-09-26 Thread Charles Stevenson
Now I want to see page 146. On 9/26/2013 5:16 PM, Brian Leach wrote: This photo of Dick Pick was doing the rounds at a client this week - from Jonathan Sisk's site: http://jes.com/gfx/people/csn_1983_11_28_antigrav_dick_001.jpg ___ U2-Users mail

Re: [U2] Recommended 11.1.point release to upgrade to.

2013-09-25 Thread Charles Stevenson
I know that a lot of work has gone into that over the previous couple of years. Rick -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Tuesday, September 24, 2013 3:53 PM To: U2 Users List Su

Re: [U2] Recommended 11.1.point release to upgrade to.

2013-09-25 Thread Charles Stevenson
Remember GTAR? Back in olden days Camelot, I mean Prime, was kind enough to tell us what the outstanding issues were. Not just tell us what the issue was after it was fixed. Gosh, that would be nice. cds ___ U2-Users mailing list U2-Users@listserver.u

Re: [U2] Recommended 11.1.point release to upgrade to.

2013-09-24 Thread Charles Stevenson
east one thing that I am expecting in 11.2 that is worth waiting for, assuming it shows up. I did not see it in the public beta. I think that 11.2 is supposed to be out around Nov 1. -Rick -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listser

[U2] Recommended 11.1.point release to upgrade to.

2013-09-24 Thread Charles Stevenson
We're finally going to upgrade from 10.2.10 to 11.1.[something]. But which point release? We're on Win2003. (Linux next year. Baby steps.) ReleaseDate Issues 11.1.13 Sept 2013 3 brand new. 11.1.12 June 201338 rescinded 11.1.11 Mar 20133

Re: [U2] Select from one file with save-list from another file

2013-08-28 Thread Charles Stevenson
P.S. If there is a many::1 relationship between X.FILE & Y.FILE, i.e., if more than 1 X.FILE record can have the same Y.INFO foreign key in it, do this: SELECT X.FILE WITH STATUS = "cc" SAVING UNIQUE Y.PACKET.ID LIST Y.FILE On 8/28/2013 9:56 AM, Charles Stevenson wrote:

Re: [U2] Select from one file with save-list from another file

2013-08-27 Thread Charles Stevenson
I'm with Ian. Maybe Ian and I don't understand the question. The other answers seem so complicated. Brandon, Replace Ian's example "Y.PACKET.ID" with whatever is thereal name in DICT X.INFO pointing to what you describa ase Y.INFO's key exists as a "foreign key" somewhere in X.INFO. Giv

Re: [U2] universe 11.1 triggers via indexing and @IDX.IOTYPE sample

2013-08-27 Thread Charles Stevenson
Thanks, Troy. I was going to write that after I got to 11.1. (The upgrade was scheduled for Q3, but I hear rumours it got bumped because salesmen just sold something we can't do - yet. It pays the bills.) Troy, I want to borrow your code, but I want to include proper attribution in the progr

Re: [U2] [UV] Globally catalogs - source code

2013-08-22 Thread Charles Stevenson
Hello LeRoy, Haven't seen you on u2-list for a while. Are you still in South Africa? I'm just up the road a piece (well, 3000 km, not necessarily paved) from you in Dar es Salaam as of last month. Chuck Stevenson On 8/21/2013 5:43 AM, LeRoy Dreyfuss wrote: Many are in APP.PROGS in the UV a

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-06 Thread Charles Stevenson
is being made. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, August 03, 2013 9:40 AM To: U2 Users List Subject: Re: [U2] [UV] Do you avoid TRIGGERS because of the diffic

Re: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-08-03 Thread Charles Stevenson
- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Saturday, 27 July 2013 5:32 AM To: U2 Users List Subject: [U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

[U2] Fwd: Re: What is true

2013-08-02 Thread Charles Stevenson
On UV, if you want to see if parentheses make a difference, write similar lines with & without, compile, & VLIST to decomiple the object to a readable form. It reads like assembler, but you have the source line with it so it's really really easy to figure out what it's doing. Building on To

Re: [U2] What is true

2013-07-31 Thread Charles Stevenson
And then there's the query language: Suppose INVOICED field is supposed to be true or false. Stored as 1 or 0, but maybe left null in some records (We've all been there.): SELECT CUSTOMER WITH INVOICED If INVOICED is "0" or null, will said CUSTOMER record be selected or not? UV selects

[U2] [UV] Do you avoid TRIGGERS because of the difficulty using DEBUG or RAID with them? Was: Universe Triggers

2013-07-26 Thread Charles Stevenson
-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 26 July 2013 9:22 p.m. To: U2 Users List Subject: Re: [U2] Universe Triggers re. triggers & Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised

Re: [U2] Universe Triggers

2013-07-26 Thread Charles Stevenson
re. triggers & Raid, I could not agree with Phil more. Well said. Come on, Rocket! On 7/19/2013 1:32 AM, Phil Walker wrote: Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fi

Re: [U2] Benton Scheduler

2013-07-22 Thread Charles Stevenson
And I'm even more pleased to hear Dr. Leitner still graces us with his presence. Cheers, Lee! Chuck On 7/19/2013 8:00 PM, Riverman wrote: Thanks to all the speedy responders. I am pleased Benton is still alive and well, according to Google you do not exist. Searches only returned dead links. B

Re: [U2] Running total

2013-07-04 Thread Charles Stevenson
The important general idea is this: Use the @-buffer to get the result of the i-desc calculation from the *previous* record to apply it to the calculation for the *current* record. (RetrieVe inits @-buffers to null (which goes to 0) when the sentence executes.) I don't think this works for

Re: [U2] Running total

2013-07-02 Thread Charles Stevenson
PM, Martin Phillips wrote: Hmmm. Simpler than my approach but it fails with multivalues or with queries that have other I-types in them. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenso

Re: [U2] Running total

2013-07-02 Thread Charles Stevenson
LIST NEWACC BYTES EVAL "BYTES+@2;@" VOC. Bytes.. BYTES+@2;@ ADDX 47 47 CHDIR 53100 ENDPAGE 54154 LNUM 64218 On 7/2/2013 11:29 AM, Martin Phillips wrote: Hi, As far as I know, the only way to do this i

Re: [U2] History of Prime Information

2013-06-12 Thread Charles Stevenson
Martin, Those are details I hadn't heard. Thanks, Chuck On 6/12/2013 7:36 AM, Martin Phillips wrote: I can add that I think VMark rewrote Prime Information in C which really boosted the performance. I think they called it Prime Info or something like that. I'm not sure about this. As far as I

Re: [U2] [UV] Record Sampling for File Sizing Diagnostics

2013-06-11 Thread Charles Stevenson
SAMPLED keyword with a D on the end will go thru the entire file. SAMPLED 1000 will get every thousandth record as it reads through the file. SAMPLED 1000 SAMPLE 2000 will do the same, but then stop after it builds a list of 2000. That is, after it's read thru the 1st 2 million keys. On Tue, Ju

Re: [U2] UV File doesn't like being sampled?

2013-05-24 Thread Charles Stevenson
George, Does the file have an index on the id? If so, try adding the "NO.INDEX" keyword. I've something similar @ UV10.2.10: -- >SELECT PARTS SAMPLE 2 26417 record(s) selected to SELECT list #0. - >SELECT PARTS SAMPLE 2 NO.INDEX 2 record(s) selected to SELECT list #0. - >DELETE.INDE

Re: [U2] Relative Path for SET.INDEX in Universe

2013-05-17 Thread Charles Stevenson
At 10.1 (on Windows) I've run into trouble when "filename" is an F-pointer to a relative path that is not just a file resident in that account. e.g.: VOC XYZ 01: F 02: ABC/XYZ Rick, Your INDICES() result will differ depending on whether you invoke the function in the account where

Re: [U2] Selecting a special character in a SELECT (UV)

2013-05-16 Thread Charles Stevenson
SELECT filename WITH EVAL "INDEX( @ID, CHAR(160), 1)" > "0" On 5/16/2013 8:41 AM, George Gallen wrote: Ok. I'm trying to find all the ID's in a file that contain the character ^160 I tried : SELECT filename WITH @ID LIKE "...^160..." But that didn't work.

Re: [U2] [UV] RESIZE INPLACE

2013-05-06 Thread Charles Stevenson
p doing. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, May 06, 2013 7:25 AM To: U2 Users List Subject: Re: [U2] [UV] RESIZE INPLACE So, Perry, did you do it? Chuck On 4/25/2013

Re: [U2] [UV] RESIZE INPLACE

2013-05-06 Thread Charles Stevenson
So, Perry, did you do it? Chuck On 4/25/2013 3:09 PM, Perry Taylor wrote: Before I go and resize a 144GB file has anyone had any experiences with the INPLACE option of RESIZE in UniVerse? Good, bad, ugly??? Thanks. Perry Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 4

Re: [U2] [UV] RESIZE INPLACE

2013-04-26 Thread Charles Stevenson
Nothing like jumping into the deep end, eh, Perry? 144GB. More by the time this thread is finished. If RESIZE INPLACE fails, what is the typical kind of failure to expect? What's the worst that can happen? What has happened to others? If you do this, please let us know the result, good or

Re: [U2] WRITESEQ Error

2013-04-12 Thread Charles Stevenson
I, for one, truly appreciate it when people post back like this when they finally find the solution to their puzzle. Thanks, Al. cds On 4/12/2013 9:59 AM, Al DeWitt wrote: We found the cause to this problem and I thought I'd share it with you. The file we append sits on a virtual PC. The VOC

Re: [U2] Replacements for Old SB?

2013-03-14 Thread Charles Stevenson
On 3/13/2013 8:55 PM, Tony Gravagno wrote: I haven't had a single department manager tell me they want a thick client GUI in almost a decade. Anyone who is looking to me for GUI these days wants a browser. Case in point: We're in testing now with a thick-client 4GL handheld ap to be deployed

Re: [U2] ISO Date Format

2013-03-11 Thread Charles Stevenson
his returned the value 130311. You were missing the last 2 and the year is 2013, not 2012. This was a good thought, though. Cool -Original Message- From: Charles Stevenson [mailto:stevenson.c...@gmail.com] Sent: Monday, March 11, 2013 10:59 AM To: U2 Users List Cc: Woodward, Bob Subj

Re: [U2] ISO Date Format

2013-03-11 Thread Charles Stevenson
,2,2]' to give me the value 13503511 just as well. Fun with dates! BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Monday, March 11, 2013 8:08 AM To: U2 Users List Subject: Re: [U2] ISO Date

[U2] [UV] User Exits was: ISO Date Format

2013-03-11 Thread Charles Stevenson
3/11/2013 10:55 AM, Tony Gravagno wrote: It's things like this that make me wish more MV platforms had user-defined processor codes. U2 excels in the versatility here. I can't use wonderful codes like this because most of my code needs to work across platforms. Wah. :'( T Fro

Re: [U2] ISO Date Format

2013-03-11 Thread Charles Stevenson
By the way, you can also completely eliminate the dash (or slash, etc.) delimiters: OCONV( "16507" , "DYMD[4'',2'',2]" ) --> "20130311" ICONV( "20130311", "DYMD[4'',2'',2]" ) --> "16507" Notice that ICONV'ing the OCONV'd or OCONV'ing the ICONVd result gets you bat to where you started.

Re: [U2] FW: Clearing Input Buffer

2013-03-05 Thread Charles Stevenson
Like David Green, I would have suggested CLEARINPUT. I'm missing something: why all these other schemes people are talking about? On 2/22/2013 1:20 PM, Al DeWitt wrote: I have an input screen (built with System Builder) where data can either be entered manually or via a barcode scanner. The

Re: [U2] [UD] correlative syntax

2013-03-01 Thread Charles Stevenson
Isn't there a "T" missing? OCONV(@ID,"G*1"); OCONV(@,"FILE;X;0;0"); @#"" TFILE ? should be: OCONV(@ID,"G*1"); OCONV(@,"TFILE;X;0;0"); @#"" another way is to do both correlatives in 1 oconv: OCONV(@ID,("G*1":@VM:"TFILE;X;0;0"))#"" O

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Charles Stevenson
Kevin, This is a long shot, an Is-it-plugged-In-Category question, but you might as well check: On UV I got bit recently using numbered select lists because "1", "2", ... were custom items in the VOC. Some commands recognized the numbered select lists on the command line; but some read the

Re: [U2] Unidata 7.1.16 Multiple Active Select Lists

2012-09-24 Thread Charles Stevenson
Dave, Be careful with that because LOCATE's sort BY "AR" or "DR" may be different from LIST's sort BY an "R"-justified field. Leading zeros, negative numbers, decimals with trailing zeros all come to mind. If I recall that inconsistency is consistent across several MV platforms. However, it

Re: [U2] Etymology of "Q-Pointer"

2012-09-12 Thread Charles Stevenson
etter Q for Q-pointers. Glad to still have access for these types of questions, and sorry to disappoint those searching for deeper meaning. The Henry that Sisk mentions is, no doubt, Henry Eggers. I believe both answers. In case anyone was still interested. cds On 9/7/2012 5:25 PM, Cha

Re: [U2] Etymology of "Q-Pointer"

2012-09-07 Thread Charles Stevenson
y "dawning days of Pick" comment and chime in. "Quick" is the best anyone has come up with, I guess. On 9/6/2012 9:19 PM, Charles Stevenson wrote: A newbie stumped me: Why are "Q-Pointers" "Q" pointers ? The "Q" lingo comes from the dawnin

Re: [U2] Etymology of "Q-Pointer"

2012-09-07 Thread Charles Stevenson
allow) a syntax mixing commas & a semi-colon. Ugh. On 9/7/2012 10:54 AM, Wols Lists wrote: On 07/09/12 03:19, Charles Stevenson wrote: A newbie stumped me: Why are "Q-Pointers" "Q" pointers ? The "Q" lingo comes from the dawning days of Pick. Why w

[U2] Etymology of "Q-Pointer"

2012-09-06 Thread Charles Stevenson
A newbie stumped me: Why are "Q-Pointers" "Q" pointers ? The "Q" lingo comes from the dawning days of Pick. Why was the letter "Q" chosen? "A"ttribute makes sense. "S"ynonym makes sense. "PQ" for Prestored Query makes sense. PR for Proc would have been better. D3 User Guide j

Re: [U2] Friday type of question

2012-09-01 Thread Charles Stevenson
If you also want to delete everything with only system delimiters but no actual data between them do something like: SELECT PERSON WITH EVAL "LEN( CONVERT( @AM:@VM:@SM, "", @RECORD ))" = "0" or SELECT PERSON WITH EVAL "SUMMATION( LENS( @RECORD ))" = "0" Technically, system delimiters in

Re: [U2] Comparing Two Dyamic Arrays

2012-07-24 Thread Charles Stevenson
Mike meant NES( ), not EQS( ). and SUMMATION( ), not SUM( ). SUM( ) won't yield a scalar unless all delimiters are the same. ResultArray = NES(Array1, Array2) If summation(ResultArray)=0 then samething = true else samething = false Which is all well and good . . . as long as y

Re: [U2] RESIZE - dynamic files

2012-07-05 Thread Charles Stevenson
Chris, I can appreciate what you are doing as an academic exercise. You seem happy how it looks at this moment, where, because you set "MINIMUM.MODULUS 118681", you ended up with a current load of 63%. But think about it: as you add records, the load will reach 70%, per "SPLIT.LOAD 70", th

Re: [U2] RESIZE - dynamic files

2012-07-04 Thread Charles Stevenson
>SMAT -d (or ANALYZE.SHM -d) see uv/bin/smat[.exe] uv/bin/analyze.shm[.exe] Dynamic Files: Slot # Inode Device Ref Count Htype Split Merge Curmod Basemod Largerec Filesp Selects Nextsplit 0 1285128087 209307792516208050 4001 2048 3267 2782736

Re: [U2] RESIZE - dynamic files

2012-07-04 Thread Charles Stevenson
Good explanation, Brian! To anyone who skipped it because it looked long: read it anyway. cds On 7/4/2012 5:26 AM, Brian Leach wrote: Sorry to those who already know this, but maybe it's time to go over linear hashing in theory .. Linear hashing was a system devised by Litwin and originally o

Re: [U2] RESIZE - dynamic files

2012-07-03 Thread Charles Stevenson
Chris, Let's back way up. I take it your original question is a general one, not specific to one poorly performing problematic file. Is that right? If so, generally speaking, you just don't get a lot out of fine-tuning dynamic files. Tweaking the default parameters doesn't usually make a w

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-03 Thread Charles Stevenson
and FMT are optional and AS is optional in this case. You would us it if you wanted to sort or break on the EVAL column. On Jul 3, 2012, at 9:55 AM, Charles Stevenson wrote: What Brian said, except don't replace LIST! Rather, write your subroutine to be called from an I-descriptors: M

Re: [U2] UniVerse LIST statement question [not-secure]

2012-07-03 Thread Charles Stevenson
What Brian said, except don't replace LIST! Rather, write your subroutine to be called from an I-descriptors: MARKH 0001 FUNCTION MARKH( INARG ) 0002 COMMON /MARKH/ START.IDT, END.IDT, PREV.ID, VLIST 0003 * 0004 * Assumes common has been initialized properly before this function

Re: [U2] uv/win - PHANTOM <> JOBS not sync'ed

2012-06-18 Thread Charles Stevenson
Manu, Look up the commands NOTIFY and MESSAGE. If I recall, either or both of those can configure the parent session to receive or block the child phantom's message. The PHANTOM command has a BRIEF keyword, too. That is supposed to prevent the phantom from sending the message. It doesn't soun

Re: [U2] [UV] "Program "X": Line 2, WRITE failure. ( SYS.MESSAGE 040019 )

2012-06-12 Thread Charles Stevenson
Here's from a similar discussion from 2005 below. No solution then. But I just thought of something I wish I'd thunk of 7 years ago. I can't make a write cough up 040019 during this condition, but maybe someone else can build on on it: For type-19, all "id"s hash to the same lock semaphore

Re: [U2] [UV] "Program "X": Line 2, WRITE failure. ( SYS.MESSAGE 040019 )

2012-06-12 Thread Charles Stevenson
than definitive discussions about it. That's where I've encountered it. Went on a wild goose chase recently looking for that cause until I found the value-mark-in-the-id problem also causes it. David Jordan's sounds similar: mv data where single-valued expected. How many others?

Re: [U2] [UV] "Program "X": Line 2, WRITE failure. ( SYS.MESSAGE 040019 )

2012-06-12 Thread Charles Stevenson
global Trigger routine. Possible problem with e.g. McAfee not releasing at NT level fast enough. Martin -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: 12 June 2012 21:02 To: U2 Users List Su

[U2] [UV] "Program "X": Line 2, WRITE failure. ( SYS.MESSAGE 040019 )

2012-06-12 Thread Charles Stevenson
Does anyone have a complete list of what kinds of problems will throw this error? >RUN CDS.BP X Program "X": Line 2, WRITE failure. uv\errlog: Tue Jun 12 15:54:05 12848 cdstevenson Program "X": Line 2, Message[040019] Although I generated it here by attempting to write a record with

Re: [U2] Why did this compile??

2012-06-07 Thread Charles Stevenson
A Pickism, not a Prime-ism. Prime demanded that you say FMT( TRIM( LINE<3>, "~" ) if that's what you meant. VLIST the program & it will be obvious how it compiled. cds On 6/7/2012 1:47 PM, David Wolverton wrote: Look at this line of code... TEST.STRING = TRIM(LINE<1>):"~":TRIM(LINE<3>)"~":

Re: [U2] FW: Multivalue Question

2012-06-07 Thread Charles Stevenson
Because we're talking about a very long string, & because we only care about the truth value of MORE.FLAG, not it's numeric value, It is better to initialize MORE.FLAG as: MORE.FLAG = LEN( MVDATA ) instead of MORE.FLAG = ( MVDATA # '' ) At least, that's true on UV. UV keeps the length of

Re: [U2] Do indexes record mv pos ?

2012-06-06 Thread Charles Stevenson
It's working as designed. PI did it better & the workaround for other flavours is: $OPTIONS PIOPEN.SELIDX From basic ref pdf, under SELECTINDEX: Note: If index is multivalued, each value is indexed even if the field contains duplicate values in the same record. Except in PIOPEN flavor acco

Re: [U2] matrix dimension

2012-05-24 Thread Charles Stevenson
So LARGE.ARRAY is 2-dimensional & SMALL.ARRAY is 1 dimensional. The real value of INMAT is telling the SIZE of (each) dimension. Yes, I'm deliberately being picky. I've found it very frustrating to be hard-limited to 1- or 2-dimnsional arrays. What would be so wrong to allow: DIM BETTE

Re: [U2] training material on LOCKS

2012-05-09 Thread Charles Stevenson
s.com/2010/12/29/happy-100th-birthday-robert-coase/> sn't the UV910 material useful? Regards, LeRoy Sent from my iPhone 4 On May 9, 2012, at 12:43 PM, Charles Stevenson wrote: Brian, I'd agree with you, except for empirical evidence to the contrary. The Basic manual is a referenc

Re: [U2] training material on LOCKS

2012-05-09 Thread Charles Stevenson
AM, Brian Leach wrote: Actually, Chapter 4 of the UniVerse Basic manual has quite a good treatment on them. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: 09 May 2012 14:45 To: U2 U

[U2] training material on LOCKS

2012-05-09 Thread Charles Stevenson
Even though It is a foundational concept for any multi-user database management, several times in my career I have come across seasoned MV programmers who do not understand the basics of readu locks (let alone related topics like file locks, deadlocks, group locks, L-locks, transactions, optim

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-27 Thread Charles Stevenson
lightened. cds On 4/27/2012 3:00 AM, Brian Leach wrote: And don't forget low order characters, Char(0) to Char(31) with a possible special case for Char(9). Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Charles Stevenson
Why not, during program init, build the undesired char list once, then call CONVERT only once instead of hundreds of times each time THIS.MESSAGE needs adjusting? UNDESIRABLES = CHAR(127) FOR CHARACTER = 128 TO 249 UNDESIRABLES:= CHAR(CHARACTER) NEXT CHARACTER or for better perf

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Charles Stevenson
To be rigorous, per Wol's final sentence, if any legitimate LF (char(10)) or CR (char(13)) occurred in the INPUTVAR string outside the CRLF pair, they too would be stripped out by CONVERT CHAR(10):CHAR(13) TO '' IN INPUTVAR. or the equivalent INPUTVAR = CONVERT( CHAR(10):CHAR(13),

Re: [U2] ASCII ^010^013 Removal (LF CR)

2012-04-26 Thread Charles Stevenson
UV's CHANGE or EREPLACE are synonyms: EREPLACE(expression, substring, replacement [,occurrence [,begin] ] ) CHANGE (expression, substring, replacement [,occurrence [,begin] ] ) which pretty much mimic ED's "C"hange command or Pick Editor's "R"eplace. UV's SWAP is different: "SWAP vari

Re: [U2] YYMMDD easy way?

2012-04-25 Thread Charles Stevenson
7 AM, Rick Nuckolls wrote: If not flavor, then hardware/os? (Sparc/Solaris) -Rick On Apr 25, 2012, at 5:26 AM, Charles Stevenson wrote: On my UV10.2.10 it behaves properly only with [2'',2''], as Richard& Perry describe. OCONV( "16187", "DYMD['

Re: [U2] YYMMDD easy way?

2012-04-25 Thread Charles Stevenson
OBTW, on UniVerse both concatenations: "D2YMD":@VM:"MCN" are done at compile-time because all elements are constant strings. (@VM isn't really a variable, more like an EQUate.) So if you stick Martin's construct inside a loop, there no added burden. On 4/24/2012 6:57 PM, Martin Braid wr

Re: [U2] YYMMDD easy way?

2012-04-25 Thread Charles Stevenson
Yes. Many people don't know you can stack conversion codes, separated by value marks (like in Pick dict <8> correlatives). But in this instance the DYMD[2'',2'',2] conversion discussed elsewhere in the thread has the advantage of being able to be used in ICONV, too, to get from YYMMDD to a

Re: [U2] YYMMDD easy way?

2012-04-25 Thread Charles Stevenson
ICONV works, too! ICONV( "120425", "DYMD[2'',2'']" ) --> "16187" OCONV( "16187", "DYMD[2'',2'']" ) --> "120425" If you ICONV an invalid date, e.g. April 34th: ICONV( "120434", "DYMD[2'',2'']" ) --> "" and STATUS()=1 I believe mathemeticians would call those "inverse" transforma

Re: [U2] YYMMDD easy way?

2012-04-25 Thread Charles Stevenson
On my UV10.2.10 it behaves properly only with [2'',2''], as Richard & Perry describe. OCONV( "16187", "DYMD['','']" ) = "2012425" OCONV( "16187", "DYMD[2'',2'']" ) = "120425" Like Rick, I find flavor does not matter. On 4/24/2012 7:38 PM, Rick Nuckolls wrote: That was my thought, but

Re: [U2] EXIT ; EXIT inside a loop

2012-04-22 Thread Charles Stevenson
Once more, VLIST answers the question: 1: FOR A1 = 1 TO X 1 0 : 0F8 move 0 => A1 1 6 : 098 forincrA1 X 1 00058: 2: FOR A2 = 1 TO Y 2 00014 : 0F8 move 0 => A2 2 0001A : 098 forincrA2 Y 1 00050: 3:

Re: [U2] Case Statement with only two cases

2012-04-20 Thread Charles Stevenson
A respectful correction, Brian. On 4/20/2012 4:50 AM, Brian Leach wrote: it's all the same to the compiler. -Original Message- BEGIN CASE CASE A = "TEST"; GOSUB DO.SOMETHING CASE 1; GOSUB DO.SOMETHING.ELSE END CASE versus this IF A = "TEST" THEN GOSUB DO.SOMETHI

Re: [U2] Unwanted Duplicated

2012-04-06 Thread Charles Stevenson
If these are long lists, it may be best to save the list with its duplicates, shell out and execute unix command sort -u on the saved lists. No database i/o. Unless UD has some feature beyond UV's at this particular point. Note that sort -u output is sorted, but not necessarily by the same alg

Re: [U2] Universe: IF statements in parargraphs don't work anymore

2012-04-04 Thread Charles Stevenson
One way around the UPDATE.ACCOUNT problem that Brian mentions is to invent your own flavour (Your own sub-file under the Pick-style multi-level file under UV/NEWACC). Massage that once per UV upgrade, then apply it to all VOCs that need protecting or customizing. Personally, I wish it was muc

Re: [U2] Record lock

2012-03-27 Thread Charles Stevenson
Nicholas (& any newbies listening in), Just to make sure all bases are covered: 1. LIST.READU's "EVERY" keyword. Besides showing group locks, it will also, at the very end, show who is waiting on a lock. If there are 2 lines where waiter & lock-holder are reversed on the 2nd line, you have a

Re: [U2] Turn a device and inode into file name

2012-03-17 Thread Charles Stevenson
Better yet, write an i-descriptor-friendly function to extract STATUS & FILEINFO info, then use it in DICT VOC I-descripters to use with SELECT & LIST directly. On 3/16/2012 5:00 PM, LeRoy Dreyfuss wrote: A program that uses either the FILEINFO() function or the STATUS statement will produc

Re: [U2] Turn a device and inode into file name

2012-03-17 Thread Charles Stevenson
Diane - Here's a short LIST.READU envelope that replaces dev/inode with filenames. Look up these UV-supplied tools that tie device & Inode to the filename: ACCOUNT.FILE.STATS LIST.FILE.STATS STAT.FILE UNIVERSE.STAT.FILE It relies on regularly running ACCOUNT.FILE.STATS to keep STAT.

  1   2   3   >