Re: [U2] Universe Triggers
However, before you can add or activate any triggers, you must GRANT GRANT privileges to the user Attempting to add the triggers while you are the user uvsql if you want that user to be able To add triggers, otherwise, you will have to be user uvsql for any trigger activity. I also found you can not have any , * or - in the filename if you want to add triggers to it, If that is the case, you must create a Q pointer to the file with a name that is acceptable. You can not add a trigger to a file that is a q pointer to another directory, UNLESS, you create The Q pointer as a F type Voc entry, and use the full pathname to the files - then it's not Technically a Q pointer, but still behaves like one! These were things that I had the most trouble getting over Also, make sure any files that the trigger program will need are accessable. So if you put a trigger On a file, and the trigger program opens FILE A, and your in Account A - you must make sure that FILE A can be opened in Account A. If you move to Account B and the file that has the trigger on And you have a Q pointer to that file, make sure Account B has access to FILE A otherwise your Trigger program will bomb out. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: Thursday, July 18, 2013 8:33 AM To: U2 Users List Subject: Re: [U2] Universe Triggers Yes. Check out the SQL Reference Manual. The Trigger subroutine has a set defined number of parameters (it's in the doc). We use account type Pick (non-Schema) so a few notes: -Create a new VOC entry named ICATALOG (copy from CATALOG and change attr 6 to INFORMATION.FORMAT). Use this to catalog your Trigger Subroutine. -When we add Triggers to files, we always have all users logged off (paranoid). Here's a sample trigger subroutine (not a real program, only a demo) : SUBROUTINE TRIGGER.EXAMPLE(TRIGGER.NAME,SCHEMA,TABLE,EVENT,TIME, NEW.RECORD.ID,NEW.RECORD,OLD.RECORD.ID, OLD.RECORD,ASSOCIATION,ASSOCIATION.EVENT,COUNT,CHAIN.CASCADE,CASCADE) : OPEN 'AUDIT' TO AUDIT ELSE RETURN : * : UPDATE.TYPE = EVENT[1,1] ; * U,D,I : * : IF NEW.RECORD # OLD.RECORD THEN : READU X FROM AUDIT,NEW.RECORD.ID ELSE NULL : WRITE DATE():*:TIME() ON AUDIT,NEW.RECORD.ID : END : RETURN ; * RETURN TO CALLING PROGRAM :END Mark -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel Jorgenson Sent: Wednesday, July 17, 2013 3:32 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe Triggers Has anyone setup and used Unix/Universe triggers. Where do you start? Any manuals to get started? Regards, Dan Jorgenson Senior Systems Analyst SICK, Inc. 6900 West 110th Street Minneapolis, MN 55438 USA Phone: 952.941.6780 Fax: 952.941.9287 Direct: 952.829.4732 http://www.sickusa.com This message and any attachments are solely for the intended recipient and may contain confidential or privileged information. If you are not the intended recipient, any disclosure, copying, use or distribution is prohibited. If you have received this communication in error, please notify us by reply email and immediately and permanently delete this message and any attachments. Thank you. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] CentOS with Universe?
Has anyone tried running on Windows Core? Thats the preferred option for HIgh Availability with Sql Server. Dont know if that is possible for uv. Sent from my iPhone On 18 Jul 2013, at 05:11, Tony Gravagno 3xk547...@sneakemail.com wrote: Dawn, you and I have had chats about Windows vs Linux before. In many ways the landscape has changed but honestly it's still the same for many of the reasons you had for avoiding Windows in the first place. My approach is the be versatile and many of our colleagues do the same - just use whatever works in a given context and try not to lock yourself in to any one OS. While that does introduce a need to add more skills into the toolkit, overall it's not that bad. I have more issues shifting mental gears between MV environments than OS's. My rule of thumb is to use IIS when I need .NET and Windows tools but to use Linux when I need shell and common FOSS packages like Drupal, WordPress, Bugzilla, etc. I don't care if I should be able to run WAMP, most GNU-based FOSS these days is coded with prejudice against Windows and we simply need LAMP to run it. All in all, while I haven't settled on a single provider yet, I have tried services with Amazon, RackSpace, Dreamhost, and a couple others I can't recall. They're pretty much all the same except when it comes to support when you really need it - caveat emptor. There are a few companies in our industry who also specialize in hosting MV environments - take a look around. As far as hosting, root-access hosts are dirt-cheap these days, and most don't weigh you down with licensing issues anymore either. With the exception of MV DBMS vendors, most tier-1 providers recognize that they make more from having a 10, 100, or 1000 systems out there than they do trying to get a single site to pay for 10, 100, or 1000 licenses. (Rant on clueless MV marketing and industrial suicide omitted.) Finally, we're talking about doing business. If you're running a production server then your revenue needs to cover the total expense of doing business. You're not paying support fees, your clients are, and if that eats into your expected profits and budgeting then perhaps your business model needs a tweak rather than taking chances with lack of support. If you're not charging for services then you should consider a freemium model, as this is how other sites manage. If this is a totally unfunded operation then perhaps going with freeware is your best option. HTH T From Dawn Wolthuis We are nailing down costs from the hosting provider for each option. It looks like Windows 2008 Standard is less expensive per month than RHEL 6 with the hosting site we are using (primarily because of the $500 annual cost for RHEL). My colleague uses his own perl scripts with apache, so he is not excited about IIS. My only issue with IIS has to do with poor experiences to date, but when I check the date, it is somewhere around 2001. Perhaps I need not hold a grudge that long? cheers! --dawn ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Benton Scheduler
I am looking for source code for Infocus's Benton scheduler. As far as i can tell Infocus has disappeared from this planet. Our organisation is having some challenges with reinstalling Benton. I am also looking for other scheduler options. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Benton-Scheduler-tp41282.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Triggers
Ken, I am glad you raised the issue about debugging a program with a file which has a trigger attached. I have been on to UV (Vmark/Ardent/IBM/Rocket for ages about fixing this pushing for the ability to be able to step into the trigger code, but at a VERY MINIMUM being able to debug the program and perform the write on the file, and in effect step over the trigger subroutine and carry on debugging. The issue is the trigger subroutine cannot support input, so what UV have done is basically say you are using the debugger so you are inputting debug commands so you will abort. They need to turn this restriction off for debugging so that either of the above two scenarios is supported. In a Microsoft world I can debug anything through the connected world of web/databases etc.. Have had no feedback from UV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Friday, 19 July 2013 9:48 a.m. To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Triggers Dan, In addition to the other responses you have received, I suggest the following: 1. Have one master file trigger subroutine (globally catalogued) that calls subroutines (locally catalogued) tailored to individual files. This means you don't have to stop and restart Universe when a new trigger is required or a change to an existing one. If the master subroutine changes, you do have to restart Universe. 2. Use a control record that records the subroutine name and state of the trigger for each file having a trigger. 3. Use a program to change the state of a trigger, using the control records in 2 above. 4. Make sure all background processes that have a file with a trigger open are logged out when recompiling the subroutine for that file trigger. 5. Remember that you can't do anything to a file with an active trigger whilst in the RAID debugger (it will crash). Rather, if you are testing a file trigger subroutine, drop the trigger and use a trigger testing program that calls the subroutine after taking a copy of the record being changed, pausing whilst you change it in another session, and then resuming, calling the subroutine. If you would like samples of any of the software mentioned above, let me know, and I can send them to you. Regards, Ken Ford Universe Software Developer t 07 3013 8605 | f 07 3002 8400 e ken.f...@firstmac.com.au | w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Benton Scheduler
To Riverman, I have not heard of the Benton scheduler and I'm not sure what sort of scheduler you're looking for, but we have a Finite Scheduling scheduler associated with the Shop Floor Control module of our discrete Manufacturing software suite. I'll be glad to send you some information on it if you're interested. Best wishes in finding your new scheduler, Dave Taylor Sysmark Information Systems, Inc. 1-800-SYSMARK (1-800-797-6275) I am looking for source code for Infocus's Benton scheduler. As far as i can tell Infocus has disappeared from this planet. Our organisation is having some challenges with reinstalling Benton. I am also looking for other scheduler options. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Benton-Scheduler-tp41282.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SBClient Issue
I dunno if this is the situation here, but a Google search for dde flush returns some hits that indicate you may need to flush the DDE buffer before exiting. HTH [related plug] : http://Nebula-RnD.com/products/xlite.htm From: Al DeWitt We have a custom report that was written using paragraphs and the DDE functionality. Our process is to 1)Open an Excel Worksheet 2)Run the report which outputs to the worksheet. We are encountering situations where the report appears to work normally but not all the data is written to Excel. This was first noticed on Excel 2010, but I am able to reproduce this on Excel 2003 as well. Is there some temporary file or buffer in SB+/SBClient that I might need to expand the size of? If so what is the name of it? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Benton Scheduler
Hi: We have a scheduler built-in to our middle-ware called U2WebLink that is web based running on Apache Tomcat. You have to have the jobs submitted via the web and it uses open source Java library called Quartz for cron like scheduling. I can send you more information if that is something you are interested in. Regards, Doug www.u2logic.com U2WebLink middle-ware for Universe and Unidata sites On Thu, Jul 18, 2013 at 4:46 PM, David Taylor da...@sysmarkinfo.com wrote: To Riverman, I have not heard of the Benton scheduler and I'm not sure what sort of scheduler you're looking for, but we have a Finite Scheduling scheduler associated with the Shop Floor Control module of our discrete Manufacturing software suite. I'll be glad to send you some information on it if you're interested. Best wishes in finding your new scheduler, Dave Taylor Sysmark Information Systems, Inc. 1-800-SYSMARK (1-800-797-6275) I am looking for source code for Infocus's Benton scheduler. As far as i can tell Infocus has disappeared from this planet. Our organisation is having some challenges with reinstalling Benton. I am also looking for other scheduler options. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Benton-Scheduler-tp41282.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Benton Scheduler
Hi, Infocus was owned by Lee Leitner, who also wrote Benton. The last I knew Lee was a professor at Drexel University. I have no idea if he still does anything with Benton or not. Here is the last contact information that I have for Lee: Lee Leitner, PhD Auxiliary Associate Professor Tel:+1 (215) 895-2449 Fax:+1 (215) 895-2494 Email: lee.leit...@ischool.drexel.edu Good luck! Jeff Fitzgerald Fitzgerald Long, Inc. www.fitzlong.com On Thu, Jul 18, 2013 at 2:59 PM, Riverman amas...@trustee.bc.ca wrote: I am looking for source code for Infocus's Benton scheduler. As far as i can tell Infocus has disappeared from this planet. Our organisation is having some challenges with reinstalling Benton. I am also looking for other scheduler options. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Benton-Scheduler-tp41282.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] AUTO: Thomas Boadu is out of the office. (returning 22/07/2013)
I am out of the office until 22/07/2013. I will respond to your message when I return. If urgent please phone the helpdesk on 0038696 or from your handset and choose options 3 and1 Note: This is an automated response to your message Re: [U2] SBClient Issue sent on 19/07/2013 00:17:03. This is the only notification you will receive while this person is away. First Capital Connect Limited. Registered in England Wales No. 05281077. Registered office: 50 Eastbourne Terrace, Paddington, London, W2 6LG. This message is confidential. It may not be disclosed to, or used by, anyone other than the addressee. If you receive this message in error, please advise us immediately. Internet email is not necessarily secure. First does not accept responsibility for changes to any email which occur after the email has been sent. Attachments to this email could contain software viruses which could damage your system. First have checked the attachments for viruses before sending, but you should virus-check them before opening. For more information on our range of services or to book your tickets online, please visit:- http://www.firstgroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users