Re: [U2] Index problem

2004-11-04 Thread Simon Lewington
Fred Finken [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Here's an idea that I haven't actually tried, but it sure seems like it should work: You have two related files - say ORDERS and CUSTOMERS. You want any change to CUSTOMERS name to be reflected in the ORDERS file's

[U2] Uniobjects.NET speed/performance

2004-11-04 Thread Chris Ahchay
Is anyone else experiencing speed problems with Uniobjects.net? I've just upgraded our core application from Uniobjects to UONET (a non-trivial exercise as I'm sure you're aware) but the response times are atrocious. Opening a file has gone from being a virtually instant response to taking well

RE: [U2] Dimensioned arrays

2004-11-04 Thread Peter Olson
how about just adding the new elements to the end cause the program will go ka-boom as soon as last.pos exceeds inmat( arr1 ) ? we'll need to insure it doesn't blow past this threshold... This e-mail, including attachments, may include confidential and/or proprietary information, and may be

Re: [U2] Uniobjects.NET speed/performance

2004-11-04 Thread Donald Kibbey
I found that using a select list within a loop was cause for a long nap... I fixed that by reading the entire list into an array and then looping through the array. I've read on this list that there is an updated uniobjects.dll available, but my VAR was not able to locate it?!? I really

RE: [U2] Index problem

2004-11-04 Thread Bill H.
Phil: What I don't understand about this conversation is why would one expect any different functionality from the dbms? This has been, in my experience, the way indexes have always been on the mvDbms products; whether they be U2, D3, or whatever. When an index is created, it is updated if, and

Re: [U2] Dimensioned arrays

2004-11-04 Thread Fred Finken
If I understand your problem, you can use INSERT exactly as you would with dynamic arrays: INS newValue1 BEFORE FLD(1)1,VMC INS newValue2 BEFORE FLD(2)1,VMC INS newValue3 BEFORE FLD(3)1,VMC etc. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [U2]

RE: [U2] Index problem

2004-11-04 Thread u2
[EMAIL PROTECTED] wrote: Phil: What I don't understand about this conversation is why would one expect any different functionality from the dbms? This has been, in my experience, the way indexes have always been on the mvDbms products; whether they be U2, D3, or whatever. When an index

RE: [U2] Uniobjects.NET speed/performance

2004-11-04 Thread George Smith
Chris, I noticed that the initial session connection took a long time. It is so noticeable. grs Is anyone else experiencing speed problems with Uniobjects.net? I've just upgraded our core application from Uniobjects to UONET (a non-trivial exercise as I'm sure you're aware) but the response

RE: [U2] Dimensioned arrays

2004-11-04 Thread Baakkonen, Rodney
I wrote something about this a while ago. Dynamic arrays can be a major performance hit on a system if the size gets more than a few thousand elements. We had processes building huge dynamic arrays using LOCATE/INSERT. Some of them ran for a week. We changed to using a work file to write a record

[U2] RE: [UD] Index problem

2004-11-04 Thread Piers Angliss
quote Simon Lewington What would be great is if Unidata provided a facility to update an index in a file programatically. /quote If I recall correctly, Universe implements indices as Type 25 data files, so UV could support this Piers --- u2-users mailing list [EMAIL PROTECTED] To

RE: [U2] RE: [UD] Index problem

2004-11-04 Thread Bob Witney
You can buts its dangerous because the name of the index can change when its recreate ot rebuilt Like this :CT VOC H 0001 F 0002 ./I_BK.BOOKI00/INDEX.000 0003 D_BP :LIST H LIST H 15:14:01 04-11-04 PAGE 1 BP.. ABQATL*11878*DL1896 ABQATL*11878*DL944 ABQATL*11948*DL1896

RE: [U2] RE: [UD] Index problem

2004-11-04 Thread Bob Witney
You can access it via a program but its dangerous because the index reference will change (or could do ) when its recreate or rebuilt Like this :CT VOC H H 0001 F 0002 ./I_BK.BOOKI00/INDEX.000 0003 D_BP :LIST H LIST H 15:14:01 04-11-04 PAGE 1 bp. 1000.00

Re: [U2] RE: [UD] Index problem

2004-11-04 Thread Simon Lewington
Piers Angliss ... quote Simon Lewington What would be great is if Unidata provided a facility to update an index in a file programatically. /quote If I recall correctly, Universe implements indices as Type 25 data files, so UV could support this Yep - definitely one to put in the plus

Re: [U2] NT UNIX

2004-11-04 Thread John Hester
Phil Walker wrote: John, What uid and gids do you get for the user? Is the information the same as you would get normally. e.g. the id command. You define the user uid and gid range you want in samba's smb.conf file. These are the recommended values: idmap uid = 1-2

RE: [U2] [UD] Files from UD Unix to UD Windows

2004-11-04 Thread BNeylon
Thanks, I downloaded the PDF 6.1 manual set and found the proper section. I will now RTFM and try it tomorrow. Bruce M Neylon Health Care Management Group Marc Harbeson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2004 01:58 PM Please respond to u2-users To: [EMAIL

RE: [U2] [UD] Files from UD Unix to UD Windows

2004-11-04 Thread BNeylon
I connected using my favorite handy-dandy windows-based ftp program. Bruce M Neylon Health Care Management Group Buffington, Wyatt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/03/2004 02:54 PM Please respond to u2-users To: [EMAIL PROTECTED] cc: Subject:

RE: [U2] Dimensioned arrays

2004-11-04 Thread Stevenson, Charles
If I understand your problem, you can use INSERT exactly as you would with dynamic arrays: INS newValue1 BEFORE FLD(1)1,VMC INS newValue2 BEFORE FLD(2)1,VMC INS newValue3 BEFORE FLD(3)1,VMC etc. Heck, it is *possible* to INS *attributes*, not just values or subvalues: INS

RE: [U2] Index problem

2004-11-04 Thread Scott Ballinger
This (create a trigger in the header file that updates and re-files the detail item(s)) is what I have done on D3 systems. The only thing I might add is that I phantom off the update and include a 'sleep 5' (typically create a run-once proc and phantom that off) so that when the detail update

RE: [U2] Index problem

2004-11-04 Thread Stevenson, Charles
I've been out sick for a month and am jumping into the middle of this thread. I gather that someone wants to maintain an index on a TRANS() result, but is frustrated by UV or UD's failure to maintain the index. Here is a good workaround using my own verb, XSELECT, first implimented when we were a

RE: [U2] [UD] Files from UD Unix to UD Windows

2004-11-04 Thread Buffington, Wyatt
From what I just found out, I need to change some windows settings. Do you have any ideas what they might be? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 04, 2004 12:40 PM To: [EMAIL PROTECTED] Subject: RE:

RE: [U2] Index problem

2004-11-04 Thread Doyen Klein
I recently suspected that these mystery letters might help solve my mlist not found problem, but I misplaced my cheat-sheet (It was universe anyway) Can someone post or point to the doc which describes all the convoluted and obscure things one can do when one changes these letters?

RE: [U2] Index problem

2004-11-04 Thread Scott Ballinger
Wouldn't it be simpler to... 1. Maintain an attribute in dict ORD.HDR that contains all of the related ORD.DTL ids (or an I-type that builds such a list), perhaps called ORD.DTL.IDS 2. SELECT ORD.HDR WITH CUST.NAME EQ ABC XYZ ORD.DTL.IDS Scott Ballinger Pareto Corporation Edmonds WA USA 206 713

[U2] Recommend tunable for Unidata on Solaris - semmap

2004-11-04 Thread LeRoi Keiller
Hi dudes and dudesses I have a need to recommend a better value for the tunable 'semmap', for a client who has Solaris with UniData 4.1.12. Reason: They're getting WARNING: rmfree map overflow messages on the console. Anyone able to assist? Been there, done that? Here's some basic info:

RE: [U2] Index problem

2004-11-04 Thread Stevenson, Charles
Scott, Well, I suppose sometimes it would. But I was aiming at a general solution. For example, suppose CUST.NAME is stored in a CUSTOMER file. And CUST.ID is an attribute in any number of files, such as ORDERS, INVOICES, CONTRACTS, SALESMAN, etc... Would you want to maintain 4 separate

RE: [U2] Recommend tunable for Unidata on Solaris - semmap

2004-11-04 Thread Ken Wallis
LeRoi Keiller wrote: I have a need to recommend a better value for the tunable 'semmap', for a client who has Solaris with UniData 4.1.12. Reason: They're getting WARNING: rmfree map overflow messages on the console. Anyone able to assist? Been there, done that? Here's some basic info: