[U2] Arnold Bosch is on leave.

2006-02-10 Thread Arnold Bosch
I will be out of the office starting 11/02/2006 and will not return until 06/03/2006. For IT Related questions and problems, please contact Nicholas Preller - [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

[U2] Archives of the list

2006-02-10 Thread Logan, David (SST - Adelaide)
I've noticed a number of people bemoaning the fact that the archive server does not appear to available. If you wish, you can use http://news.gmane.org to search there as an alternative. Select gmane.comp.db.u2.general as the group to either read or search and away you go. You can also search for

RE: [U2] [UD] backups

2006-02-10 Thread Doug Miller
The problem with NT backup is that it will skip files that are open. So if you have people logged in or jobs running, the files will be skipped. I believe I have seen VOC's skipped (and maybe other files) for no apparent reason either. See some of the posts here. http://www.mail-archive.com

RE: [U2] [UD] backups

2006-02-10 Thread Allen E. Elwood
As someone that had their hard drive slammed by a hard error on the boot sector on Friday the 13th of last year, I can attest that NTBACKUP works great at restores, as long as you have a windows system to boot off of. The old chicken and the egg thing. Fortunately I had an emergency hard drive th

RE: [U2] [UD] backups

2006-02-10 Thread Bill Haskett
As an aside, what does one do when rebuilding a machine from one of these backups? 1) reinstall windows 2) reinstall UD into the previous UDTHOME directory 3) drag'n drop the old directory structure into UDTHOME and everything works, all accounts now exist? This is definitely cool. Bill > --

[U2] UniVerse 9.3 NT upgrade

2006-02-10 Thread Tom Dodds
We have a need to upgrade a Universe 9.3 system to 10.1.x. Does anyone have any experience with jumping directly from 9.3 to 10.1x. Are there any know problems with doing this, does anyone have any war stories they want to share about this upgrade? Thanks for you help Tom Dodds [EMAIL PR

[U2] Controlling Print Margins in Universe/NT Ver. 10.x

2006-02-10 Thread Dave Taylor
Ref: Universe/NT Ver. 10.x. Several months ago we were faced with forms and reports where the data that should have printed at the bottom of the page was pushed over to the top of the next page. We issued SETPTR commands to equate both top and bottom margins = 0 on both print channel 0 and the p

RE: [U2] [u2][ud] Poor select performance

2006-02-10 Thread John Jenkins
Try building an index on the whole filed and using a RANGE selection ... i.e. >= and <= Let us know how it goes - it may do the job. Remember to use no.dups and no.nulls for a bit more pep (pattern matches can't use the index) Regards JayJay -Original Message- From: [EMAIL PR

RE: [U2] Unable to OPEN file STATUS() = -4

2006-02-10 Thread John Jenkins
Question: Are you running from crontab as root perchance - and using uv foreground tasks not PHANTOMS - also is it AIX? Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kent Sent: 09 February 2006 23:05 To: u2-users@listserver.u2ug.or

RE: [U2] [UD] backups

2006-02-10 Thread Bill Haskett
Ken: Thank you very muchntbackup, here I come. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis > Sent: Thursday, February 09, 2006 8:31 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] [UD] backups > > Bill Has

RE: [U2] [u2][ud] Poor select performance

2006-02-10 Thread Maresh, Mel
My pet peeve with Universe Indexes is in selecting multiple values of an indexed field The following select might take 10 minutes SELECT CONTRACT WITH I_CONTRACT = "50178227" "50092158" "50006089" "50178228" "50092159" "50006090" "50178229" "50092160" "50006091" "50178230" Whereas SELECT CONTRA

Re: [U2] [u2][ud] Poor select performance

2006-02-10 Thread robwills_u2list
Out of interest, how long does the selection take without the index? Regards, Rob Wills (rob dot wills at tigerinfotech dot com) Martin Philips wrote on 10/02/2006 14:04:26: > Given the number of records that you say are in the file, you are probably > going to visit most groups anyway so the

RE: [U2] [UV] GOSUB variable-name?

2006-02-10 Thread George Gallen
but the question was referring to a gosub not a call, so the control should (big should) be contained within one program. The only time I used the call @varible was when I had different subroutines based on the flavor of the system This way it I had one base program that could be modified that whe

RE: [U2] [UV] GOSUB variable-name?

2006-02-10 Thread Jacques G.
> On a more serious note...If this is done correctly, > I don't think it > would be very difficult at all to support. If someone who didn't design the system has to maintain it, it is difficult to find out which programs are impacted by a change into one of the subroutines. In normal calls, one c

RE: [U2] [UV] GOSUB variable-name?

2006-02-10 Thread George Gallen
> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Serguei > Sent: Friday, February 10, 2006 4:18 AM > To: u2-users@listserver.u2ug.org > Subject: Re: [U2] [UV] GOSUB variable-name? > > > This approach is absolutely awful from software design point > of

RE: [U2] [u2][ud] Poor select performance

2006-02-10 Thread Perry Taylor
My experience is with UniVerse but I suspect it would suffer from the same thing. It's likely the problem is the high number of records per customer number. You might try indexing the entire key then doing a select on the customer number portion. Something like this maybe (not sure of the UniDat

Re: [U2] [u2][ud] Poor select performance

2006-02-10 Thread Martin Phillips
> Selecting other indexed values in the same file which gives me 5 records out > of the 5 million is very very fast. 30 second certainly sounds excessive but an index entry leading to over 500,000 records is not a good idea. To be effective, an index needs to lead you to a very small proportion of

[U2] [u2][ud] Poor select performance

2006-02-10 Thread bjorn.eklund
Hi there, we are having very slow respone times on a select statement. We have a file with a total of 5 million records in where the key is like -nn. The first part() is a customer number(numeric) and the second part(nn) is a sequential no. We have created an i-descriptor on the cus

Re: [U2] [UV] GOSUB variable-name?

2006-02-10 Thread Serguei
This approach is absolutely awful from software design point of view. I personally would hate to have to support software when it is the calling program that decides the flow of the program that is been called. Do you really need this? - Original Message - From: "Barry Brevik" <[EMAIL PRO