RE: Help Needed regarding performance improvement of delete query
And replying to Scott's post to say thanks for the compliment, but I've just had another idea ... How many fields are you using for your select on the master file? ESPECIALLY if it's just the date, trans that across to your secondary file, and index it! If it's more than one field, try and work out a usable trans that will pull all the fields across in one index that you can run a select over. Don't forget, declaring an index means that that data is stored in the file, whether it was calculated, trans'd, or was in the file anyway. So now you can do a select and purge on your secondary file without ever having to go near the primary, and the database will take care of making sure all the required information is available as it's needed ... :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Richardson Sent: 15 March 2004 13:08 To: U2 Users Discussion List Subject: Re: Help Needed regarding performance improvement of delete query Great points from Wol, as always. What kind of /tmp disk space do you have on this system? (Assuming that /tmp is where UV does some of it's SELECT scratch pad intermediate writing when processing large queries, consult your sites actual uvconfig for all of your actual values...). If this /tmp is small, single physical disk, or heavily fragmented, this would also contribute to poor query runtime performance. Ditto on your system's swap space, which should be at least 2X physical memory. Wol's approach of breaking down the query into selecting smaller groups of data is a great one. Chip away at the stone, methodically, consistently, and constantly. What platform is this on? What OS version? What UV Version? How much memory disk space? How much /tmp and swap space? Are you running this query with other users on the system, who may be also trying to access the files this query is working with? Are you runing this at night when it might conflict with a backup operation? More food for thought. Regards, Scott - Original Message - From: Anthony Youngman [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, March 15, 2004 4:02 AM Subject: RE: Help Needed regarding performance improvement of delete query This might help speed things up a bit ... Firstly, of course, is your file properly sized? Secondly, (and in this case you will need to run the SELECT / DELETE sequence several times) try putting a SAMPLE 1000 (or whatever number makes sense) at the end of your select. Basically, this will mean that the SELECT runs until it finds that number of records and then stops. So each sequence won't load the system so badly. Creating a huge select list will stress your ram badly ... looping through this sequence won't stress the system so badly, though you really do need to use indices to reduce the stress even more ... Create an index on various fields that you're using as your select criteria. If you're selecting old records, then you need to select on date, and this really will make life both easy and fast. The more closely you can guarantee that a select, acting on a single index, will pick up only or mostly records that you are going to delete, the better. That will SERIOUSLY reduce the time taken and the performance hit. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of ashish ratna Sent: 15 March 2004 08:25 To: [EMAIL PROTECTED] Subject: Help Needed regarding performance improvement of delete query Hi All, We are working for purging of old data from the database. But we are facing performance problems in this. We are using select query which is created dynamically on the basis of number of records. We want to know if there is any limit for size of query in Universe. Although in universe help pdf it is mentioned that there is no limit for the length of select query. But when we run the program on the file with records more than 0.5 million it gave the error- Pid 14433 received a SIGSEGV for stack growth failure. Possible causes: insufficient memory or swap space, or stack size exceeded maxssiz. Memory fault(coredump) If there is no limitation on the size of query then please suggest some other possible solution which can help us reducing the time of query and completing the process successfully without giving the error. Thanks in advance. Regards, Ashish. *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International
RE: Suppressing detail in UniObjects command
But doesn't DEP.SUP have two Ps in it? :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Nick Southwell Sent: 16 March 2004 10:40 To: U2 Users Discussion List Subject: RE: Suppressing detail in UniObjects command Thanks go to Tony and Stuart who both figured it out. DEP.SUP with one P did the trick, ID.SUPP with the two P's seems to work fine too. Many thanks to everyone who pointed me in the right direction. Until next time Cheers Nick -Original Message- From: Tony Wood [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 22:46 To: U2 Users Discussion List Subject: Re: Suppressing detail in UniObjects command Hey Nick, What you NEED to use is DET.SUP and not DET.SUPP (please notice only one P). The error is trying to tell it does not understand DET.SUPP I think. Lembit Pirn was on the right track! Regards, T. - Original Message - From: Nick Southwell [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 4:18 AM Subject: RE: Suppressing detail in UniObjects command Cheers, I'll give that a try! Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 17:16 To: [EMAIL PROTECTED] Subject: RE: Suppressing detail in UniObjects command Yes, it sounds like you use the Pick style by either turning UDT.OPTIONS 2 ON or with ECLTYPE P for your regular sessions. I believe UniObjects defaults to ECLTYPE U. I haven't tried in a UniObjects session to change the ECLTYPE - you just need to learn the U type syntax which is somewhat different but has much more power. Check the online help for list and sort for the basic syntax. If you want to test your commands at TCL you can simply use the lower case list or sort to force UniData to use the U type command parser. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Nick Southwell [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 9:38 AM To: U2 Users Discussion List Subject: RE: Suppressing detail in UniObjects command Sooo.. Coming from a very small Unidata background sounds like you're saying I need to set my ECL type within the Uniobjects session? Thanks Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us
RE: Suppressing detail in UniObjects command
Thanks go to Tony and Stuart who both figured it out. DEP.SUP with one P did the trick, ID.SUPP with the two P's seems to work fine too. Many thanks to everyone who pointed me in the right direction. Until next time Cheers Nick -Original Message- From: Tony Wood [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 22:46 To: U2 Users Discussion List Subject: Re: Suppressing detail in UniObjects command Hey Nick, What you NEED to use is DET.SUP and not DET.SUPP (please notice only one P). The error is trying to tell it does not understand DET.SUPP I think. Lembit Pirn was on the right track! Regards, T. - Original Message - From: Nick Southwell [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 4:18 AM Subject: RE: Suppressing detail in UniObjects command Cheers, I'll give that a try! Nick -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 17:16 To: [EMAIL PROTECTED] Subject: RE: Suppressing detail in UniObjects command Yes, it sounds like you use the Pick style by either turning UDT.OPTIONS 2 ON or with ECLTYPE P for your regular sessions. I believe UniObjects defaults to ECLTYPE U. I haven't tried in a UniObjects session to change the ECLTYPE - you just need to learn the U type syntax which is somewhat different but has much more power. Check the online help for list and sort for the basic syntax. If you want to test your commands at TCL you can simply use the lower case list or sort to force UniData to use the U type command parser. hth -- Colin Alfke Calgary, Alberta Canada Just because something isn't broken doesn't mean that you can't fix it Stu Pickles -Original Message- From: Nick Southwell [mailto:[EMAIL PROTECTED] Sent: Monday, March 15, 2004 9:38 AM To: U2 Users Discussion List Subject: RE: Suppressing detail in UniObjects command Sooo.. Coming from a very small Unidata background sounds like you're saying I need to set my ECL type within the Uniobjects session? Thanks Nick -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Unable to read LOGS.DIR entry from D_UV_LOGS.
After installing universe 9.5.1 and run the command: bin/uv -admin -stop I got the following errors: Unable to read LOGS.DIR entry from D_UV_LOGS. Unable to open uvdrlogd Daemon info file. Unable to locate UVDR log directory. I tried again start and stop but the error remains. Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Terminology
Not really. MTBF means it'll run for 10 minutes without falling over. SLA can mean anything. If I was an office manager, I might well say (indeed, it's pretty much our internal SLA) that our systems will be guaranteed available between 8am and 6pm. So I can have 14 hours downtime a day, and still meet my 100% availability guarantee to my end users :-) Doesn't quite work that way of course :-) with offices in New York and Hong Kong, that available between 8 and 6 guarantee means that I only have a few hours when I can take the system out ... :-) But basically, all an SLA is, is a statement that service will be available within certain (acceptable to both sides) constraints. Whether time when it's available, or possibly response times (eg we can't run heavy maintenance tasks at certain times because the users will curse us etc etc). Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 16 March 2004 14:10 To: U2 Users Discussion List Subject: Re: Terminology So what does Service Level Agreement Metrics or Operational Level Agreement Metrics mean. Is this the new MTBF, ie Mean Time Between Failures. thanks. - Original Message - From: Ross Ferris [EMAIL PROTECTED] To: U2 Users Discussion List [EMAIL PROTECTED] Sent: Monday, March 15, 2004 10:47 PM Subject: RE: Terminology I'm on the wrong side of the world, but IIRC DataFlo is a product, like InfoFlo - these days out of the Epicore stable I'd imagine SLA would be a Service Level Agreement and OLA would be an Operational Level Agreement, both relating (more or less) to the uptime availability of a system Ross Ferris Stamina Software Visage - an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Tuesday, 16 March 2004 12:56 PM To: [EMAIL PROTECTED] Subject: Terminology Dear all: I'm not familiar with the following as referred to by MV: SLA and OLA metrics. Also, what is Dataflo. My guess is it may be a 4GL or it could be a 3.5GL like Eclipse. thanks. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.622 / Virus Database: 400 - Release Date: 13/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users *** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *** -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Terminology
Our help desk group has an SLA with the business as a whole which describes the hours of coverage (when they will man the phones), the relative manpower for given times of the day/week, and some guarantees about how quickly they will process an issue once it's been entered into their computer. Metrics just means measurements. Meaningful, predefined things that can be tracked and measured to see if the team is meeting their SLA, or if they're falling short of what they agreed to provide. They track all sorts of metrics regarding each ticket. Was it resolved by the person taking the phone call? Was it resolved by the next level up? How many days did it sit before someone processed it? How quickly did it reach final resolution? Stuff like that. They generate reams of reports that managers somewhere get all hot bothered over. The help desk managers love to spin the numbers to make them look like the most effective efficient thing on the planet. The Operations team (traveling technicians, etc.) does the same thing for their work tickets. Was the problem resolved remotely? How many hours did the tech spend on-site. Stuff like that. -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 8:10 AM To: U2 Users Discussion List Subject: Re: Terminology So what does Service Level Agreement Metrics mean. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: CLEANUP problem
Marco, We just had this happen on Monday on Unidata 6.0.8 on AIX 5.1, we were told to run udtdiag to colloect data about the state of Unidata and stop and restart Unidata. There is no other way. Here is what Unidata support told us: This is very difficult to chase down. Usually associated with killing a process. Some structures are left in the lock table (usually at a lower level than record or group locks - structures that control access to parts of this table. I do not know of any way to clear this situation without restarting the database. With the dump, we have a chance to review the structures. Without a way to force this situation, it is very difficult to figure out the cause of the problem and fix it. The good news/bad news is that it is very rare. Good that it doesn't happen much. Bad in that we have very little data to review to try to fix it. After running udtdiag: It creates a directory you name as an argument and dumps stuff there. One of the things it dumps is an image of the lock table along with the tool to analyze it (they have to match - saves us from reinstalling a specific version of UniData here to analyze the dump). You would then need to tar that up, compress it and ftp to: testcase.boulder.ibm.com:/software/toibm/informix And let us know the name of the file you posted. Good luck. Marco Antonio Rojas Castro [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/16/2004 09:50 AM Please respond to U2 Users Discussion List To: [EMAIL PROTECTED] cc: Subject:CLEANUP problem I have a problem with CLEANUP daemon We are using UNIDATA 5.2.9 (100 users license) on Windows 2000 our aplication is made with SB+ 5.4, and SBCLIENT 5.3 When the server is restarted, aprox. 25 users can log on then, when other users try to log on, this message appear in then screen : The CLEANUP is cleaning up the dead processes, please wait for a while. a few minutes later, the sessions logged din't respond in cleanupd.errlog file, we found theese messages U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,455): to call U_daemon_latch_cleanup(0) at Mon Mar 15 17:34:42 2004 U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 461): after calling U_daemon_latch_cleanup(0) at Mon Mar 15 17:34:42 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(0), sys_pv=3 at Mon Mar 15 17:34:52 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(0) at Mon Mar 15 17:34:52 2004 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 0 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 0 at Sun Jul 21 20:31:01 2013 U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,455): to call U_daemon_latch_cleanup(1) at Mon Mar 15 17:35:02 2004 U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 461): after calling U_daemon_latch_cleanup(1) at Mon Mar 15 17:35:02 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(1), sys_pv=3 at Mon Mar 15 17:35:12 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(1) at Mon Mar 15 17:35:13 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(2), sys_pv=3 at Mon Mar 15 17:35:14 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(2) at Mon Mar 15 17:35:14 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(2), sys_pv=3 at Mon Mar 15 17:35:14 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(2) at Mon Mar 15 17:35:14 2004 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 1 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 1 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 cleanup: accounting for killed user process. udtno = 1, pid = 2064, uid = 263392, usertype = 1, tty = 145.136.70.11, timedate = 17:34:38 Mar 15 2004, current time = Mon Mar 15 17:35:27 2004 please, what can I do to
Re: CLEANUP problem
Marco, Also, you say you are on sb+ 5.4 and sbclient 5.3, we were told to always have sb+ equal or below sbclient, not at a higher level. This would not cause your current issue, but could cause you to have unpredictable results in other applications. Just an FYI. Thanks! Marco Antonio Rojas Castro [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/16/2004 09:50 AM Please respond to U2 Users Discussion List To: [EMAIL PROTECTED] cc: Subject:CLEANUP problem I have a problem with CLEANUP daemon We are using UNIDATA 5.2.9 (100 users license) on Windows 2000 our aplication is made with SB+ 5.4, and SBCLIENT 5.3 When the server is restarted, aprox. 25 users can log on then, when other users try to log on, this message appear in then screen : The CLEANUP is cleaning up the dead processes, please wait for a while. a few minutes later, the sessions logged din't respond in cleanupd.errlog file, we found theese messages U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,455): to call U_daemon_latch_cleanup(0) at Mon Mar 15 17:34:42 2004 U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 461): after calling U_daemon_latch_cleanup(0) at Mon Mar 15 17:34:42 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(0), sys_pv=3 at Mon Mar 15 17:34:52 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(0) at Mon Mar 15 17:34:52 2004 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 0 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 0 at Sun Jul 21 20:31:01 2013 U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,455): to call U_daemon_latch_cleanup(1) at Mon Mar 15 17:35:02 2004 U_isdeadproc()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 461): after calling U_daemon_latch_cleanup(1) at Mon Mar 15 17:35:02 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(1), sys_pv=3 at Mon Mar 15 17:35:12 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(1) at Mon Mar 15 17:35:13 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(2), sys_pv=3 at Mon Mar 15 17:35:14 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(2) at Mon Mar 15 17:35:14 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c,709): to call U_daemon_latch_cleanup(2), sys_pv=3 at Mon Mar 15 17:35:14 2004 U_daemon_all_latch_cleanup()(D:\branch_52\udtsrc\src\ulc\ulcd_proclist.c, 716): after calling U_daemon_latch_cleanup(2) at Mon Mar 15 17:35:14 2004 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 1 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 1 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): to call U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 U_daemon_all_logical_cleanup(): after calling U_logproc_cleanup() on 2 at Sun Jul 21 20:31:01 2013 cleanup: accounting for killed user process. udtno = 1, pid = 2064, uid = 263392, usertype = 1, tty = 145.136.70.11, timedate = 17:34:38 Mar 15 2004, current time = Mon Mar 15 17:35:27 2004 please, what can I do to solve this ??? Thanks Marco Rojas C. Unique S.A. Lima - Perú _ MSN Amor: busca tu ½ naranja http://latam.msn.com/amor/ -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
D3 Automatic Faxing
Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 Automatic Faxing
What about creating a file with the data, and outsourcing it to be done by a blast fax provider? At 100 faxes/day One provider (not as cheap as bulk faxers...but). www.faxaway.com Where you email them in the form of [EMAIL PROTECTED] and the body/document in the email is faxed to the fax#tofaxto All you need is an email gateway Based on the from of the email is whether the email is accepted and/or charged. For small amount of faxes, sometimes this is an easier approach. George -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 1:41 PM To: [EMAIL PROTECTED] Subject: D3 Automatic Faxing Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
UNCLASSIFIED RE: D3 Automatic Faxing
Mark, The last time I did this (it was quite a few years ago) we used an old PC running some free (or very cheap) software that acted as a fax gateway. The software may even have been called 'faxgate'. We created a text file in a directory the gateway could see, it found the file, set up the fax from the information in the text file and pre-stored templates, and sent it. We used it to send out purchase orders and payment advices. I'll forward this to the person who actually did all the work, he may be able to cast a little more light on it. I don't work there anymore so my memory is a bit rusty! :-) HTH Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Wednesday, 17 March 2004 07:41 To: [EMAIL PROTECTED] Subject: D3 Automatic Faxing Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 Automatic Faxing
since it's runing unix, chances are you can setup hylafax which will do what is needed., works off the same principle as faxaway you send an email (locally) and hylafax goes from there. It's quite configurable. It's not off the shelf. On Redhat, there is an RPM, then a config file has be setup. George -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 1:41 PM To: [EMAIL PROTECTED] Subject: D3 Automatic Faxing Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 Automatic Faxing
We autofax reports from a HP-UX, UV9.5 box. We print PCL output to an file, merge a form with it, convert it to G3 TIF, and use sendfax (part of mgetty+sendfax) to do the sending. mgetty + sendfax - http://www.leo.org/~doering/mgetty/ (GPL licensed) We use hp2pbm to convert (hp2hifax is part of it) PCL to G3 TIF the mgetty pages can tell you where to get it. It's worked well enough not to redo it in almost 9 years. rfp [EMAIL PROTECTED] 03/16/04 12:40PM Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: UNCLASSIFIED RE: D3 Automatic Faxing
Yes , it is Hydrafax, now superceded by UnimessagePro from www.wordcraft.com We set up template Word documents, ran it through the fax software to create 'overlay' files. The files from Unidata had embedded lines such as '[[OVERLAY=PURCHASE]]' and '[[PHONE=5550456789]]' to tell the fax software what to do . # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Unable to read LOGS.DIR entry from D_UV_LOGS.
If you're not using transaction logging (TXMODE=0) you can safely ignore this message. It is the UniVerse transaction logging daemon trying to determine where it should keep its log files. If you ARE using transaction logging (TXMODE=1) make sure that you have configured the logs directory. - Original Message - From: Evgenios Charalambus [EMAIL PROTECTED] Date: Tue, 16 Mar 2004 04:26:17 -0800 (PST) To: Discussion Universe [EMAIL PROTECTED] Subject: Unable to read LOGS.DIR entry from D_UV_LOGS. After installing universe 9.5.1 and run the command: bin/uv -admin -stop I got the following errors: Unable to read LOGS.DIR entry from D_UV_LOGS. Unable to open uvdrlogd Daemon info file. Unable to locate UVDR log directory. I tried again start and stop but the error remains. Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help Needed regarding performance improvement of delete query
In a message dated 3/15/2004 9:54:01 AM Eastern Standard Time, [EMAIL PROTECTED] writes: 10 READNEXT ID ELSE STOP READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10 IF DTE GT DEL.DATE THEN GOTO 10 DELETE F.MASTER, ID DELETE F.REFERENCE, ID GOTO 10 I count three goto's So three times through the spank machine. Will -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: D3 Automatic Faxing
I don't know if it runs on D3 or not. Ask Esker Software (U.S. 800-556-4874). We use this product over 2 faxes. We routinely send between 150 to 300 faxes a day and over 600 at Month-End. I monitor it with a 'roll-my-own' package I wrote and it seems quite okay so far. There are NT-based (NTFS required) monitoring and admin tools that are supposed to be nice, but since I run Linux as my desktop OS, I haven't bothered using those tools. I don't know if anyone else is using this product or not. Karl On Tue, 2004-03-16 at 11:40, Mark Johnson wrote: Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- Karl L. Pearson Director of IT, ATS Industrial Supply Direct: 801-978-4429 Toll-free: 888-972-3182 x29 Fax: 801-972-3888 http://www.atsindustrial.com [EMAIL PROTECTED] -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Installing universe as uvadm
Evgenios Universe 9.5 is *not* qualified on AIX 5 - you should be on 10.0.19 or 10.1.1 It may work - but if you hit issues... I would recommend that you get an upgrade from your supplier to avoid possible problems downstream The matrix is on U2TechConnect at http://www.ibm.com.software/data/u2 - check U2TechConnect and Product Availability Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Evgenios Charalambus Sent: 15 March 2004 07:11 To: Discussion Universe Subject: Installing universe as uvadm I am trying to install UNIVERSE 9.5 as uvadm user on AIX 5. The installation fails because of wrong permissions. The manual mentios that the uvadm user must have write permission on the root (/) directory. How can this be acomplished? Is the security of the system compomised by allowing uvadm to write on (/)? Do you Yahoo!? Yahoo! Mail - More reliable, more storage, less spam -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Looking for associated multi-value algorithm...
Well, the first thing I notice is that your for/next counter, SPECIALPART, isn't used anywhere... Using LOCATE will search for the PART.NBR in the whole SPECIAL.PARTS field, so the for/next isn't needed. Next, I notice that this assignment: SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL is duplicated, once just before the IF and once just after the THEN. One of them can probably be dropped. Hope this helps some Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:18 PM To: [EMAIL PROTECTED] Subject: Looking for associated multi-value algorithm... I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Looking for associated multi-value algorithm...
There can, and usually are, multiple instances of the same part number. What makes a row unique is part number + from qty. Thanks for pointing out the doubling up of the SPECIAL.FROM.QTY assignment though. -Original Message- From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 4:28 PM To: 'U2 Users Discussion List' Subject: RE: Looking for associated multi-value algorithm... Well, the first thing I notice is that your for/next counter, SPECIALPART, isn't used anywhere... Using LOCATE will search for the PART.NBR in the whole SPECIAL.PARTS field, so the for/next isn't needed. Next, I notice that this assignment: SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL is duplicated, once just before the IF and once just after the THEN. One of them can probably be dropped. Hope this helps some Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:18 PM To: [EMAIL PROTECTED] Subject: Looking for associated multi-value algorithm... I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Help Needed regarding performance improvement of delete query
Gives Mark the most improved player award. Will In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: LOOP WHILE READNEXT ID DO READV DTE FROM F.MASTER, ID, 5 THEN IF DTE LE DEL.DATE THEN DELETE F.MASTER, ID DELETE F.REFERENCE, ID END END REPEAT there you go (to). -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Looking for associated multi-value algorithm...
It looks like you are using SPECIAL and STARTPOS as paired dummy buffers to walk across the SPECIAL.PARTS, each iteration only searching the remainder from where you left off. That's a little counter-intuitive :) Maybe better nomenclature would make that more apparent. Like Startpos and Currentpos ? I can see why you got this response however, because at first I thought you were wrong again Jason ;) then I read the code again and it hit me what you were doing. Will In a message dated 3/16/2004 6:04:48 PM Eastern Standard Time, [EMAIL PROTECTED] writes: There can, and usually are, multiple instances of the same part number. What makes a row unique is part number + from qty. Thanks for pointing out the doubling up of the SPECIAL.FROM.QTY assignment though. -Original Message- From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 4:28 PM To: 'U2 Users Discussion List' Subject: RE: Looking for associated multi-value algorithm... Well, the first thing I notice is that your for/next counter, SPECIALPART, isn't used anywhere... Using LOCATE will search for the PART.NBR in the whole SPECIAL.PARTS field, so the for/next isn't needed. Next, I notice that this assignment: SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL is duplicated, once just before the IF and once just after the THEN. One of them can probably be dropped. Hope this helps some Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:18 PM To: [EMAIL PROTECTED] Subject: Looking for associated multi-value algorithm... I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Looking for associated multi-value algorithm...
All Righty, then! Just for grins, here's an alternative: SPECIAL.PARTS = SPECIAL.REC12 POS = 0 SPECIAL.FROM.QTY.TEMP = 0 REMOVE SPECIAL.PART.NBR FROM SPECIAL.PARTS SETTING MORE.PARTS POS += 1 IF SPECIAL.PART.NBR = PART.NBR THEN SPECIAL.FROM.QTY = SPECIAL.REC14, POS IF SPECIAL.FROM.QTY QTY.REQUESTED AND SPECIAL.FROM.QTY = SPECIAL.FROM.QTY.TEMP THEN TEMP.POS = POS SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END END WHILE MORE.PARTS DO REPEAT DATA.OUT = OCONV(SPECIAL.REC16, TEMP.POS, MDP) R#12 RETURN Have fun! Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:59 PM To: [EMAIL PROTECTED] Subject: RE: Looking for associated multi-value algorithm... There can, and usually are, multiple instances of the same part number. What makes a row unique is part number + from qty. Thanks for pointing out the doubling up of the SPECIAL.FROM.QTY assignment though. -Original Message- From: Jeff Fitzgerald [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 4:28 PM To: 'U2 Users Discussion List' Subject: RE: Looking for associated multi-value algorithm... Well, the first thing I notice is that your for/next counter, SPECIALPART, isn't used anywhere... Using LOCATE will search for the PART.NBR in the whole SPECIAL.PARTS field, so the for/next isn't needed. Next, I notice that this assignment: SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL is duplicated, once just before the IF and once just after the THEN. One of them can probably be dropped. Hope this helps some Jeff Fitzgerald Fitzgerald Long, Inc. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 3:18 PM To: [EMAIL PROTECTED] Subject: Looking for associated multi-value algorithm... I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
Re: Looking for associated multi-value algorithm...
Perhaps the most glaring problem here is the level of the LOCATE. Since SPECIAL.PARTS is a value and thus possibly multi-valued, the ,STARTPOS indicator suggests to the LOCATE to look at the first subvalue of the value'd. Somehow, especially since STARTPOS isn't previously defined, it become zero and 1,0 is the same as 1 which may accidentally satisfiy the LOCATE. Remove the commaSTARTPOS from the in the LOCATE and the STARTPOS=SPECIAL+1 as they don't contribute anything. Also, this looks like a FIFO/LIFO algorithm. What are the failures if the qtys don't match. The LOCATE should eliminate the FOR...NEXT loop unless you have the PART.NBR in the 12 more than once. In any case, the FOR...NEXT is is useless. If the PART.NBR is in 12 more than once, use FOR...NEXT and do a simple equals test on 12. I don't believe that LOCATE can find occurrences of PART.NBR after the first one it finds. At least using numbers inside the . Perhaps LOCATE X in Y1,STARTPOS on the outside. I don't use it. FInally, if it's any contribution (and it's my purely non-technical opinion). Remove all the extraneous uses of the prefix SPECIAL. That makes it hard to read as all the variables start with SPECIAL and it's hard to identify their purpose quickly. I'm sure I'll get flamed for this, but it does make it more readable. PARTS=SPECIAL.REC12 C.PARTS=DCOUNT(PARTS,VM) QTYS=SPECIAL.REC14 ; PRICES=SPECIAL.REC16 QTEMP=0 FOR I=1 TO C.PARTS IF PARTS1,I=PART.NBR THEN QTY=QTYS1,I IF QTY QTY.REQUESTED AND QTY QTEMP THEN DATA.OUT=OCONV(PRICES1,I,MDP)R#12 QTEMP=QTY END END NEXT I my 2 cents. I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Looking for associated multi-value algorithm...
Group: My apologies for top-posting this - but for those who have already read 6 other variations on this code, it would be a pain to page down below the original request, and for those who have not seen the original request, it would be a pain to have to go find it. There are as many good ways to code this as there are programmers - here is what I would do, preserving the variables as much as possible because I assume this code fragment fits into a larger program and you don't want to have to modify the whole program. STARTPOS = 1 ; * Set the first value to be checked! SPECIAL.VAL = ; * Assuming that you will want this later on eg to decrement the qty if ordered, reserve it, etc. SPECIAL.FROM.QTY.TEMP = 0 SPECIAL.PARTS = SPECIAL.REC12 LOOP LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE SPECIAL = UNTIL SPECIAL = DO SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTY QTY.REQUESTED THEN IF SPECIAL.FROM.QTY.TEMP SPECIAL.FROM.QTY THEN SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY SPECIAL.VAL = SPECIAL ; * the value for the part number desired with the greatest qty at or above desired qty END END STARTPOS = SPECIAL + 1 REPEAT IF SPECIAL.VAL = THEN DATA.OUT = Part :PART.NBR:, Qty :QTY.REQUESTED: not found. ; * or other error logic... END ELSE SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL.VAL ; * You only need to do this once at the end! DATA.OUT = OCONV(SPECIAL.PART.PRICE,MDP)R#12 END RETURN Susan M. Lynch F.W. Davison Company, Inc. Original message from [EMAIL PROTECTED]: I'm looking for an algorithm for searching through a group of associated multi-value fields. The fields are F12 (PartsList), F14 (From Qty) and F16 (Unit Price). I can't depend on these being in any certain order, just that the associated fields will be in identical order. What I want to return is the Unit Price (F16) given PART.NBR and QTY.REQUESTED. I've got a code snippet of what I think will work, but I'd like to get some feedback on it...it won't work because, there's a better way of doing this, etc. Thanks. SPECIAL.PARTS = SPECIAL.REC12 SPECIALCOUNT = DCOUNT(SPECIAL.PARTS,VM) SPECIAL.FROM.QTY.TEMP = 0 FOR SPECIALPART = 1 TO SPECIALCOUNT LOCATE PART.NBR IN SPECIAL.PARTS1,STARTPOS SETTING SPECIAL ELSE EXIT SPECIAL.FROM.QTY=SPECIAL.REC14,SPECIAL IF SPECIAL.FROM.QTYQTY.REQUESTED AND SPECIAL.FROM.QTY=SPECIAL.FROM.QTY.TEMP THEN SPECIAL.FROM.QTY = SPECIAL.REC14,SPECIAL SPECIAL.PART.PRICE = SPECIAL.REC16,SPECIAL TEMP.OUT = OCONV(SPECIAL.PART.PRICE,MDP) R#12 SPECIAL.FROM.QTY.TEMP = SPECIAL.FROM.QTY END STARTPOS = SPECIAL + 1 FIRST = 0 NEXT SPECIALPART DATA.OUT=TEMP.OUT RETURN -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: Help Needed regarding performance improvement of delete query
I personally like this approach... LOOP READNEXT ID ELSE EXIT READV DTE FROM F.MASTER, ID, 5 ELSE CONTINUE IF DTE LE DEL.DATE ELSE CONTINUE DELETE F.MASTER, ID DELETE F.REFERENCE, ID REPEAT That's my $0.02 worth. (If that!) Grant -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 16, 2004 6:08 PM To: U2 Users Discussion List Subject: Re: Help Needed regarding performance improvement of delete query Gives Mark the most improved player award. Will In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time, [EMAIL PROTECTED] writes: LOOP WHILE READNEXT ID DO READV DTE FROM F.MASTER, ID, 5 THEN IF DTE LE DEL.DATE THEN DELETE F.MASTER, ID DELETE F.REFERENCE, ID END END REPEAT there you go (to). -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
RE: D3 Automatic Faxing
If you would consider a commercial product, and have a Windows PRO (or better) machine in the environment, you might consider our WordLynx/ FaxLynx combo. Invoices, statements, orders etc produced via WORD templates (easy for client to change, include new graphics etc) and can then be faxed add MailLynx to the mix and they can be emailed as well if you need .PDF for publishing to web, just add Acrobat to the mix You can download evals, manuals etc from http://www.stamina.com.au/Products/LynxProducts/Products_Downloads.htm Ross Ferris Stamina Software Visage an Evolution in Software Development -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Wednesday, 17 March 2004 5:41 AM To: [EMAIL PROTECTED] Subject: D3 Automatic Faxing Dear All: One of my clients, D3, unix Terian Whitebox Pick server (?) would like to have his system generate roughly 100 faxes per day for invoices and purchase orders. I would be interested what the off-the-shelf approach would be. He has a US Robotics Modem connected to a serial port and all of his users are PC's running Accuterm. One thought is the user-level Blat-like approach whereby the document is downloaded to the user's PC and that PC has a Fax setup as a printer, blah, blah, blah. I'm open for suggestions. Thanks in advance. Mark Johnson -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.627 / Virus Database: 402 - Release Date: 16/03/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.627 / Virus Database: 402 - Release Date: 16/03/2004 -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users