Re: [U2] [UV] GOSUB variable-name?
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 PROTECTED] To: U2-users (E-mail) u2-users@listserver.u2ug.org Sent: Wednesday, February 08, 2006 7:03 PM Subject: [U2] [UV] GOSUB variable-name? I would like to pass a variable (let's call it SUBNAME) to a subroutine, and this variable would contain the name of an existing label which I will call TEST. The subroutine can then do GOSUB TEST, but GOSUB SUBNAME will not compile. Aside from CALL @VARIABLENAME, is there any way to branch indirectly in universe? This would be really useful for me. Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] [u2][ud] Poor select performance
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 customer number, FIELD(@ID,'-',1). On this i-descriptor we have put an index: Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr FAKT.FINR V NumYes Yes Yes Yes S FIELD(@ID,'-',1) Selecting a customer with 570 000 records can take 30 seconds. (example of statement SELECT A_FILE WITH FAKT.FINR = 66) Selecting other indexed values in the same file which gives me 5 records out of the 5 million is very very fast. I've tried to rebuild.index with no improvment in performance. The file doesen't show any sign of level 2 overflow. I am single user on a powerful Sun server with SAN disks. We are on Solaris 8 and Unidata 6.1.10. Shouldn't it be faster than this? Perhaps this is normal and we have to take another approach to get the data we need? Thanks in advance! Bjorn Eklund Faktab Finans AB --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2][ud] Poor select performance
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 the data. The bigger this proportion is, the less benefit you will get. With an eleven character record key (assuming your template reflects the real structure), the index record for this customer is over 6Mb long. Everytime you update a record for this customer, Unidata has to read a 6Mb record, update it, remove the old entry and add the new one. Given the number of records that you say are in the file, you are probably going to visit most groups anyway so the index is not gaining you much for this example. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [u2][ud] Poor select performance
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 UniData syntax) ... CREATE.INDEX A_FILE @ID BUILD.INDEX A_FILE @ID SELECT A_FILE WITH @ID LIKE 66-... OR SELECT A_FILE WITH @ID MATCHING '66-'1N0N Perry Taylor www.zirmed.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, February 10, 2006 6:09 AM To: u2-users@listserver.u2ug.org Subject: [U2] [u2][ud] Poor select performance 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 customer number, FIELD(@ID,'-',1). On this i-descriptor we have put an index: Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr FAKT.FINR V NumYes Yes Yes Yes S FIELD(@ID,'-',1) Selecting a customer with 570 000 records can take 30 seconds. (example of statement SELECT A_FILE WITH FAKT.FINR = 66) Selecting other indexed values in the same file which gives me 5 records out of the 5 million is very very fast. I've tried to rebuild.index with no improvment in performance. The file doesen't show any sign of level 2 overflow. I am single user on a powerful Sun server with SAN disks. We are on Solaris 8 and Unidata 6.1.10. Shouldn't it be faster than this? Perhaps this is normal and we have to take another approach to get the data we need? Thanks in advance! Bjorn Eklund Faktab Finans AB --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] GOSUB variable-name?
-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 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? I agree, have we not learned anything from the past? Look what happened when gave machines the power to decide their own course of actions2001..Battlestar GallacticaKitt (and Kar) Giving programs the ability to control their own flow will eventually be the downfall of the human race! On a more serious note...If this is done correctly, I don't think it would be very difficult at all to support. George --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] GOSUB variable-name?
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 can search for CALL ROUTINE.NAME but when CALL @VARIABLE is used, it is difficult to find out, short of creating a trace in the subroutine that records SYSTEM(9001) over a period of time (even then, its no garantee that the period of time will be sufficient to identify all of the calling programs). __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [u2][ud] Poor select performance
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 index is not gaining you much for this example. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [u2][ud] Poor select performance
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 CONTRACT WITH I_CONTRACT = 50178227 comes back immediately. I've had to create a utility to do the selects individually and combine the results in one list. When we upgraded to 10.1, I had hoped that the process would be quicker, but it's the same --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] backups
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 Haskett wrote: I'm so confused. How does one go about doing a UniData (on Windows) backup? The same way you back up any other application on Windows - using whatever windows tool you like, ideally against a quiescent database - ie log everyone off, or do a dbpause. 1) Drag drop the @UDTHOME directory (but then how does one restore it)? Yes, you can do that, but not everything has to live under @UDTHOME of course. To restore files, you'd just drag and drop back the files you want. 2) Is there some sort of save verb that I can use after I: :SETTAPE 9 E:/Backups/UDBackups E:/Backups/UDBackups 512 No. Following this, can one do something like a SEL-RESTORE? See above. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unable to OPEN file STATUS() = -4
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.org Subject: [U2] Unable to OPEN file STATUS() = -4 Thanks to all those who responded to my SYS.MESSAGE corruption woes. This is part of the same problem and another clue. According to the doco -4 imples DATA 30 is missing which is not the case or a permissions issue which seems strange as the script is run as administrator. and has been running successfully for many years up until SYS.MESSAGE started being clobbered. Hence i have 2 clues 1. I sometimes seem to loose the file handle and seem to be trying to write to a read only file 2. I cant open a particular file (its a different file).in the EDI starting program that calls the subroutine where the above error sometimes occurs Does anyone have any other clues on this status. Any advice appreciated. jak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [u2][ud] Poor select performance
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 PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 10 February 2006 13:09 To: u2-users@listserver.u2ug.org Subject: [U2] [u2][ud] Poor select performance 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 customer number, FIELD(@ID,'-',1). On this i-descriptor we have put an index: Index-Name.. F-type K-type Built Empties Dups In-DICT S/M F-no/VF-expr FAKT.FINR V NumYes Yes Yes Yes S FIELD(@ID,'-',1) Selecting a customer with 570 000 records can take 30 seconds. (example of statement SELECT A_FILE WITH FAKT.FINR = 66) Selecting other indexed values in the same file which gives me 5 records out of the 5 million is very very fast. I've tried to rebuild.index with no improvment in performance. The file doesen't show any sign of level 2 overflow. I am single user on a powerful Sun server with SAN disks. We are on Solaris 8 and Unidata 6.1.10. Shouldn't it be faster than this? Perhaps this is normal and we have to take another approach to get the data we need? Thanks in advance! Bjorn Eklund Faktab Finans AB --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Controlling Print Margins in Universe/NT Ver. 10.x
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 print channel that we were printing on. We created a test program to print 99 lines of data (LINE 1, LINE 2, etc.) and found that LINE 1 started on line 4 of the paper and LINE 60 was the last line printed leaving 3 blank lines at the bottom of the page, suggesting that the default top margin and bottom margin settings = 3 were being imposed on the print jobs even though the print channel margins = 0 and even though we used the NOFMT and NODEFAULT options. After trying all kinds of tricks, we were somehow finally able to print 66 lines of data on an 11-1/2 page at 6 lpi and 66 lpp, but we were unable to pinpoint exactly which trick did the job. In fact, we were able to store that 99 line print job in a file and SPOOL it to the printer (which is our ultimate goal) and print the first 66 lines on the first page. The Universe server needed to be rebooted recently, and we are now back to 3-line margins, both printing direct to the printer and spooling to the printer, inspite of what we do, including resetting the default printer settings using SETPTR 0,85,66,0,0,1 and SETPTR,DEFAULT in the UV account. A Support Case has been opened with IBM, but your experience may be a richer and more readily available source of ideas and solutions. Any suggestions will be deeply appreciated. tia, Dave Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] backups
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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, February 10, 2006 9:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] backups 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 Haskett wrote: I'm so confused. How does one go about doing a UniData (on Windows) backup? The same way you back up any other application on Windows - using whatever windows tool you like, ideally against a quiescent database - ie log everyone off, or do a dbpause. 1) Drag drop the @UDTHOME directory (but then how does one restore it)? Yes, you can do that, but not everything has to live under @UDTHOME of course. To restore files, you'd just drag and drop back the files you want. 2) Is there some sort of save verb that I can use after I: :SETTAPE 9 E:/Backups/UDBackups E:/Backups/UDBackups 512 No. Following this, can one do something like a SEL-RESTORE? See above. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] backups
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 that I just use for just such occasions. Just bought a new drive, booted off the emergency drive (small slow drive but works), restored to the new drive and bingo. I had to manually reconfigure ZoneAlarm but that's actually a feature that ZA will freak out if it finds it's files moved to a new physical position. btw, it would be wise to practice a few restores using an extra drive. It's not kind of thing that you want to 'learn' while trying to get back up ASAP, and it's not as intuitive as one would hope.. . . Allen E. Elwood www.tortillafc.com Quality Code Since 1978 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Friday, February 10, 2006 12:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] backups 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 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Haskett Sent: Friday, February 10, 2006 9:52 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UD] backups 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 Haskett wrote: I'm so confused. How does one go about doing a UniData (on Windows) backup? The same way you back up any other application on Windows - using whatever windows tool you like, ideally against a quiescent database - ie log everyone off, or do a dbpause. 1) Drag drop the @UDTHOME directory (but then how does one restore it)? Yes, you can do that, but not everything has to live under @UDTHOME of course. To restore files, you'd just drag and drop back the files you want. 2) Is there some sort of save verb that I can use after I: :SETTAPE 9 E:/Backups/UDBackups E:/Backups/UDBackups 512 No. Following this, can one do something like a SEL-RESTORE? See above. Cheers, Ken --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UD] backups
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/u2-users@listserver.u2ug.org/msg05742.html I did a big write up on OFM once but could not find it in the archives there. I wish Lee had his archive server up and running so I could have pointed you there. But alas, it's still work in progress. Sorry, Doug Miller At 11:52 AM 2/10/2006, you wrote: Thank you very muchntbackup, here I come. :-) Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Archives of the list
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 other groups by scrolling down to the bottom of the first page, put a few letters of the group name (eg. u2) and you will be given a selection of groups to look at. This is the only u2 one that has any interest for Universe/Unidata folk. Have a wander around there, it is quite a vast resource. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Arnold Bosch is on leave.
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/