RE: [U2] [UV] Can I get some advice on triggers?
Keith - Not sure if its the same on Universe, but on Unidata, you can type HELP CREATE.TRIGGER at the TCL prompt. The command is: CREATE.TRIGGER filename program name (has to be globally cataloged) UPDATE or DELETE. To create a trigger calling the program CUST.UPD on updates of the CUSTOMER file, you would do the following: CREATE.TRIGGER CUSTOMER CUST.UPD UPDATE Hope it helps. Steve Long Spyderweb Technical Services, Inc. Subject: [U2] [UV] Can I get some advice on triggers? Date: Tue, 27 Nov 2007 17:38:56 +1300 From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Hi, I'm hoping someone can give me some help on triggers. I want to put a trigger on a file to datestamp address changes. The system manual (25119270.pdf) says that triggers aer set up by the command CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE] But when I try that I get an SQL prompt. We don't use SQL at all - is there some way of setting up triggers without it? Is there another manual I should look at? Thanks, Keith. --- 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: RE: [U2] OCONV Extraction Question - Good Practice
Good code. What (TF) is that and how does that relate to a statements inclusion in a manual or not? Explain yourself and - the rules for you are - don't peek in a dictionary or use an electronic grammar or spell checker. ;-) Stuart Boydell Hi Stuart. Ignoring all dictionary and thesaurus explanations available I have a simple definition of good code - is it efficient and can it be easily maintained by someone else? I appreciate that this is an arbitary and difficult to measure standard, but it's my standard nonetheless :-) We have a language that invariably allows a solution to be written in a number of different ways. If I was to work alongside - or worse, after - a programmer that utiilised obscure conversion codes that no-one else understood rather than a simpler to read line of code that did exactly the same thing then I wouldn't be very happy. While my original point was relating to the certification questions, the post from Keith this week where he changed the line of code into something much more readable is a classic example. We may not all agree with precisely how he's done it, but we can probably all see the reason why he did. The discussions about coding that have woken this list up in recent weeks show that there are lots of standards out there, but I think that there is probably one rule that's true to all of us - we all recognise bad code when we see it, even if it was us what wrote it! Colin. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Can I get some advice on triggers?
I'm hoping someone can give me some help on triggers. I want to put a trigger on a file to datestamp address changes. The system manual (25119270.pdf) says that triggers aer set up by the command CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE] On Unidata it's CREATE.TRIGGER FILENAME trigger.name [BEFORE|AFTER|UPDATE] Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Dad - I need most of your attention, not brother. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time Travel
I've got absolutely nothing against Australians as a matter of fact I admire them. If the way they are presented to us back here is correct, they remind me of the way people were in this country fifth years ago but with some added technology. People that believe in life, liberty, and the pursuit of happiness, are willing to die to defend it, and to defend their country. Not a bunch of complainers that can find nothing better to do than to complain about their email coming in an hour instead of minutes when it could have come from the other side of the world. Let the flames begin. Jerry -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 4:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel C'mmon Jerry ... what have you got against Australians and besides, if it WAS located on this side of the Pacific Ditch, based on current performance, you would see DAYS between posts, because it typically takes an hour or two before I see posts too Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, 27 November 2007 6:33 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's something different happening that's causing the lags. We often see as many as 200 emails a second going out of our server, which is an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and running fedora core 4 (old...). Our group members get their emails back within seconds, literally. I send an email to this group, and it sometimes takes an hour or so before I see it come back to me. I send an email to one of my groups at home, and I get it back within seconds. Now then, with that said, I've also added bulk_mailer to my email group server so maybe that speeds things up a great deal. I don't know. I did it so I would quit getting the annoying 'too many email connections from your server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero, juno, gmail, . . . ad infinitum of the 'big' email hosts. My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server... I don't know why, they just aren't the same. Karl quote who=Symeon Breen Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd have to redesign the methods under which the internet manages and routes mail. - Charles Barouch, Moderator --- 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/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- 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] Good Practice?
Maybe your email Nazi isn't releasing your email until he's read it all? :-) -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 5:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Good Practice? Again, your response is out of sequence as so is mine. I see the back slashes today but replied yesterday. Maybe the forum is a better idea. Mark Johnson - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 26, 2007 8:40 AM Subject: RE: [U2] Good Practice? In the case he used it will not show a false positive because he enclosed the F200.SCHEME.CODE in \. -Original Message- From: MAJ Programming [mailto:[EMAIL PROTECTED] Sent: Sunday, November 25, 2007 10:03 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Good Practice? I find this kind of evolved junk a lot. There's one caveat that you should include: TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' CONVERT \ TO CHAR(254) IN TEST LOCATE F200.SCHEME.CODE IN TEST SETTING FOUND THEN ELSE While actual mileage may differ, when having a lookup table and using INDEX, the value of F200.SCHEME.CODE of CK will trigger a false positive. I like to boil down complex boolean expressions into readable words as well. Somehow causes clarity, especially with very verbose variable names. MJ - Original Message - From: Keith Johnson (DSLWN) [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, November 25, 2007 3:52 PM Subject: [U2] Good Practice? Here's an example of how I rewrote some code. Old version 284: * IF F200.SCHEME.CODE = CK1 OR F200.SCHEME.CODE = CK2 OR F200.SCHEME.CODE = NU1 OR F200.SCHEME.CODE = NU2 OR F200.SCHEME.CODE = TK1 OR F200.SCHEME.CODE = TK2 OR F200.SCHEME.CODE = GS1 OR F200.SCHEME.CODE = JM OR F200.SCHEME.CODE = MP3 OR F200.SCHEME.CODE = LHC OR F200.CALC.CODE = H OR F500.S91.ANNUITY.SEQ + 0 = 2 OR F500.S48.ANNUITY.SEQ + 0 = 2 OR F200.SCHEME.CODE = AF1 OR F200.SCHEME.CODE = MP THEN; *002 285: IF F200.SCHEME.CODE = CK1 OR F200.SCHEME.CODE = CK2 OR F200.SCHEME.CODE = NU1 OR F200.SCHEME.CODE = NU2 OR F200.SCHEME.CODE = TK1 OR F200.SCHEME.CODE = TK2 OR F200.SCHEME.CODE = LHC OR F200.CALC.CODE = H OR F500.S91.ANNUITY.SEQ + 0 = 2 OR F500.S48.ANNUITY.SEQ + 0 = 2 OR F200.SCHEME.CODE = MP OR F200.SCHEME.CODE = AF1 THEN ; *002*003 New version 261: THAT = @TRUE 262: *TEST = '\AF1\CK1\CK2\GS1\H\JM\LHC\MP\MP3\NU1\NU2\TK1\TK2\' 263: TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' 264: IF INDEX(TEST,'\':F200.SCHEME.CODE:'\',1) THEN THAT = @FALSE 265: 266: IF F500.S91.ANNUITY.SEQ + 0 GE 2 THEN THAT = @FALSE 267: IF F500.S48.ANNUITY.SEQ + 0 GE 2 THEN THAT = @FALSE I think the new version is easier to maintain (well I would say that), but the code itself is more complex; which is rather interesting. Regards, Keith --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time Travel
Thanks for the donation, Don. It's easy to forget that these things cost $$$. Tom Derwin [EMAIL PROTECTED] 11/26/07 7:55 PM Let me rephrase that. I donated the funds for the domain name and registered it. U2UG owns the domain in whole. I love whois..I should have paid for that privacy thingie too. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Wintegrate scripts
If (like me) you learn much better from looking at already written code: after you go and get the wIntegrate Client Scripting Reference from IBM's website (as Bill suggested), look at C:\Program_Files\wIntegrate\Example\Script\ProdM2.wis (or any of several others in that directory). There are some good examples in there of how to build a dialog box and capture the result of a clicked button. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larson, Eydie Sent: Monday, November 26, 2007 7:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Wintegrate scripts Hello! I am trying to find out if something is possible, and if it is, how to write the script. I want to have an end user press a function key and have that function key run a Wintegrate script that prompts the user for 3 different options. I think this needs to be done using a dialogue box, but I'm not sure. I have never created a dialogue box. I know how to attach a script to a function key. Once the user responds to the 3 different options, I either need to launch Notepad, or an application screen. I also need to capture @LOGNAME from the Wintegrate session. I know I can save and then restore the end user's original Wintegrate session. Any direction that anyone can give me would be MUCH appreciated! Eydie Larson Vice President of Application Development Modular Information Systems 925.244.5930 ext 207 www.miscorp.com --- 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] Badly overflowed Dynamic files
I have yet to find someone who can give me a straight answer to this. I have a file that is badly overflowed (actually, I have a few files this way). It is affecting our batch processing with ridiculous complete times. What would be the best way to increase performance with this file. Do I increase the split load so that splits occur less frequently? Any assistance would be greatly appreciated. Thanks, Kevin The stats of the file: File name .. STOCK Pathname ... STOCK File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 777564 current ( minimum 1, 14835 empty, 247100 overflowed, 28403 badly ) Number of records .. 4770913 Large record size .. 1628 bytes Number of large records 8 Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 2185496576 bytes Total size of record data .. 1253392129 bytes Total size of record IDs ... 32664403 bytes Unused space ... 899435948 bytes Total space for records 2185492480 bytes File name .. STOCK Number per group ( total of 777564 groups ) AverageMinimumMaximum StdDev Group buffers .. 1.37 1 4 0.53 Records 6.14 1 26 3.55 Large records .. 0.00 1 1 0.00 Data bytes . 1611.95194 6893 936.26 Record ID bytes 42.01 4179 24.39 Unused bytes ... 1156.74 12 3560 576.33 Total bytes 2810.69 2048 8192 0.00 Number per record ( total of 4770913 records ) AverageMinimumMaximum StdDev Data bytes .262.72184 2061 25.79 Record ID bytes 6.85 4 15 0.40 Total bytes 269.56188 2076 25.93 -- View this message in context: http://www.nabble.com/Badly-overflowed-Dynamic-files-tf4880009.html#a13965441 Sent from the U2 - Users mailing list archive at Nabble.com. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Practice?
I got an Editing Denied screen from Keith's link. This link works: http://www.pickwiki.com/cgi-bin/wiki.pl?GetKey Looks like a nice piece of code. Thanks, Keith. Enjoy, Tom Derwin [EMAIL PROTECTED] 11/26/07 11:19 PM However, this brings up a good practice thing to note. The seperator must not be 'enterable'. So that makes INPUT a bad idea. If you want to try out an alternative, I just put http://www.pickwiki.com/cgi-bin/wiki.pl?action=editid=GetKey up on the wiki. My problem was that the Asus eeePC does not seem to be a proper xterm, so I reproduced most of the functionality of QM's keycode() input. - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time Travel
Looks like Majordomo sorts the list by domain, then by user. That would put advantos at the beginning of the list with correspondingly fast turnaround. My former domain started with d; now it's l and takes about 30 minutes longer. Regards, Tom [EMAIL PROTECTED] 11/26/07 10:35 PM Scott: I'm not sure what you mean. I usually get an email I post in about 10 minutes. Bill - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time Travel
Maybe the US government isn't allowing the messages to process faster because they need to make sure they are safe for us to read. Because violating our freedoms is necessary to protect our freedom. I won't say anything else for fear of this ending up in my government file. 10:33am EST go! Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, November 27, 2007 8:35 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I've got absolutely nothing against Australians as a matter of fact I admire them. If the way they are presented to us back here is correct, they remind me of the way people were in this country fifth years ago but with some added technology. People that believe in life, liberty, and the pursuit of happiness, are willing to die to defend it, and to defend their country. Not a bunch of complainers that can find nothing better to do than to complain about their email coming in an hour instead of minutes when it could have come from the other side of the world. Let the flames begin. Jerry -Original Message- From: Ross Ferris [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 4:54 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel C'mmon Jerry ... what have you got against Australians and besides, if it WAS located on this side of the Pacific Ditch, based on current performance, you would see DAYS between posts, because it typically takes an hour or two before I see posts too Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Tuesday, 27 November 2007 6:33 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's something different happening that's causing the lags. We often see as many as 200 emails a second going out of our server, which is an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and running fedora core 4 (old...). Our group members get their emails back within seconds, literally. I send an email to this group, and it sometimes takes an hour or so before I see it come back to me. I send an email to one of my groups at home, and I get it back within seconds. Now then, with that said, I've also added bulk_mailer to my email group server so maybe that speeds things up a great deal. I don't know. I did it so I would quit getting the annoying 'too many email connections from your server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero, juno, gmail, . . . ad infinitum of the 'big' email hosts. My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server... I don't know why, they just aren't the same. Karl quote who=Symeon Breen Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd have to redesign the methods under which the internet manages and routes mail. - Charles Barouch, Moderator --- 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/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- 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
Re: [U2] [UV] Can I get some advice on triggers?
Keith, For some reason, they implemented Triggers only with SQL commands. I imagine that lots of people that might ordinarly think about using them have been put off by this. Anyways, the documentation is actually fairly reasonable with regards to this feature. It's in the SQL manual, however. There are good explanations and examples in it. Dave Barrett, Lawyers' Professional Indemnity Company --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Practice?
2 questions: 1. What does nap 5 do? (sleep for 5 milliseconds?) 2. Is KEYIN() on Universe the same IN() on UniData? This is a very nice looking, easy to read and understand routine. Thanks. Ed Burwell Consultant Data Processing CASIO AMERICA, INC. 570 Mt. Pleasant Avenue Dover, NJ 07801 973-361-5400 x1512 email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.casio.com http://www.casio.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thomas Derwin Sent: Tuesday, November 27, 2007 10:18 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Good Practice? I got an Editing Denied screen from Keith's link. This link works: http://www.pickwiki.com/cgi-bin/wiki.pl?GetKey Looks like a nice piece of code. Thanks, Keith. Enjoy, Tom Derwin [EMAIL PROTECTED] 11/26/07 11:19 PM However, this brings up a good practice thing to note. The seperator must not be 'enterable'. So that makes INPUT a bad idea. If you want to try out an alternative, I just put http://www.pickwiki.com/cgi-bin/wiki.pl?action=editid=GetKey up on the wiki. My problem was that the Asus eeePC does not seem to be a proper xterm, so I reproduced most of the functionality of QM's keycode() input. - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ __ This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com. __ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Badly overflowed Dynamic files
Overflowed groups take longer to read, so you want to reduce the number of such groups. Is the size of this file roughly constant, or does it just slowly grow? If it's roughly constant, try setting a MINIMUM.MODULO at around 900,000. It'll hopefully break up a lot of your badly overflowed groups. Or change it away from a dynamic file to a hash-type that better suits your keys. If it grows steadily, try REDUCING your split figure - maybe 70%. Again, that will increase the number of groups, and hopefully reduce your number of overflowed groups. Lastly, I was going to suggest looking at your block size and large records, but I notice you don't have any. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kevinsmith Sent: 27 November 2007 14:59 To: u2-users@listserver.u2ug.org Subject: [U2] Badly overflowed Dynamic files I have yet to find someone who can give me a straight answer to this. I have a file that is badly overflowed (actually, I have a few files this way). It is affecting our batch processing with ridiculous complete times. What would be the best way to increase performance with this file. Do I increase the split load so that splits occur less frequently? Any assistance would be greatly appreciated. Thanks, Kevin The stats of the file: File name .. STOCK Pathname ... STOCK File type .. DYNAMIC Hashing Algorithm .. GENERAL No. of groups (modulus) 777564 current ( minimum 1, 14835 empty, 247100 overflowed, 28403 badly ) Number of records .. 4770913 Large record size .. 1628 bytes Number of large records 8 Group size . 2048 bytes Load factors ... 80% (split), 50% (merge) and 80% (actual) Total size . 2185496576 bytes Total size of record data .. 1253392129 bytes Total size of record IDs ... 32664403 bytes Unused space ... 899435948 bytes Total space for records 2185492480 bytes File name .. STOCK Number per group ( total of 777564 groups ) AverageMinimumMaximum StdDev Group buffers .. 1.37 1 4 0.53 Records 6.14 1 26 3.55 Large records .. 0.00 1 1 0.00 Data bytes . 1611.95194 6893 936.26 Record ID bytes 42.01 4179 24.39 Unused bytes ... 1156.74 12 3560 576.33 Total bytes 2810.69 2048 8192 0.00 Number per record ( total of 4770913 records ) AverageMinimumMaximum StdDev Data bytes .262.72184 2061 25.79 Record ID bytes 6.85 4 15 0.40 Total bytes 269.56188 2076 25.93 -- View this message in context: http://www.nabble.com/Badly-overflowed-Dynamic-files-tf4880009.html#a13965441 Sent from the U2 - Users mailing list archive at Nabble.com. --- 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] Time Travel
Hrm... That makes me sad (zirmed.com) Perry Taylor Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 Zirmed, Inc. 626 West Main St., 6th Floor Louisville, KY 40202 www.zirmed.com -Original Message- From: Thomas Derwin [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 27, 2007 11:39 AM Eastern Standard Time To: u2-users@listserver.u2ug.org Subject:RE: [U2] Time Travel Looks like Majordomo sorts the list by domain, then by user. That would put advantos at the beginning of the list with correspondingly fast turnaround. My former domain started with d; now it's l and takes about 30 minutes longer. Regards, Tom [EMAIL PROTECTED] 11/26/07 10:35 PM Scott: I'm not sure what you mean. I usually get an email I post in about 10 minutes. Bill - This e-mail and any attachments may contain CONFIDENTIAL information, including PROTECTED HEALTH INFORMATION. If you are not the intended recipient, any use or disclosure of this information is STRICTLY PROHIBITED; you are requested to delete this e-mail and any attachments, notify the sender immediately, and notify the LabCorp Privacy Officer at [EMAIL PROTECTED] or call (877) 23-HIPAA / (877) 234-4722. --- 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] Time Travel [not-secure]
snip I won't say anything else for fear of this ending up in my government file. /snip Too late ;) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] How to create NFS mount points in UV
Hi Does anyone have a quick note on now to do this? R Sunny Sunny Matharoo Applications and Database Administrator Tristar Worldwide Chauffeur Services Tel: +44 (0) 1895 432072 Fax: +44 (0) 1895 432098 Mobile: +44 (0) 7793 184144 Email: [EMAIL PROTECTED] www.tristarworldwide.com BLOCKED::blocked::http://www.tristarworldwide.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Good Practice?
Thanks for putting up the right link, Thomas. (dammit, I must measure BEFORE cutting... measure BEFORE cutting... hit self) To answer Ed's questions, 1. nap 5 sleeps for 5 milliseconds. It may not be necessary, so you could comment it out and see how that goes. If you do get comm. delay that causes a problem and don't have nap, try a time-wasting loop - not a sleep command. I tried sleep years ago and it is frustrating. A nap of up to 100 milliseconds is almost unnoticeable in practice. 2. KEYIN() on Universe seems to be exactly the same as IN() on UniData. Regards, Keith PS Here's a silly program showing NAP 001: Crt Bang!: 002: For I = 10 To @CrtWide-20 003: Crt '.': 004: Nap 10 005: Next 006: Crt Ouch! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] How to create NFS mount points in UV
There is a setting in uvconfig called ALLOWNFS which when set to 1, allows the NFS filesystems setup at Unix to be seen and used. Remember one thing, however: No Locks Are Set On The NFS (remote) System! so if there is a uniVerse environment on the remote system, the rule: Last One Out Wins can be a big gotcha. HTH, Karl quote who=Sunny Matharoo Hi Does anyone have a quick note on now to do this? R Sunny Sunny Matharoo Applications and Database Administrator Tristar Worldwide Chauffeur Services Tel: +44 (0) 1895 432072 Fax: +44 (0) 1895 432098 Mobile: +44 (0) 7793 184144 Email: [EMAIL PROTECTED] www.tristarworldwide.com BLOCKED::blocked::http://www.tristarworldwide.com/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
{Blocked Content} RE: [U2] Wintegrate scripts
Warning: This message has had one or more attachments removed Warning: (not named). Warning: Please read the AngelicHost-Attachment-Warning.txt attachment(s) for more information. Thank you! I really do need to see it. Thanks for pointing me to the Example folder, because now I can see the actual script and see what it does when you run it. Very helpful. If (like me) you learn much better from looking at already written code: after you go and get the wIntegrate Client Scripting Reference from IBM's website (as Bill suggested), look at C:\Program_Files\wIntegrate\Example\Script\ProdM2.wis (or any of several others in that directory). There are some good examples in there of how to build a dialog box and capture the result of a clicked button. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larson, Eydie Sent: Monday, November 26, 2007 7:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Wintegrate scripts Hello! I am trying to find out if something is possible, and if it is, how to write the script. I want to have an end user press a function key and have that function key run a Wintegrate script that prompts the user for 3 different options. I think this needs to be done using a dialogue box, but I'm not sure. I have never created a dialogue box. I know how to attach a script to a function key. Once the user responds to the 3 different options, I either need to launch Notepad, or an application screen. I also need to capture @LOGNAME from the Wintegrate session. I know I can save and then restore the end user's original Wintegrate session. Any direction that anyone can give me would be MUCH appreciated! Eydie Larson Vice President of Application Development Modular Information Systems 925.244.5930 ext 207 www.miscorp.com --- 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/ This is a message from the MailScanner E-Mail Virus Protection Service -- The original e-mail attachment winmail.dat was believed to be infected by a virus and has been replaced by this warning message. If you wish to receive a copy of the *infected* attachment, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Tue Nov 27 16:15:32 2007 the virus scanner said: Could not parse Outlook Rich Text attachment Note to Help Desk: Look on the AngelicHost MailScanner in /home/virtual/site2/fst/var/spool/mail.quarantine/20071127 (message lAS0FRpF007158). -- Postmaster --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Standards [was:OCONV Extraction Question - Good Practice]
Colin, excuse my top-posting - I'm using Outlook. Lol. Well it was supposed to be rhetorical and I wasn't expecting a response but since you have; may I cast an opinion that boiling down a definition of good code to being efficient and maintainable and calling it a standard is an oversimplification and well, plain dangerous. Of course code should try to exhibit both qualities but, as you point out, they're value calls and aren't measurable by themselves. Standards should always be concrete. Possibly like: Always use a matching 'END' clause after an 'IF/THEN' construct regardless of the number of statements (eg no single-line IF/THEN conditionals). It's a concrete rule and it can be justified because it makes code 'look' consistent and that's something which helps errors to stand out. It's also no less efficient at runtime to use IF/THEN/END than a single line IF/THEN for a condition with only one statement to be performed. (Whether a shop would actually choose that as a real standard is not the point in this example). Among other qualities of 'good' code, I would say - Does it also perform its function? Obvious to say but does code always handle potential errors? something which I see very little of in certain areas of standard pick code. This can make code quite convoluted... using READU/LOCKED/ON ERROR/ELSE, BEGIN/END TRANSACTION etc. Possibly overengineered, inefficient, even ugly. But is a program performing its function if say, an update gets a ledger out of balance because it doesn't handle a lock, or an out of sync update anomaly correctly. There is the real risk of costly repercussions to the business. I'm sure everyone has seen examples of programs that only blind luck keeps running in production. On the no need to look in a manual therefore it must be maintainable mantra. A hypothetical if you will: You're in a U2 only shop working on a testing the values of a dynamic array variable. Would you a) use a DCOUNT(), FOR/NEXT construct and call IF/THEN multiple times or b) use a single IFS() vector function? (leaving aside REMOVE() for the moment) can you tell me which construct you'd use measured against efficient and maintainable? I'd look at it in light of the efficient and maintainable standard and say: The single IFS() function is an order of magnitude simpler and quanta more efficient than the DCOUNT/FOR/IF/THEN/NEXT. In my mind something which is a simple, single statement is more maintainable than a multi line/multi statement construct. So for my money, it's a lay down misere I'd use the IFS(). However, IFS() isn't used very often in code I've seen. Do you still give in to your standard and use the IFS()? You could make an assumption about the maintenance programmer coming after you. Will they look at IFS(), suddenly go very pale, panic, run screaming out of the room crying 'heresy' and never code again? Or do you give them a smidgeon of credit, that though they have never seen IFS() before, they can open one of the dusty, paper manuals that's been propping up a shelf for the past 20 years and read the explanation of IFS() and work it out (Of course, they could then refactor it back to a FOR/IF/THEN/NEXT construct because they're being paid by the hour). It's a curly path and I reckon that unless you have concrete statement which says - never use or always use vector functions - it's a guideline not a standard. Cheers, Stuart -Original Message- Good code. What (TF) is that and how does that relate to a statements inclusion in a manual or not? Explain yourself and - the rules for you are - don't peek in a dictionary or use an electronic grammar or spell checker. ;-) Stuart Boydell Hi Stuart. Ignoring all dictionary and thesaurus explanations available I have a simple definition of good code - is it efficient and can it be easily maintained by someone else? I appreciate that this is an arbitary and difficult to measure standard, but it's my standard nonetheless :-) We have a language that invariably allows a solution to be written in a number of different ways. If I was to work alongside - or worse, after - a programmer that utiilised obscure conversion codes that no-one else understood rather than a simpler to read line of code that did exactly the same thing then I wouldn't be very happy. While my original point was relating to the certification questions, the post from Keith this week where he changed the line of code into something much more readable is a classic example. We may not all agree with precisely how he's done it, but we can probably all see the reason why he did. The discussions about coding that have woken this list up in recent weeks show that there are lots of standards out there, but I think that there is probably one rule that's true to all of us - we all recognise bad code when we see it, even if it was us what wrote it! Colin. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit
Re: [U2] Good Practice?
Again, the email timing issue. I was responding to the simple index with F200 not bounded. I've used bounding earlier and detected what you were doing. Regarding the extra variable/effort by the SETTING and SET'd variable. I don't care for the argument of counting cycles. Granted, not wasting gross amounts of time is one thing. But who cares about the few alleged cycles that LOCATE would involve. That becomes a sticky debatable point that wastes more time talking about it than it actually does. Given today's extremely fast systems and the tame data requirements of any MV system, poorly written or not, we're not taxing the 4 CPU 3.0 Ghz servers as much as we think. Think about it. Today's RAM is hundreds of times larger than many of our earlier hard drives. Cycles, Schmycles. My 2 cents. Mark Johnson - Original Message - From: Keith Johnson (DSLWN) [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 26, 2007 9:46 PM Subject: RE: [U2] Good Practice? Hi Mark, Just a couple of points. First, the value of F200.SCHEME.CODE of CK *cannot* trigger a false positive. TEST = '\AF1\CK1\CK2\H\LHC\MP\NU1\NU2\TK1\TK2\' IF INDEX(TEST,'\':F200.SCHEME.CODE:'\',1) THEN THAT = @FALSE is fairly bulletproof because of the backslashes around both the string and the substring. Second, I wasn't concerned about LOCATE adding a cycle or two. It's just that one has to provide the SETTING variable which is then ignored. INDEX involves a string, a substring, and a start count - there's virtually nothing redundant. Using LOCATE involves a string, a substring, the position found as well as (possibly) a start position and a search sequence; so it can be regarded as a more complex function. Also, one can choose from three forms of LOCATE - Pick, Ideal/Reality, or Information. Then, to avoid the long setup string, one has to use CONVERT (or SWAP or CHANGE). Regards, Keith PS Good surname - mine's Norwegian in origin... great grandad jumped ship in Auckland. --- 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] Time Travel
If a donation could be made with Pay-Pal, I've got some extra $. If it makes a difference. Thanks Mark Johnson - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 27, 2007 2:34 AM Subject: Re: [U2] Time Travel For the group's edification, at sending out 60,000+ e-mails on some days (more than that when people had nothing better to do at work than flame each other about coding styles), this was one of the problems I had when I hosted the lists. Larry is also being polite and not mentioning that he is footing the bill for this service and bandwidth. So when some people start in on this needs to be corrected, the list has to be faster, and so forth, I would suggest you show him the money. Not meaning to put words in your mouth, Larry. Most of us really (really, really!) appreciate your donation of time and money in support of these lists. Clif.button.push() On Nov 26, 2007, at 9:48 PM, Larry Hiscock wrote: b) I don't want to be blacklisted as a spammer. --- 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] Standards [was:OCONV Extraction Question - Good Practice]
Standards vs Styles. I think Standards are top-down delivered entities in the language from the database providers, ie IBM, Raining Data etc. It's the syntax of commands. Styles are the localized adaptations of the commands, combined for a consistency. They should not extend beyond the horizon of the programs that the 'stylists' have control over. Thus, we can share 'styles' and even vote on them. But we all can choose to pick and choose which ones we feel are better suited for use within our own horizons. IBM and RD give us programmers the same box of crayons respectively. It's up to us to draw with them. Mark Johnson - Original Message - From: Boydell, Stuart [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 27, 2007 9:27 PM Subject: RE: [U2] Standards [was:OCONV Extraction Question - Good Practice] Colin, excuse my top-posting - I'm using Outlook. Lol. Well it was supposed to be rhetorical and I wasn't expecting a response but since you have; may I cast an opinion that boiling down a definition of good code to being efficient and maintainable and calling it a standard is an oversimplification and well, plain dangerous. Of course code should try to exhibit both qualities but, as you point out, they're value calls and aren't measurable by themselves. Standards should always be concrete. Possibly like: Always use a matching 'END' clause after an 'IF/THEN' construct regardless of the number of statements (eg no single-line IF/THEN conditionals). It's a concrete rule and it can be justified because it makes code 'look' consistent and that's something which helps errors to stand out. It's also no less efficient at runtime to use IF/THEN/END than a single line IF/THEN for a condition with only one statement to be performed. (Whether a shop would actually choose that as a real standard is not the point in this example). Among other qualities of 'good' code, I would say - Does it also perform its function? Obvious to say but does code always handle potential errors? something which I see very little of in certain areas of standard pick code. This can make code quite convoluted... using READU/LOCKED/ON ERROR/ELSE, BEGIN/END TRANSACTION etc. Possibly overengineered, inefficient, even ugly. But is a program performing its function if say, an update gets a ledger out of balance because it doesn't handle a lock, or an out of sync update anomaly correctly. There is the real risk of costly repercussions to the business. I'm sure everyone has seen examples of programs that only blind luck keeps running in production. On the no need to look in a manual therefore it must be maintainable mantra. A hypothetical if you will: You're in a U2 only shop working on a testing the values of a dynamic array variable. Would you a) use a DCOUNT(), FOR/NEXT construct and call IF/THEN multiple times or b) use a single IFS() vector function? (leaving aside REMOVE() for the moment) can you tell me which construct you'd use measured against efficient and maintainable? I'd look at it in light of the efficient and maintainable standard and say: The single IFS() function is an order of magnitude simpler and quanta more efficient than the DCOUNT/FOR/IF/THEN/NEXT. In my mind something which is a simple, single statement is more maintainable than a multi line/multi statement construct. So for my money, it's a lay down misere I'd use the IFS(). However, IFS() isn't used very often in code I've seen. Do you still give in to your standard and use the IFS()? You could make an assumption about the maintenance programmer coming after you. Will they look at IFS(), suddenly go very pale, panic, run screaming out of the room crying 'heresy' and never code again? Or do you give them a smidgeon of credit, that though they have never seen IFS() before, they can open one of the dusty, paper manuals that's been propping up a shelf for the past 20 years and read the explanation of IFS() and work it out (Of course, they could then refactor it back to a FOR/IF/THEN/NEXT construct because they're being paid by the hour). It's a curly path and I reckon that unless you have concrete statement which says - never use or always use vector functions - it's a guideline not a standard. Cheers, Stuart -Original Message- Good code. What (TF) is that and how does that relate to a statements inclusion in a manual or not? Explain yourself and - the rules for you are - don't peek in a dictionary or use an electronic grammar or spell checker. ;-) Stuart Boydell Hi Stuart. Ignoring all dictionary and thesaurus explanations available I have a simple definition of good code - is it efficient and can it be easily maintained by someone else? I appreciate that this is an arbitary and difficult to measure standard, but it's my standard nonetheless :-) We have a language that invariably allows a solution to be written in a number of
