Re: [U2] Installing UniObjects on Windows 2008 64 bit
Keep in mind that 2008 has User Account Control like vista and 7. Its microsoft's crappy version of sudo in unix/linux. So I believe what some may be suggesting is that not only should you be logged in as Administrator, BUT, you should right click the executable and select Run as Administrator when installing. On 6/13/11, Bill Haskett wphask...@advantos.net wrote: Jim: I installed the U2 client from the udt_7.2acl.zip file onto Windows 2008 R2. It installed just fine. One thing I always do on Win 2008 R2 is run everything like this as administrator. There is so much that can go wrong, and very few people know how to resolve permissions issues. HTH, Bill - Original Message - *From:* jim.sto...@esc.edu *To:* u2-users@listserver.u2ug.org *Date:* 6/13/2011 2:07 PM *Subject:* [U2] Installing UniObjects on Windows 2008 64 bit Hello, We have a UniData server and are using UniObjects to access it from our web servers (using Lotus Notes/Domino). We have UniObjects working in Domino's Lotusscript scripting language on our production servers running Windows 2003. It also works on my desktop running Windows XP. I just tried to install the UniData client (udt_7.2acl, downloaded today from Rocket's website) on a development machine running Windows 2008 R2 64 bit, and the Domino agent that calls the Uniobjects.UnioaifCtrl object always fails with the error: ERROR 208 : Cannot create automation object. The UniObjects manual mentions that if you get an error saying it cannot create object that UniObjects didn't install property and instructing you to try re-installing. I've re-installed it three times with no luck. The UniData client installer runs fine, and seems to install the UniDevelopers Kit (the element that installs UniObjects) without any errors. There are no errors in the server's event log, and the file uniobjects.dll is placed into the C:\Windows\SysWOW64 directory on the server, which seems to be correct for a 32-bit dll on a Windows 2008 server. Next I downloaded and installed Microsoft's OLE/COM Object Viewer (a Windows 2008 compatible version is in the Windows 7 SDK installer), and installed that on both my desktop and the Windows 2008 server. On my desktop, the viewer shows that the UnioaifCtrl class is registered/installed. However, the UnioaifCtrl class does not appear in the viewer on the Windows 2008 server. Maybe the installation didn't register the object? Has anyone installed the UniData client, especially UniObjects, on Windows 2008 R2? Does anyone have any suggestions about why the client installer wouldn't be registering the automation object, or how to proceed? Thank you, Jim Stoner ___ 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 -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Enterprise Scheduling solution
We use plain old cron in AIX. If you get your korn shell initialization set right in the shell script you call U2 from you can do almost anything. BASIC will do anything cron won't. Let me know if you need more details... Kind of hard to type them out on a blackberry. On 6/13/11, Baker Hughes baker.hug...@mouser.com wrote: Many MV systems have some kind of home-brewed or even purchased scheduling solution for handling batch processes. Many times, in distribution or manufacturing ERP applications, certain processes such as Aging A/R, or stock replenishment/reserving, is performed 'after hours' by these schedulers. We've all worked with one or perhaps written our own. We have one of these, that gets the job done. Does anyone know of an Enterprise Scheduler solution that can handle jobs across a heterogeneous enterprise, that is also MV or *nix compatible? Rather than try and take our UniVerse based scheduler front end to the next level of perfection, we need a job/phantom/scheduler solution that would allow an Operator with little or no MV knowledge to monitor/adjust/manage jobs across a plethora of different OS-based enterprise applications. The Enterprise Scheduler we are interested in can be MV based, or other DB based, but must have a graphical front end, and must be able to manage jobs on non-MV systems as well as MV systems. Thanks for any ideas. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Enterprise Scheduling solution
Cron is great however sounds like the op wants something much much more than cron :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: 14 June 2011 12:54 To: U2 Users List Subject: Re: [U2] Enterprise Scheduling solution We use plain old cron in AIX. If you get your korn shell initialization set right in the shell script you call U2 from you can do almost anything. BASIC will do anything cron won't. Let me know if you need more details... Kind of hard to type them out on a blackberry. On 6/13/11, Baker Hughes baker.hug...@mouser.com wrote: Many MV systems have some kind of home-brewed or even purchased scheduling solution for handling batch processes. Many times, in distribution or manufacturing ERP applications, certain processes such as Aging A/R, or stock replenishment/reserving, is performed 'after hours' by these schedulers. We've all worked with one or perhaps written our own. We have one of these, that gets the job done. Does anyone know of an Enterprise Scheduler solution that can handle jobs across a heterogeneous enterprise, that is also MV or *nix compatible? Rather than try and take our UniVerse based scheduler front end to the next level of perfection, we need a job/phantom/scheduler solution that would allow an Operator with little or no MV knowledge to monitor/adjust/manage jobs across a plethora of different OS-based enterprise applications. The Enterprise Scheduler we are interested in can be MV based, or other DB based, but must have a graphical front end, and must be able to manage jobs on non-MV systems as well as MV systems. Thanks for any ideas. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1513/3702 - Release Date: 06/13/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniOLEDB and Windows 2008/SQL 2008
Yeah! Someone else with the same problem! If your SQL install is the 64bit version there are 3rd party bridge software pieces you can buy to bridge from the 64bit environment to the 32bit driver. I have no real suggestions on what works so I won't mention any names. I think all are going to be fairly expensive. Rocket is working on a 64bit driver but has no ETA yet. If you install the 32bit driver and install a 32bit version of SQL they should work even though you are running a 64bit OS. I say should because we have not yet confirmed it does. We should find out this week if we get time to test it. I suggest calling or emailing rocket software and get on their beta program so you get the 64bit driver as soon as they think they got it working. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Louise Yang Sent: Tuesday, June 07, 2011 5:25 PM To: 'U2 Users List' Subject: [U2] UniOLEDB and Windows 2008/SQL 2008 I'm trying to migrate SSIS packages from Windows 2003/SQL 2005 to Windows 2008/SQL 2008 and all the packages use UniOLEDB provider which doesn't' work with 64-bit Windows 2008. Any suggestions? -Louise Yang ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Enterprise Scheduling solution
I have not used it, but wish I had time to tinker with it. Task Forest looks interesting. http://www.taskforest.com/ It is open src, but commercial support is available. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Enterprise Scheduling solution
You should check out Benton, it works on Unix and Windows OS, and is U2 based so it can run paragraphs, procs, programs etc. Very flexible. I have used it for more years than I care to admit. :D. The link is http://www.infocus50.com/benton.htm Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, June 14, 2011 9:18 AM To: 'U2 Users List' Subject: Re: [U2] Enterprise Scheduling solution Cron is great however sounds like the op wants something much much more than cron :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: 14 June 2011 12:54 To: U2 Users List Subject: Re: [U2] Enterprise Scheduling solution We use plain old cron in AIX. If you get your korn shell initialization set right in the shell script you call U2 from you can do almost anything. BASIC will do anything cron won't. Let me know if you need more details... Kind of hard to type them out on a blackberry. On 6/13/11, Baker Hughes baker.hug...@mouser.com wrote: Many MV systems have some kind of home-brewed or even purchased scheduling solution for handling batch processes. Many times, in distribution or manufacturing ERP applications, certain processes such as Aging A/R, or stock replenishment/reserving, is performed 'after hours' by these schedulers. We've all worked with one or perhaps written our own. We have one of these, that gets the job done. Does anyone know of an Enterprise Scheduler solution that can handle jobs across a heterogeneous enterprise, that is also MV or *nix compatible? Rather than try and take our UniVerse based scheduler front end to the next level of perfection, we need a job/phantom/scheduler solution that would allow an Operator with little or no MV knowledge to monitor/adjust/manage jobs across a plethora of different OS-based enterprise applications. The Enterprise Scheduler we are interested in can be MV based, or other DB based, but must have a graphical front end, and must be able to manage jobs on non-MV systems as well as MV systems. Thanks for any ideas. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1513/3702 - Release Date: 06/13/11 ___ 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] Enterprise Scheduling solution
Does anyone know of an Enterprise Scheduler solution that can handle jobs across a heterogeneous enterprise, that is also MV or *nix compatible? We use AutoSys from CA. Runs on probably any platform you'd want it to run on. It's big and I'm sure it's not cheap. But it works pretty well. A lot of flexibility in setting up sequences of jobs based on reasonably complex success/failure conditions. We hook into UD via shell scripts that AutoSys calls. The Enterprise Scheduler we are interested in can be MV based, or other DB based, but must have a graphical front end AutoSys runs on Oracle and has a GUI. We could talk offline if you want to dig into it a bit more to see if AutoSys is a fit. Brad. U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Enterprise Scheduling solution
Yeah... I did not read the last part. Cron is not a non-technical person tool. On 6/14/11, Symeon Breen syme...@gmail.com wrote: Cron is great however sounds like the op wants something much much more than cron :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: 14 June 2011 12:54 To: U2 Users List Subject: Re: [U2] Enterprise Scheduling solution We use plain old cron in AIX. If you get your korn shell initialization set right in the shell script you call U2 from you can do almost anything. BASIC will do anything cron won't. Let me know if you need more details... Kind of hard to type them out on a blackberry. On 6/13/11, Baker Hughes baker.hug...@mouser.com wrote: Many MV systems have some kind of home-brewed or even purchased scheduling solution for handling batch processes. Many times, in distribution or manufacturing ERP applications, certain processes such as Aging A/R, or stock replenishment/reserving, is performed 'after hours' by these schedulers. We've all worked with one or perhaps written our own. We have one of these, that gets the job done. Does anyone know of an Enterprise Scheduler solution that can handle jobs across a heterogeneous enterprise, that is also MV or *nix compatible? Rather than try and take our UniVerse based scheduler front end to the next level of perfection, we need a job/phantom/scheduler solution that would allow an Operator with little or no MV knowledge to monitor/adjust/manage jobs across a plethora of different OS-based enterprise applications. The Enterprise Scheduler we are interested in can be MV based, or other DB based, but must have a graphical front end, and must be able to manage jobs on non-MV systems as well as MV systems. Thanks for any ideas. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1382 / Virus Database: 1513/3702 - Release Date: 06/13/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Sent from my mobile device John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata command stack (history)
If you think U2's stack is bad, take a look at D3's. The pits! I've used my own stacker for so many years, I can't stand to use others. One of the nice things is that if I want a new capability, I just add it. I have it set for 1000 lines right now, and usually keep 8 Jbase sessions open. Each has its own stack, but can borrow from the others as needed. Charlie Noah Charles W. Noah Associates cwn...@comcast.net View Charlie Noah's profile on LinkedIn http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 06-13-2011 9:13 PM, Bill Haskett wrote: Jeff: The U2 command stack is completely neanderthal. I've been using UD for awhile and have ignored the U2 stack completely. I run a home-written shell. There's one on Pickwiki and I have one I'd be glad to give you. Here's some documentation on the U2 stack The UniData command stack stores statements entered from the ECL command line and allows you to recall, edit, reexecute, or save them. If you make a typographical error in a command, the command stack feature allows you to correct the error without having to retype the entire statement. By default, UniData stores up to 49 commands in the command stack. To change the default, you can set the CSTACKSZ environment variable to save a specified number of command lines. Each command line can contain up to 2720 characters. See Administering UniData for information about setting UniData environment variables.Note: If you change the value of the CSTACKSZ environment variable on Windows platforms, you must restart UniData for the change to take effect. When you enter a statement on the ECL command line, UniData stores it in position 1 of the stack. As you enter more commands, UniData pushes prior commands in the stack up one position and inserts the current command in position 1 of the stack. When a command moves beyond the stack's limit, it is discarded. The command stack for each user is saved in a file called .ustk_logname in the directory of the current UniData account. Each time you enter UniData, the stack is recalled. HTH, Bill - Original Message - *From:* jbut...@hampshire.edu *To:* u2-users@listserver.u2ug.org *Date:* 6/13/2011 5:50 PM *Subject:* [U2] Unidata command stack (history) Unidata 7.2.9 on linux Is there a UDT.OPTION or other setting that can control the size of the command stack (history)? We max out at 99 and I'd really like to have it recall more - but cannot find an option to do this. ___ 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] Unidata command stack (history)
This might help, maybe... I found an option in Universe that you can do at TCL. COMMAND.EDITOR ON Its still fairly lame, but, at least you can use the up arrow. Thanks for the info about the one on PickWiki. On Tue, Jun 14, 2011 at 10:37 AM, Charlie Noah cwn...@comcast.net wrote: If you think U2's stack is bad, take a look at D3's. The pits! I've used my own stacker for so many years, I can't stand to use others. One of the nice things is that if I want a new capability, I just add it. I have it set for 1000 lines right now, and usually keep 8 Jbase sessions open. Each has its own stack, but can borrow from the others as needed. Charlie Noah Charles W. Noah Associates cwn...@comcast.net View Charlie Noah's profile on LinkedIn http://www.linkedin.com/in/charlienoah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 06-13-2011 9:13 PM, Bill Haskett wrote: Jeff: The U2 command stack is completely neanderthal. I've been using UD for awhile and have ignored the U2 stack completely. I run a home-written shell. There's one on Pickwiki and I have one I'd be glad to give you. Here's some documentation on the U2 stack The UniData command stack stores statements entered from the ECL command line and allows you to recall, edit, reexecute, or save them. If you make a typographical error in a command, the command stack feature allows you to correct the error without having to retype the entire statement. By default, UniData stores up to 49 commands in the command stack. To change the default, you can set the CSTACKSZ environment variable to save a specified number of command lines. Each command line can contain up to 2720 characters. See Administering UniData for information about setting UniData environment variables.Note: If you change the value of the CSTACKSZ environment variable on Windows platforms, you must restart UniData for the change to take effect. When you enter a statement on the ECL command line, UniData stores it in position 1 of the stack. As you enter more commands, UniData pushes prior commands in the stack up one position and inserts the current command in position 1 of the stack. When a command moves beyond the stack's limit, it is discarded. The command stack for each user is saved in a file called .ustk_logname in the directory of the current UniData account. Each time you enter UniData, the stack is recalled. HTH, Bill - Original Message - *From:* jbut...@hampshire.edu *To:* u2-users@listserver.u2ug.org *Date:* 6/13/2011 5:50 PM *Subject:* [U2] Unidata command stack (history) Unidata 7.2.9 on linux Is there a UDT.OPTION or other setting that can control the size of the command stack (history)? We max out at 99 and I'd really like to have it recall more - but cannot find an option to do this. ___ 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 -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniData Triggers
We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation requires exclusive access to the file or not. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Triggers
UniData handles it just fine. You need to be the owner of the data file or root to build the trigger. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of shaun.fergu...@ferguson.com Sent: Tuesday, June 14, 2011 10:54 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniData Triggers We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation requires exclusive access to the file or not. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ 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] UniData Triggers
On 06/14/11 10:54, shaun.fergu...@ferguson.com wrote: We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation requires exclusive access to the file or not. I've had no issues setting up triggers on our production system with users logged in. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Triggers
Shaun: Remember, when you start going down the trigger path in UD, you may want to simply create two globally cataloged routines: U2.MASTER.TRIGGER.D U2.MASTER.TRIGGER.U ...or something like this. These two triggers simply call defined subroutines. We use a TRIGGER.CONF file like: 001 FileName@VMFileName@VMFileName... 002 UpdSubroutine@SVMUpdSubroutine@VMUpdSubroutine@VMUpdSubroutine... 003 DelSubroutine@SVMDelSubroutine@VMDelSubroutine@VMDelSubroutine... ...where field# 2 is used by the update trigger and field# 3 is used by the delete trigger. With a structure like this you'll be able to insert and remove subroutines into triggers (after you create the trigger), and use local subroutines. Plus none of the trigger programs, except the two master trigger programs, will need to be globally cataloged. HTH, Bill - Original Message - *From:* shaun.fergu...@ferguson.com *To:* u2-users@listserver.u2ug.org *Date:* 6/14/2011 7:54 AM *Subject:* [U2] UniData Triggers We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation requires exclusive access to the file or not. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.comblocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ 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] UniData Triggers
Hi, Problems on triggers comes when deleting a trigger while users are updating : if doing so, all future update of session which have opened file with trigger will fail if trigger has changed. There has been a good mail on triggers months ago. Generally, it's better to put a master trigger (which never will change) and a slave trigger called by master. Management tasks on triggers could be done online on slave. True with UniVerse. Don't know with UniData. Cheers. Christian -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] De la part de Jeffrey Butera Envoyé : mardi 14 juin 2011 17:16 À : u2-users@listserver.u2ug.org Objet : Re: [U2] UniData Triggers On 06/14/11 10:54, shaun.fergu...@ferguson.com wrote: We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation requires exclusive access to the file or not. I've had no issues setting up triggers on our production system with users logged in. -- Jeff Butera, Ph.D. Manager of ERP Systems Hampshire College jbut...@hampshire.edu 413-559-5556 ...we must choose between what is right and what is easy... Dumbledore ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Ce message et les pièces jointes sont confidentiels et réservés à l'usage exclusif de ses destinataires. Il peut également être protégé par le secret professionnel. Si vous recevez ce message par erreur, merci d'en avertir immédiatement l'expéditeur et de le détruire. L'intégrité du message ne pouvant être assurée sur Internet, la responsabilité du groupe Atos Origin ne pourra être recherchée quant au contenu de ce message. Bien que les meilleurs efforts soient faits pour maintenir cette transmission exempte de tout virus, l'expéditeur ne donne aucune garantie à cet égard et sa responsabilité ne saurait être recherchée pour tout dommage résultant d'un virus transmis. This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it. As its integrity cannot be secured on the Internet, the Atos Origin group liability cannot be triggered for the message content. Although the sender endeavours to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Triggers
I agree! Triggers must be globally cataloged, but they can CALL a locally/directly cataloged subroutine that does all the real work. Also remember to CLOSE your files in the trigger program or you might hit a max file limit (this might not be an issue if the OPENs are done in the 2nd subroutine, but they will burn you for sure if they are in the parent subroutine). John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Tuesday, June 14, 2011 12:02 PM To: U2 Users List Subject: Re: [U2] UniData Triggers Shaun: Remember, when you start going down the trigger path in UD, you may want to simply create two globally cataloged routines: U2.MASTER.TRIGGER.D U2.MASTER.TRIGGER.U ...or something like this. These two triggers simply call defined subroutines. We use a TRIGGER.CONF file like: 001 FileName@VMFileName@VMFileName... 002 UpdSubroutine@SVMUpdSubroutine@VMUpdSubroutine@VMUpdSubroutine... 003 DelSubroutine@SVMDelSubroutine@VMDelSubroutine@VMDelSubroutine... ...where field# 2 is used by the update trigger and field# 3 is used by the delete trigger. With a structure like this you'll be able to insert and remove subroutines into triggers (after you create the trigger), and use local subroutines. Plus none of the trigger programs, except the two master trigger programs, will need to be globally cataloged. HTH, Bill - Original Message - *From:* shaun.fergu...@ferguson.com *To:* u2-users@listserver.u2ug.org *Date:* 6/14/2011 7:54 AM *Subject:* [U2] UniData Triggers We are creating a trigger on a file that is used extensively in the system. Is it necessary to logoff users when creating an update trigger on a file or does UniData handle that when updating the trigger information to the header of the file? The 'help' does not specify whether trigger creation requires exclusive access to the file or not. Thanks! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.comblocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ 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] Unidata command stack (history)
The one on PickWiki (http://www.pickwiki.com/cgi-bin/wiki.pl?TclStack) is mine, and attempts to be somewhat bash compatible with ^A, ^E, ^D doing the usual things. It is (unfortunately) vt100 centric, with a small nod at wy50. I've had plans forever to add tab-expansion of file names but y'all know how that goes. We have restricted access to TCL where I work and only allow access through the stack program. We produce weekly audit reports showing what commands were run, in which accounts, by whom. One of the selling points is a lot of short cuts for the programmer - the dot commands are for anyone using the stack, but slash commands are for the programmer to compile, catalog, run, checkin, diff, edit etc. Think I got that idea from some ancient programmer's workbench on Ultimate back in the 80's. Gosh, I'm old. The workflow is something like: ACCOUNT/N4 Program Name: BP.DEV STACK (svn stuff happens, tells me if the local copy differs, offers to do svn update etc.) ACCOUNT/E4 (edits the program in AE, command line editor still useful for lots of things ;-) ACCOUNT/W4 (BP.DEV STACK opens in $VISUAL, in my case /usr/local/bin/joe) ACCOUNT/BR4 (compiles, catalogs and runs BP.DEV STACK, making sensible choices about LOCAL, GLOBAL or DIRECT catalog) ACCOUNT/CI4 (checks the program back in to svn, asks for comments etc.) I usually have 10-20 programs in my stack at any one time, and get used to this week #4 is TRIN.MAIL.SUB. It saves a tremendous amount of typing. Rolling your own stack is an interesting rite of passage, and worth doing. Ian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, June 13, 2011 7:14 PM To: U2 Users List Subject: Re: [U2] Unidata command stack (history) Jeff: The U2 command stack is completely neanderthal. I've been using UD for awhile and have ignored the U2 stack completely. I run a home-written shell. There's one on Pickwiki and I have one I'd be glad to give you. Here's some documentation on the U2 stack The UniData command stack stores statements entered from the ECL command line and allows you to recall, edit, reexecute, or save them. If you make a typographical error in a command, the command stack feature allows you to correct the error without having to retype the entire statement. By default, UniData stores up to 49 commands in the command stack. To change the default, you can set the CSTACKSZ environment variable to save a specified number of command lines. Each command line can contain up to 2720 characters. See Administering UniData for information about setting UniData environment variables.Note: If you change the value of the CSTACKSZ environment variable on Windows platforms, you must restart UniData for the change to take effect. When you enter a statement on the ECL command line, UniData stores it in position 1 of the stack. As you enter more commands, UniData pushes prior commands in the stack up one position and inserts the current command in position 1 of the stack. When a command moves beyond the stack's limit, it is discarded. The command stack for each user is saved in a file called .ustk_logname in the directory of the current UniData account. Each time you enter UniData, the stack is recalled. HTH, Bill - Original Message - *From:* jbut...@hampshire.edumailto:jbut...@hampshire.edu *To:* u2-users@listserver.u2ug.orgmailto:u2-users@listserver.u2ug.org *Date:* 6/13/2011 5:50 PM *Subject:* [U2] Unidata command stack (history) Unidata 7.2.9 on linux Is there a UDT.OPTION or other setting that can control the size of the command stack (history)? We max out at 99 and I'd really like to have it recall more - but cannot find an option to do this. ___ U2-Users mailing list U2-Users@listserver.u2ug.orgmailto:U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users - IMPORTANT NOTICE: This message is intended only for the addressee and may contain confidential, privileged information. If you are not the intended recipient, you may not use, copy or disclose any information contained in the message. If you have received this message in error, please notify the sender by reply e-mail and delete the message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Enterprise Scheduling solution
Baker, we use Entrinsk's product called Informer it works with Unidata and SQL databases has a very nice graphical front end and they even allow you to embed your company's logo into the application. We have it at a number of sites. Nick Nicholas M Gettino, Director of Professional Services Support, EnRoute Emergency Systems an Infor Company, Concourse Center 1, 3501 East Frontage Rd, Suite 350, Tampa, FL 33607 -(813) 207-6998 direct, (813) 334-3507 cell, FAX (678) 393-5389 nick.gett...@enroute911.com or nick.gett...@infor.com *** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniData Triggers
Thank you for your replies! We also make use of master trigger subroutines that call subroutines so that is not an issue. I just wanted to be sure that the initial creation of an update trigger on a file would not affect current logged in users with that file open. We'll do the creation in the w hours of morning to mitigate the risk, but I'm seeing that should not be any, at least on an update trigger. I can imagine that a delete trigger could have some risk. Thanks again! Shaun Ferguson Applications Architect I Wolseley Group Services - 12500 Jefferson Avenue - Newport News - VA - 23602-4314 T: (757) 989-2916 - F: (757) 989-2801 - E: shaun.fergu...@wolseley.com www.wolseley.com blocked::http://www.wolseley.com/ Wolseley plc registered office Parkview 1220 Arlington Business Park Theale Nr Reading RG7 4GA United Kingdom Registration No. 29846 England ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Strange Selection Behavior
Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
What do the queried fields look like? Are they actual fields or calculated fields? SB+ defined? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Tuesday, June 14, 2011 4:38 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Strange Selection Behavior Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
Well they are a bit different because they are shared between two systems and we need to construct them the same on both. They are all I-descriptors. Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Davis Sent: Tuesday, June 14, 2011 1:44 PM To: U2 Users List Subject: Re: [U2] Strange Selection Behavior What do the queried fields look like? Are they actual fields or calculated fields? SB+ defined? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Tuesday, June 14, 2011 4:38 PM To: U2-Users@listserver.u2ug.org Subject: [U2] Strange Selection Behavior Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html body Dave Davis Team Lead, Ramp;D P: 614-875-4910 x108 F: 614-875-4088 E: dda...@harriscomputer.com [http://www.harriscomputer.com/images/signatures/HarrisSchools.gif] [http://www.harriscomputer.com/images/signatures/DivisionofHarris.gif] 6110 Enterprise Parkway Grove City, OH 43123 www.harris-schoolsolutions.com This message is intended exclusively for the individual or entity to which it is addressed. This communication may contain information that is proprietary, privileged or confidential or otherwise legally exempt from disclosure. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message. /body /html ___ 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] Unidata command stack (history)
Unless your up-arrow is your break key :/ gggrr... -Original Message- From: John Thompson Sent: Tuesday, June 14, 2011 9:45 AM To: U2 Users List Subject: Re: [U2] Unidata command stack (history) This might help, maybe... I found an option in Universe that you can do at TCL. COMMAND.EDITOR ON Its still fairly lame, but, at least you can use the up arrow. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Installing UniObjects on Windows 2008 64 bit
Hi, Thanks for the suggestions, folks. So far, I haven't made any progress. I did install the UniData client by right clicking on the installer and using Run As Administrator, while also logged in as an Administrator, with the same results. After David's email mentioned a missing dll and registering them manually, I tried to investigate that possibility. I'm not very familiar with that aspect of Windows systems administration, though, so I don't really know exactly what dlls are required. I looked in the C:\IBM\UniDK\redist\i386\register subdirectory, and made sure that all of those files were present in my C:\Windows\SysWOW64 directory (they were). And then I opened the command prompt (with Run as Administrator), and tried using the REGSVR32 command to register each of those 8 files, including uniobjects.dll. In each case, I got the message DllRegisterServer in c:\windows\syswow64\uniobjects.dll succeeded. However, I still don't see the UnioaifCtrl class in the OLE/COM viewer that comes with the Windows 7 SDK, and I still get the error when I try to call the object in my Domino agent. The one new piece of info that I have is this: When I run (as administrator) the UniData client installer, and then choose the UniDeveloper Kit option, it installs without any visible error as I've mentioned. However, I also tried going into the installer's UNIDK subdirectory, and running (as administrator) the actual setup.exe application for the UniDeveloper Kit. When I do it this way, I do see an error message: * The following files did not self-register or unregister: * 1. C:\Windows\SysWOW64\oc30.dll Error: 0x80040200 * 2. C:\Windows\SysWOW64\oleaut32.dll Access is denied. I do not get that error message when I run the full UniData client installer, though, so I am not sure if that error is because some underlying element that is normally handled by the main installer isn't in available, or if that error is actually occurring all the time and the main installer just isn't reporting it. Since my install isn't working, I'm guessing the error happens all the time, and the main installer is interfering with the error alert. A google search on the error number hasn't helped much. If I try to set the UDK setup program to run in Windows 2003 compatibility mode, it no longer reports an error, but the object still doesn't work or show up in the object viewer. I'll keep looking, but if anyone has any more suggestions, I'd love to hear them! :-) Thanks for the help so far! Jim Stoner ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Installing UniObjects on Windows 2008 64 bit
Sorry I don't have a 64-bit server for testing; however I was searching the kb yesterday (looking at how to install SBClient on 63-bit) and found a couple of articles that may help. One indicated that you should run the installer in Windows 2003 compatibility mode and the other was to change the CPU type (in Visual Studio) to x86 from AnyCpu. The first sounds like it would help and the second doesn't look like it will help until you actually compile/create something. Take a look at the Rocket Knowledge base (or ask your support provider) for more info. hth Colin Alfke Calgary, Canada From: Jim.Stoner Hi, Thanks for the suggestions, folks. So far, I haven't made any progress. I did install the UniData client by right clicking on the installer and using Run As Administrator, while also logged in as an Administrator, with the same results. After David's email mentioned a missing dll and registering them manually, I tried to investigate that possibility. I'm not very familiar with that aspect of Windows systems administration, though, so I don't really know exactly what dlls are required. I looked in the C:\IBM\UniDK\redist\i386\register subdirectory, and made sure that all of those files were present in my C:\Windows\SysWOW64 directory (they were). And then I opened the command prompt (with Run as Administrator), and tried using the REGSVR32 command to register each of those 8 files, including uniobjects.dll. In each case, I got the message DllRegisterServer in c:\windows\syswow64\uniobjects.dll succeeded. However, I still don't see the UnioaifCtrl class in the OLE/COM viewer that comes with the Windows 7 SDK, and I still get the error when I try to call the object in my Domino agent. The one new piece of info that I have is this: When I run (as administrator) the UniData client installer, and then choose the UniDeveloper Kit option, it installs without any visible error as I've mentioned. However, I also tried going into the installer's UNIDK subdirectory, and running (as administrator) the actual setup.exe application for the UniDeveloper Kit. When I do it this way, I do see an error message: * The following files did not self-register or unregister: * 1. C:\Windows\SysWOW64\oc30.dll Error: 0x80040200 * 2. C:\Windows\SysWOW64\oleaut32.dll Access is denied. I do not get that error message when I run the full UniData client installer, though, so I am not sure if that error is because some underlying element that is normally handled by the main installer isn't in available, or if that error is actually occurring all the time and the main installer just isn't reporting it. Since my install isn't working, I'm guessing the error happens all the time, and the main installer is interfering with the error alert. A google search on the error number hasn't helped much. If I try to set the UDK setup program to run in Windows 2003 compatibility mode, it no longer reports an error, but the object still doesn't work or show up in the object viewer. I'll keep looking, but if anyone has any more suggestions, I'd love to hear them! :-) Thanks for the help so far! Jim Stoner ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Installing UniObjects on Windows 2008 64 bit
sounds like a UAC error. An installer can request elevated UAC permission - which is not the same as running as administrator. Turn off UAC in your control panel and try again... Brian Sent from my ASUS Eee Pad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
Hi Steve, Have you tried running the command as a LIST with an INFORM on the end? It should show you how the system is treating the way the selection works. You may need to data through an 'Enter' statement in the execute. LIST CUSTOMER WITH CUST.NUM = 999 AND WITH CUST.TYPE = XXX INFORM Stuart. -Original Message- Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
Hi Steve This may be an issue of the EXECUTE creating another shell to perform the select which the tcl prompt does not require. There has been past discussions of the use of EXECUTE and PERFORM for this reason. However I am not sure that there is an difference for Universe and the PERFORM command is there for functionality. Someone may be able to clarify that. Mind you it should not cause a 22 second issue. Do a print of the cmnd before the execute and capture it in a como. You might see something strange in the way that the command is being constructed. David Jordan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
Hi Steve, It could be the CAPTURING clause causing you grief. Check the number of files in the UVTEMP directory. If there are a large number it could be that the OS is taking a long time to create the capturXXX file to store the results for the CAPTURING clause of the EXECUTE command. You could test this by removing the CAPTURING clause from the EXECUTE to see if it performs any better. If it does improve, and you are using the CAPTURING clause to hide the output of the select then look into the HUSH ON|OFF command. Regards, Gregor -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Wednesday, 15 June 2011 6:38 AM To: U2-Users@listserver.u2ug.org Subject: [U2] Strange Selection Behavior Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1CvNKu7Zp8/1yOzkbOV9fOILTpT5SHfdr/2.4 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Strange Selection Behavior
If you have indexes built on these fields try using selectindex. Jerry On 6/14/2011 3:38 PM, Steve Long wrote: Hi All - I am getting strange results with selections that I am hoping someone else has encountered and can help me resolve. We have SB+ running on UV. I don't have the same issues running on Unidata. I have a BASIC program I have written that constructs a select statement based on the criteria specified in a screen by the user, then executes the constructed selection statement. Something like (although the real one is more complex): SEL.CMD = 'SELECT CUSTOMER WITH CUST.NUM = ' : CUST.NUM : ' AND WITH CUST.TYPE = ' : CUST.TYPE : '' EXECUTE SEL.CMD CAPTURING OUTPUT Indexes are built on the dictionaries and are working properly. When we test the constructed select statement at TCL, the results are retuned under 2 seconds. When it executes inside the BASIC program, it takes approximately 24 seconds to return the same results. We tried adding a NO.INDEX to the statement, which adds 6 seconds to the select at TCL but just a couple of seconds within the BASIC program. Nothing else we have tried has had any effect. Has anyone encountered this type of behavior? Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ 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
