[U2] re directing a unidata directory to another server
I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. -- View this message in context: http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30736884p30736884.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] re directing a unidata directory to another server
On 22/01/11 15:10, grmhbeers wrote: I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. Is the other server a Unidata server too? Can't speak for Unidata, but Universe won't allow this scenario by default. All locks are on the CPU that UV is running on, so in order for two Universe servers to talk to each other you need UV-net to ensure that locking works. There is an ALLOWNFS option that will let UV talk to another server, on the assumption that it is the only UV server accessing the remote files. I suspect UD has a similar setup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
Can you see this other file/folder from the cmd prompt ? From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of grmhbeers Sent: 22 January 2011 15:10 To: u2-users@listserver.u2ug.org Subject: [U2] re directing a unidata directory to another server I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. -- View this message in context: http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30 736884p30736884.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 _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3395 - Release Date: 01/21/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. Wols Lists wrote: On 22/01/11 15:10, grmhbeers wrote: I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. Is the other server a Unidata server too? Can't speak for Unidata, but Universe won't allow this scenario by default. All locks are on the CPU that UV is running on, so in order for two Universe servers to talk to each other you need UV-net to ensure that locking works. There is an ALLOWNFS option that will let UV talk to another server, on the assumption that it is the only UV server accessing the remote files. I suspect UD has a similar setup. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30736884p30737692.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] re directing a unidata directory to another server
From what I understand you have Unidata on one machine and you want to write to a directory on another machine within your network (node). I'm not sure what you mean by a folder on another server that is in the same virtual machine...a virtual machine spans two physical machines? Assuming I've misunderstood, if you're running Windows 2003 it's easy. If you're running Windows 2008 it's relatively easy but different. Which O/S are you running? Bill grmhbeers said the following on 1/22/2011 9:45 AM: The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. Wols Lists wrote: Is the other server a Unidata server too? Can't speak for Unidata, but Universe won't allow this scenario by default. All locks are on the CPU that UV is running on, so in order for two Universe servers to talk to each other you need UV-net to ensure that locking works. There is an ALLOWNFS option that will let UV talk to another server, on the assumption that it is the only UV server accessing the remote files. I suspect UD has a similar setup. Cheers, Wol Original Message Subject:[U2] re directing a unidata directory to another server Date: Sat, 22 Jan 2011 07:10:28 -0800 (PST) From: grmhbeersghbe...@cox.net Reply-To: U2 Users Listu2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
On 22/01/11 17:45, grmhbeers wrote: The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. In other words, assuming UD is the same as UV, all you need do is find the NFSALLOW (or equivalent) flag, and set it to true (ie 1). As I say, I guess UD, by default, will refuse to write to a network drive but by setting that flag you are telling UD no, it's safe to write to the network. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
I don't think UD has the NFSALLOW flag. In UD, you can simply write to any directory that's available to the network where the user had write privileges. This raises a number of issues but, for instance, in Windows 2003 Server you can create a VOC entry to: OSFILE 001 DIR 002 \\SOMESERVER\D$\SOMEDIRECTORY 003 D_VOC This works but you may have to alter the permissions, if a UD user doesn't have the proper Windows permissions. In Windows 2008, however, you have to explicitly share the directory on the server. Then the VOC entry is like: OSFILE 001 DIR 002 \\SomeServer\ShareName 003 D_VOC At least this has been my experience so far. Bill Wols Lists said the following on 1/22/2011 2:02 PM: On 22/01/11 17:45, grmhbeers wrote: The other server is not a unidata server. It's our moodle server. Both are on sql server platforms. Unidata is underneath the sql server platform for the application where the Unibasic program is generating the output files. In other words, assuming UD is the same as UV, all you need do is find the NFSALLOW (or equivalent) flag, and set it to true (ie 1). As I say, I guess UD, by default, will refuse to write to a network drive but by setting that flag you are telling UD no, it's safe to write to the network. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] re directing a unidata directory to another server
Symeon Breen syme...@gmail.com wrote: Can you see this other file/folder from the cmd prompt ? From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of grmhbeers Sent: 22 January 2011 15:10 To: u2-users@listserver.u2ug.org Subject: [U2] re directing a unidata directory to another server I have created a Unidata (1.7x) directory to which I am writing files in a unibasic program. However I want the file to be saved directly in a folder on another server that is in the same virtual machine as our Unidata based system. All reside on windows server. I have tried everything I can think of from drive mapping to shortcuts, but Unidata still can't find the folder on the other server. What do I do so Unidata sees the mapping or shortcut or ??. Can this be done in Unidata? I do not want to ftp the files, I want them saved on the other server when the Unibasic program writes the file. -- View this message in context: http://old.nabble.com/redirecting-a-unidata-directory-to-another-server-tp30 736884p30736884.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 _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3395 - Release Date: 01/21/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] re ceiving error message XX record corrupt on logto
Hi Susan In your logto script try adding CLEARCOMMON then LOGIN so that you go in cleanly. You can add a Logto subroutine in SB+, go to the Admin screen, SB+ Setup, SB+ Control Parameters, F9 Logto Sub. I've experienced this error when logging between accounts from different versions of SB+ (different COMMON blocks). Regards David Susan Joslyn wrote: I have this happening at a client site and I've been all through the re-file everything and it won't quit. It happens *consistently* if I have more than one session open, but still happens intermittently when I don't. If you do come up with a fix for this I'd be very keen to learn it! Thanks, Susan Joslyn SJ+ Systems Associates, Inc. PRC - IT Governance for U2/Multivalue. From: Susan Lynch sly...@fwdco.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] receiving error message XX record corrupt on logto Message-ID: 004b3459d050475daf942cfccd93c...@susanhome Content-Type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Kevin, yes, ROOT was the first one I did! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/receiving-error-message-XX-record-corrupt-on-logto-tp28646451p28654669.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] re ceiving error message XX record corrupt on logto
I tried this - it did not seem to help. Thanks for the idea, though. And thanks to all who have tried to help on this one. Susan Lynch F. W. Davison Company, Inc. - Original Message - From: inquieti dinqui...@zafire.com To: u2-users@listserver.u2ug.org Sent: 05/24/2010 4:26 AM Subject: Re: [U2] re ceiving error message XX record corrupt on logto Hi Susan In your logto script try adding CLEARCOMMON then LOGIN so that you go in cleanly. You can add a Logto subroutine in SB+, go to the Admin screen, SB+ Setup, SB+ Control Parameters, F9 Logto Sub. I've experienced this error when logging between accounts from different versions of SB+ (different COMMON blocks). Regards David Susan Joslyn wrote: I have this happening at a client site and I've been all through the re-file everything and it won't quit. It happens *consistently* if I have more than one session open, but still happens intermittently when I don't. If you do come up with a fix for this I'd be very keen to learn it! Thanks, Susan Joslyn SJ+ Systems Associates, Inc. PRC - IT Governance for U2/Multivalue. From: Susan Lynch sly...@fwdco.com To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] receiving error message XX record corrupt on logto Message-ID: 004b3459d050475daf942cfccd93c...@susanhome Content-Type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Kevin, yes, ROOT was the first one I did! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/receiving-error-message-XX-record-corrupt-on-logto-tp28646451p28654669.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] re ceiving error message XX record corrupt on logto
Hi Susan This is caused by either a missing or corrupt DMSECURITY item(s). We had a customer that couldn't add anything to their menus because when they did, upon saving half the menus would disappear completely. It was all due to the fact that they had removed an account at Unix but everything was still in the DMSECURITY file. When the menus were re-built the 'missing' account caused corruption. It could even be the fact that the Allow Disallow on accounts with restrictions has modules missing. Make sure the DMSECURITY is totally up to date and in line with the actual accounts. Regards David Susan Lynch wrote: I am hoping that someone has a good memory - the company I am working with is running SBPlus 5.3.3, which is past the End of Service date. I have checked the U2 Knowledge Base for this problem, and have checked everything that they listed, and none of those possible causes are the reason for this account. My user says that he changed SB security for this account, and now HE can't log to the account without getting this message, and neither can I - and I am in the ROOT group, and the account is in the ROOT group's list of accounts without restrictions. If all else fails, I can try copying over all the XX files from an account where we are not getting this message, but I am not convinced that it will solve the problem, since it arose immediately after he changed something in the security settings for the account. Any ideas? Thanks! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Question-about-umask-tp28624993p28633985.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] re ceiving error message XX record corrupt on logto
Thanks! I will go check that now! Susan Lynch F. W. Davison Company, Inc. - Original Message - From: inquieti dinqui...@zafire.com To: u2-users@listserver.u2ug.org Sent: 05/21/2010 9:47 AM Subject: Re: [U2] re ceiving error message XX record corrupt on logto Hi Susan This is caused by either a missing or corrupt DMSECURITY item(s). We had a customer that couldn't add anything to their menus because when they did, upon saving half the menus would disappear completely. It was all due to the fact that they had removed an account at Unix but everything was still in the DMSECURITY file. When the menus were re-built the 'missing' account caused corruption. It could even be the fact that the Allow Disallow on accounts with restrictions has modules missing. Make sure the DMSECURITY is totally up to date and in line with the actual accounts. Regards David Susan Lynch wrote: I am hoping that someone has a good memory - the company I am working with is running SBPlus 5.3.3, which is past the End of Service date. I have checked the U2 Knowledge Base for this problem, and have checked everything that they listed, and none of those possible causes are the reason for this account. My user says that he changed SB security for this account, and now HE can't log to the account without getting this message, and neither can I - and I am in the ROOT group, and the account is in the ROOT group's list of accounts without restrictions. If all else fails, I can try copying over all the XX files from an account where we are not getting this message, but I am not convinced that it will solve the problem, since it arose immediately after he changed something in the security settings for the account. Any ideas? Thanks! Susan Lynch F. W. Davison Company, Inc. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- View this message in context: http://old.nabble.com/Question-about-umask-tp28624993p28633985.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] Re: UniVerse on Windows 2003 Server - Environment
Still haven't found our issue but I'm wondering if you've ever seen this behavior. It seems to be happening about once a day to different users. Our users use putty to login to our ssh server. From there they are routed to the universe server. I'm not real familiar with how all that works. Once in a while a users session will get dropped but the telnet session in universe remains open. They can be doing absolutely nothing at the time of disconnect (sitting at tcl or a input prompt), yet their process will begin consuming cpu resource like crazy until we go in and manually disconnect them. On Mon, Mar 1, 2010 at 1:50 PM, Mike Roosa mike.ro...@gmail.com wrote: We are running UniVerse on Windows 2003 Server in a virtualized environment. 99% of the time the system runs great and we have no issues, however, about once a day or every other day during the busiest time, we have a period of 2-3 minutes where the server slows down and basically quits responding. Without us taking any action the system begins responding normally again and we usually make it through that day without issue. We typically have around 85 users on the system at one time sometimes that gets up closer to 95 or 100 but not often. I have noticed certain processes that definitely cause the issue like running winmsd from the command line or renaming a directory on the server. Since I know these processes cause the issue I don't do that during the day. Obviously there are other processes that also can cause issues for us. We have worked with our vendor and Rocket and the latest we've gotten from them is that our server is under-resourced. While that very well could be true, we want to do a little more research first and reach out to other Windows/UniVerse users to see what hardware they are running and if anyone is in a virtualized environment. Any help we can get would be appreciated. Thanks Mike Roosa ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Re Count Question
BZ 001 A 002 11 003 biggrnZero 005 5R 006 S 008 F;11;C0;;S ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Re-open - file failure
Hi, We are on Solaris, running Universe and had a system failure the other day which affected one of our distributed files. After running a uvfixfile on the first partfile, we still got the message Warning: No link to overflow group 325598. We were able to count/select the file without problems, but were uneasy about the error. We created new files as a backup then did a COPY of the data to the backup files. After completing the copies, we removed the old distributed file and all of the old part files, then setup a new distribution with the copied data. Now if we run a uvfixfile on the newly created first partfile, we receive the message Warning: No link to overflow group 325599. Why we still have this error after creating a brand new file set is beyond us. In addition, we had an open file error during program execution. After tracing through the debugger, there is a program that does a file open, then calls a subroutine that opens the file again. The first open succeeds, the second fails. (why we are doing a double open is well, dumb, but that's another issue). Even more bizzare, if we create a test program that does an open, and another test program that re-opens the file, both open statements succeeed. We are at a loss and are very uneasy with the current situation. Has anyone ever experienced any similar events? We would appreciate any guidance you may have to share. We have escalated within our software group, which will hopefully be escalated to Rocket for resolution. We wanted to post here also in the hope we might find some resolution. Much appreciation for your time. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Re trieving Unix Date and Time stamp on records in a DIR type file
You could use EXECUTE ! stat ./BP/PROG1 CAPTURING OUT and parse out the bits you are interested in. This will show date/time of the most recent access, modification and change -- View this message in context: http://www.nabble.com/Retrieving-Unix-Date-and-Time-stamp-on-records-in-a-DIR-type-file-tp26077531p26079891.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] Re trieving Unix Date and Time stamp on records in a DIR type file
Use the DIR command on the file. Get the path of the file, append the appropriate \ or /, then do a DIR. For example, on a Unix machine: ITEM.ID = 'TEST' OPEN '','BP' TO BP THEN FILE.PATH = FILEINFO(BP,2) ITEM.PATH = FILE.PATH:'/':ITEM.ID ITEM.DATE = OCONV(DIR(ITEM.PATH)2,'D2/') END PRINT ITEM.DATE This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Re trieving Unix Date and Time stamp on records in a DIRtype file
Perfect. Thank you! David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer Sent: Tuesday, October 27, 2009 11:56 AM To: U2 Users List Subject: Re: [U2] Re trieving Unix Date and Time stamp on records in a DIRtype file Use the DIR command on the file. Get the path of the file, append the appropriate \ or /, then do a DIR. For example, on a Unix machine: ITEM.ID = 'TEST' OPEN '','BP' TO BP THEN FILE.PATH = FILEINFO(BP,2) ITEM.PATH = FILE.PATH:'/':ITEM.ID ITEM.DATE = OCONV(DIR(ITEM.PATH)2,'D2/') END PRINT ITEM.DATE This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software Corporation or any other company within its group. This message has been scanned for malware by Websense. www.websense.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] RE: Truncated catdir names
Hi David This probably goes back to the limitations of the original port of UNIX that had the directory name limited and the maximum number of characters in a pathname. It's unfortunate that IBM hasn't address this - but it has been around for a long, long time. But, I guess there has been little demand, as most U2 applications are legacy ones with short filenames and accounts names. You definitely should **NOT** resize your catdir to type 19 (or any other filetype)! :) Regards, David -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, 27 May 2009 4:02 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Truncated catdir names I made an unpleasant discovery when I recataloged (normally) one of my accounts (UV10.0, HP-UX). Some of the catalog names became too long (e.g. *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the catalog process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I had several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO, .NW, .RV, .SE). All of these resulted in the same truncated name so only 1 catdir entry was created, which was for the last one of the 5 cataloged. The catdir path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of *GET.COUN . Trying to run the programs results in a warning File name *SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE too long. Truncated to *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE. Is this a known limitation ? Why does the directory nesting stop at the 2nd level ? The VOC entries show the full names. catdir is type 1 out of the box. David Norman Senior Software Engineer - SA Ambulance Service ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Truncated catdir names
Any reason for not resizing catdir as type 19? I have done this and nothing seems to have broken. In fact I would hope that it would not as the file type should be transparent to any application. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 27 May 2009 6:30 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] RE: Truncated catdir names Hi David This probably goes back to the limitations of the original port of UNIX that had the directory name limited and the maximum number of characters in a pathname. It's unfortunate that IBM hasn't address this - but it has been around for a long, long time. But, I guess there has been little demand, as most U2 applications are legacy ones with short filenames and accounts names. You definitely should **NOT** resize your catdir to type 19 (or any other filetype)! :) Regards, David -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, 27 May 2009 4:02 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Truncated catdir names I made an unpleasant discovery when I recataloged (normally) one of my accounts (UV10.0, HP-UX). Some of the catalog names became too long (e.g. *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.SE) and were truncated by the catalog process (*SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE.). Unfortunately I had several programs with similar names (GET.COUNTRY.RESPONSE.ALL, .METRO, .NW, .RV, .SE). All of these resulted in the same truncated name so only 1 catdir entry was created, which was for the last one of the 5 cataloged. The catdir path is ...catdir/*SJ.RR.MAST.DE/VELOP*GET.COUN with a single file of *GET.COUN . Trying to run the programs results in a warning File name *SJ.RR.MAST.DEVELOP*GET.COUTRY.RESPONSE.SE too long. Truncated to *SJ.RR.MAST.DEVELOP*GET.COUNTRY.RESPONSE. Is this a known limitation ? Why does the directory nesting stop at the 2nd level ? The VOC entries show the full names. catdir is type 1 out of the box. David Norman Senior Software Engineer - SA Ambulance Service ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** --- 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] RE: Truncated catdir names
I was going to add that in the past it would break stuff...I haven't tried it recently!! I guess you can just make a backup / shutdown UV first whilst people aren't accessing the catdir :) -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker Sent: Wednesday, 27 May 2009 5:16 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: Truncated catdir names Any reason for not resizing catdir as type 19? I have done this and nothing seems to have broken. In fact I would hope that it would not as the file type should be transparent to any application. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 27 May 2009 6:30 p.m. To: u2-users@listserver.u2ug.org Subject: [U2] RE: Truncated catdir names Hi David This probably goes back to the limitations of the original port of UNIX that had the directory name limited and the maximum number of characters in a pathname. It's unfortunate that IBM hasn't address this - but it has been around for a long, long time. But, I guess there has been little demand, as most U2 applications are legacy ones with short filenames and accounts names. You definitely should **NOT** resize your catdir to type 19 (or any other filetype)! :) Regards, David -Original Message- ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Another probably simple SB+ issue.
Hi Jeff Check the default printer for that PC. It probably has no printer so it is saving the print image as a file Regards David Jordan Managing Consultant da...@dacono.com.au --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Another probably simple SB+ issue.
David, Works in text mode and from word etc. Interestingly enough managed to duplicate the problem. Before clicking the connect in a SBClient session there's a File option at the top of the window. Selecting that then selecting Print Options gets a small window up with a tick box labeled Use Windows Print Drivers. If you click that then carry on into your session the same issue occurs. Now the real cool part is after logging off and going back to the Print Options window the Use Windows Print Drivers is no longer ticked but the issue occurs if you log back onto the system. Thinking this has to be some sort of bug in SBClient. Unfort we have zero support over here, don't even get me started on the Aussie VAR situation, so am unable to call in the cavalry at this stage. Maybe if I stuffed up all the PCs I could claim it always worked that way :) Cheers, Jeff -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, 6 May 2009 2:52 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: Another probably simple SB+ issue. Hi Jeff Check the default printer for that PC. It probably has no printer so it is saving the print image as a file Regards David Jordan Managing Consultant da...@dacono.com.au --- 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] RE: Interest results on VOC file
It's a feature! For old legacy apps that use the marker (and other control/non-printable) characters as part of the key and are too hard to change. UV lets you turn that feature off, maybe UD does too now. -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, 29 April 2009 3:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: Interest results on VOC file Hi Nick, I had tried checking out the ID's of the keys affected. There was was nothing unusual about them that I can tell. One was 1 and another was 2. When attempting to edit them, they didn't exist. After reading your email, I write a quick test program: 001: OPEN BREAKME TO FH ELSE STOP 003: WRITE 1 TO FH,1:@SM 002: WRITE 2 TO FH,2:@VM 003: WRITE 3 TO FH,3:@AM 004: WRITE 4 TO FH,4:CHAR(10) 005: WRITE 5 TO FH,5:CHAR(13) Bottom. *--: After running it, I did the select/nselect on BREAKME and it came back with 1 record. :) Record 3 didn't exist, the attribute marker is the culprit. Now I need to find out who has written a program that is causing this, because it isn't the first time these ghost records have appeared... It begs a question though. How come Unidata allows a program to write records with keys that it can not handle without error? Regards, Dan ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Interest results on VOC file
Dan, I tried it and got zero for the NSELECT result - as it should be. I suspect you have one or more VOC keys that have attribute marks, value marks or newlines in them. This will affect your select list. If you LIST the results of the SELECT I would expect there to be a couple of errors. They should be the beginning of the VOC keys and will allow you to find and fix the problem. Jeffrey Lee Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000F: (08) 9315 7088 W: http://www.itvision.com.au ___ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: U2 Users Digest V1 #2619
It seems that we are getting one message per digest email again. Thanks, Jan -Original Message- From: owner-u2-users-dig...@listserver.u2ug.org [mailto:owner-u2-users-dig...@listserver.u2ug.org] Sent: Tuesday, April 21, 2009 7:10 AM To: u2-users-dig...@listserver.u2ug.org Subject: U2 Users Digest V1 #2619 U2 Users DigestTuesday, April 21 2009Volume 01 : Number 2619 In this issue: [U2] U2 Application / Solutions providers list? PICK / U2 Hits? Any ERP Light applications out there? -- Date: Tue, 21 Apr 2009 08:08:23 -0400 From: Scott Richardson cheetah...@comcast.net Subject: [U2] U2 Application / Solutions providers list? PICK / U2 Hits? Any ERP Light applications out there? Hello folks, A good number of years ago, there used to be a published list / document / book of various PICK / U2 Solutions Providers or Value Added Resellers and ISV (aka Independent Software Vendors) listing the VAR or ISV, their vertical markets served, and descriptions of the applications they provided, (I think it was called PICK HITS or something like that?). Is there anything similar produced/published these days? It would appear that such a document would be an excellent vehicle for the continued proliferation of the multi-valued market. (IBM U2 Marketing - where are you?) I too am out of work, but in discussions with a small local MFG type operation about an IT Manager opportunity. One of the main aspects they're looking for in this IT Manager position is someone to find, and implement an ERP Light application. It should be noted these folks have previously attempted a Epicor solution that they were sold that when it came time to implement, they discovered that this Epicor product did not do what this company needed at all. This company was promised what they wanted it to do could be done, but then learned well AFTER shelling out big $$, (after expected delivery time of the mod's), that what they wanted was not currently possible, but could be attained with 10X the previously shelled out big $$ and a couple of years of development time from the Epicor development team. Needless to say, that implementation fell flat on its face, and now they're out looking again. Looking for something that does Sales Orders and Sales History, Inventory Control, AP / AR Financials and maybe a few other basic MFG type related applications. Surprisingly, these folks are not using any pre-existing package, but using a lot of home grown type spread sheet based improvised solutions. Ideas? Suggestions? Thank you. - -- Regards, Scott Richardson ** Sr. Systems Engineer * IT Consultant Marlborough, MA 01752 CheetahFTL can be contact at comcast.net ** -- End of U2 Users Digest V1 #2619 *** u2-users-digest mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Confidentiality Notice: This communication and any accompanying attachments contain privileged and confidential information intended for a specific individual and purpose. This communication is private and protected by law. If you are not the intended recipient, you are hereby respectfully notified that any disclosures, copying, forwarding or distribution, or the taking of any action based on the contents of this communication is strictly prohibited. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: U2 Users Digest V1 #2645
Gees. Give it a rest folks. - Original Message - From: owner-u2-users-dig...@listserver.u2ug.org (U2 Users Digest) Date: Tuesday, April 21, 2009 12:52 pm Subject: U2 Users Digest V1 #2645 U2 Users DigestTuesday, April 21 2009Volume 01 : Number 2645 In this issue: Re: [U2] UV to SAP migration disaster -- Date: Tue, 21 Apr 2009 10:48:32 -0700 From: Bill Haskett wphask...@advantos.net Subject: Re: [U2] UV to SAP migration disaster Don't forget Fannie Mae and Freddie Mac, the U.S. Congress, local school boards, and the list is endless, isn't it. Monkeys aren't limited in location or job (I've been found to act like one on more occasions than I care to remember). :-) Bill __ [snipped] I think it would be to our advantage if only businesses were in fact led by rational intelligent people all the time but Enron, Global Crossings,Bear Stearns, etc, etc, etc should be sufficient warning that they are not. Rex Gozar wrote: It's fun to think of UV as the underdog and how the cards are stacked against us. It's fun to be in the I told you so crowd when the competitor fails. [stuff removed] -- End of U2 Users Digest V1 #2645 *** u2-users-digest 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] Re: [UV] Passing a string when a Matrix is expected
I came accross a case in legacy code where a subroutine is defined to accept some matrixes as parameter ei: SUBROUTINE FOOBAR(TXT, MAT A, MAT B, MAT C, MAT D, OPTION) One of the calling programs that makes use of this subroutine does this: CALL FOOBAR(HELLO, , , , , WORLD) Instead of passing a matrix, it is passing an empty string. The result is that in FOOBAR, matrixes A, B, C and D are of size zero. In FOOBAR there is code that does: MATBUILD REC.A FROM A USING CHAR(1) Now the MATBUILD command on a matrix of size zero is giving me an undefined variable in a test program I wrote but in the program in production, it is giving me the content of a variable in the program. I was wondering if there is a way to detect if a matrix is of size zero in Unibasic. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: [UV] Passing a string when a Matrix is expected
INMAT() looks like it may do the job for you. HTH. INMAT function _ SYNTAX INMAT ( [array] ) DESCRIPTION Use the INMAT function to return the number of array elements that have been loaded after the execution of a MATREAD, MATREADL, MATREADU, or MATPARSE statement, or to return the modulo of a file after the execution of an OPEN statement. You can also use the INMAT function after a DIM statement to determine whether the DIM statement failed due to lack of available memory. If a preceding DIM statement fails, INMAT returns a value of 1. If the matrix assignment exceeds the number of elements specified in its dimensioning statement, the zero element is loaded by the MATREAD, MATREADL, MATREADU, or MATPARSE statement. If the array dimensioning is too small and the zero element has been loaded, the INMAT function returns a value of 0. If array is specified, the INMAT function returns the current dimensions of the array. If array is the null value, the INMAT function fails and the program terminates with a run-time error message. EXAMPLE DIM X(6) D='123456' MATPARSE X FROM D,'' Y=INMAT() PRINT 'Y= ':Y * DIM X(5) A='CBDGFH' MATPARSE X FROM A,'' C=INMAT() PRINT 'C= ':C * OPEN '','VOC' TO FILE ELSE STOP T=INMAT() PRINT 'T= ':T This is the program output: Y= 6 C= 0 T= 23 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jacques G. Sent: Friday, 17 April 2009 7:27 AM To: u2-users@listserver.u2ug.org Subject: [U2] Re: [UV] Passing a string when a Matrix is expected I came accross a case in legacy code where a subroutine is defined to accept some matrixes as parameter ei: SUBROUTINE FOOBAR(TXT, MAT A, MAT B, MAT C, MAT D, OPTION) One of the calling programs that makes use of this subroutine does this: CALL FOOBAR(HELLO, , , , , WORLD) Instead of passing a matrix, it is passing an empty string. The result is that in FOOBAR, matrixes A, B, C and D are of size zero. In FOOBAR there is code that does: MATBUILD REC.A FROM A USING CHAR(1) Now the MATBUILD command on a matrix of size zero is giving me an undefined variable in a test program I wrote but in the program in production, it is giving me the content of a variable in the program. I was wondering if there is a way to detect if a matrix is of size zero in Unibasic. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Message protected by MailGuard: e-mail anti-virus, anti-spam and content filtering. http://www.mailguard.com.au/rr Click here to report this message as spam: https://login.mailguard.com.au/report/1xh3PzGPBt/7m4U8ME624iLZKoyw58t7e/0.6 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: U2 Users Digest V1 #2599
True, but they will appear in the right order when they arrive and, barring a failure, they will all arrive. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: U2 Users Digest V1 #2599
John, Be aware that sockets are a stream based protocol and not a message based protocol. When you send data to a socket it may arrive in one or more pieces (packets). On a LAN this may never occur, but over a WAN or the internet your data packets will almost surely be broken up into smaller pieces. On the receiving end you will need to know the length of the data you expect or have some sort of end-of-line character(s) to know when you have received all of the data. Years ago I wrote a program that worked well on a LAN, but failed randomly when data was passed through the internet. I mistakenly thought that if I sent a packet with 1024 bytes that I would always receive a packet with 1024 bytes (like writing and reading from disk). This is not the case. Kevin M. Sproule Sr. Technical Consultant AFS Technologies, Inc. 2141 E. Highland Ave, Ste. 100 Phoenix, AZ 85016 Care Center: (602) 522-8181 Main: (602) 522-8282 e-mail: kev...@afsi.com Our mission is to be the number one supplier of software to the food and beverage industry - -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Thursday, April 09, 2009 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] universe sockets I am about to do some socket programming with the universe socket API (universe 10.2.x and aix 5.3.x), are there any gotchas/advice/suggestions anyone would care to share? thanks! dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: U2 Users Digest V1 #2599
Kevin, aren't you describing UDP communication, not TCP? Packets can be fragged and move through any number of different channels w/ UDP, but they're reassembled as a part of being received through TCP. If you sent a 1024 packet over UDP I would expect exactly what you've stated. Send a 1024 packet through TCP and I'd expect 1024 to arrive, and in order, as long as there's no failure. Of course, failures can occur with any protocol, even those that self-negotiate, so timeouts, dropouts, disconnects, and other failures have to be addressed in the implementation. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 Users Digest V1 #2599
The issue is that if you send a 1024 byte message through a TCP socket, you may eventually get 1024 bytes out the other end, but you may not get them all at once. The message may be broken up into lots of pieces, i.e. if you do a read(), you may get 1024 bytes, or you may get a lot less, and have to read() again. Best regards, Henry Henry P. Unger Hitech Systems, Inc. http://www.hitech.com -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, April 09, 2009 4:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: U2 Users Digest V1 #2599 Kevin, aren't you describing UDP communication, not TCP? Packets can be fragged and move through any number of different channels w/ UDP, but they're reassembled as a part of being received through TCP. If you sent a 1024 packet over UDP I would expect exactly what you've stated. Send a 1024 packet through TCP and I'd expect 1024 to arrive, and in order, as long as there's no failure. Of course, failures can occur with any protocol, even those that self-negotiate, so timeouts, dropouts, disconnects, and other failures have to be addressed in the implementation. -K --- 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] RE: Replication
Thanks everyone for your comments and links. Rudy -Original Message- From: owner-u2-users-dig...@listserver.u2ug.org [mailto:owner-u2-users-dig...@listserver.u2ug.org] Sent: Wednesday, April 08, 2009 1:00 AM To: u2-users-dig...@listserver.u2ug.org Subject: U2 Users Digest V1 #2597 U2 Users Digest Wednesday, April 8 2009 Volume 01 : Number 2597 In this issue: [U2] Replication Re: [U2] Replication RE: [U2] Replication RE: [U2] Replication -- Date: Tue, 7 Apr 2009 09:12:29 -0700 From: Cooper, Rudy rudy.coo...@sagepub.com Subject: [U2] Replication Hello, I have a concern about our uv server suffering a catastrophic hardware failure. Our uv server is responsible for our order processing shipping, core to the business. We can't afford much down time. Is anyone replicating UV data to another server or using any kind of 'snapshot' technology? If so could you provide some info. Thx, Rudy -- Date: Tue, 7 Apr 2009 11:45:27 -0600 (MDT) From: Karl Pearson ka...@ourldsfamily.com Subject: Re: [U2] Replication This may not be real helpful, but for a warehousing business, they thought it was nice. I setup an NFS server from the business system (AIX 5.2) to the Web server (Fedora v8) and then setup a cron to copy the entire business system applications and data every night at about 11pm, which was when the database was unused by other processes, or anyone actually changing things. For the developers, I also created a web link to the source code (BP file) so they could, after entering a login and password, view the source code. Doing that saved the necessity of having to put a tape in the drive and waiting for a couple hours to see if a file was restored so they could see what it looked like before so-n-so edited things... This company didn't have a development server, so they did work on the live business system. Yeah, lame... HTH, Karl On Tue, April 7, 2009 10:12 am, Cooper, Rudy wrote: Hello, I have a concern about our uv server suffering a catastrophic hardware failure. Our uv server is responsible for our order processing shipping, core to the business. We can't afford much down time. Is anyone replicating UV data to another server or using any kind of 'snapshot' technology? If so could you provide some info. Thx, Rudy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com - --- 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. - --- -- Date: Tue, 7 Apr 2009 11:53:34 -0700 From: John Hester jhes...@momtex.com Subject: RE: [U2] Replication -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: Tuesday, April 07, 2009 9:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] Replication [snip] Is anyone replicating UV data to another server or using any kind of 'snapshot' technology? If so could you provide some info. We're doing real-time replication rather than using snapshots, but the goal of avoiding downtime is the same. There was a long thread on this topic back on 3-18, so I won't post all the details of our implementation again, but I'd be happy to resend my post to you off-list if you don't have it. To summarize: While you can use 3rd party software to replicate UV at the OS level, there is an important issue to consider. Writes to overflow space of a hashed file require more than one write operation, as do on-the-fly automatic resizes of dynamic files. If the live server goes down when only one or some of these writes have been completed, the replicated copy of the target file may be broken, possibly beyond repair. Turning on UV transaction logging can eliminate this danger, but there is an important issue to consider here as well. Dan Fitzgerald pointed out that if you are copying the logs to your backup machine as they're closed and rolling the transactions forward, you will almost always lose the last transaction because it is likely to span 2 log files and will be seen as incomplete. If I understand correctly, however, this issue applies to a hot-spare scenario where UV is actively running on both servers. We use a cold-spare where UV doesn't run on the backup machine and the data filesystem isn't mounted. IBM's recommendation to me was to use transaction logging and replicate the logs to the backup machine along with the UV data. In a failover scenario, UV would be warmstarted on the backup machine and only the active transaction log would need to be rolled forward. There is some I/O overhead associated with transaction logging,
[U2] RE: UniObjects connection timeouts?
What version of the UniObjects assembly are you using.. We ran into this alot with the first .Net assemblies IBM shipped, but later releases are a lot better, and the RPC issue seems to have been largely resolved. FYI - We use the same assembly on Unidata and UniVerse, and had the same/similar issues on both U2 Products - moving to a later release of the assembly solved a lot of problems on both U2 products.. Regards Ray From: owner-u2-us...@listserver.u2ug.org [owner-u2-us...@listserver.u2ug.org] On Behalf Of IT-Laure Hansen [lhan...@redwoodcity.org] Sent: 01 April 2009 12:34 To: u2-users@listserver.u2ug.org Subject: [U2] UniObjects connection timeouts? UV 10.2.3 on Windows 2003 server. UniObjects calls in Windows Forms (.Net 2.0) using VB.Net. UniObjects are supposed to have a default no-time-out. I am not modifying any properties or parameters, and per UniObjects developers doc: Timeout This property specifies the length of the timeout for a connected session. The timeout period is used by the UniVerse remote procedure call utility (UniRPC). The default value of this property is 0 (no timeout period). For values greater than 0, you must specify seconds. Session Object: Properties 3-52 C:\Program Files\Adobe\FrameMaker7.0\UniVerse Note: If you enter a value that is too small, a running process (for example, the Read method) may time out. If this occurs, an error code is returned and the connection to the server is dropped. This applies to both session and read timeouts. Again, I am not changing these properties at all. Yet, sessions unattended for more than an (unknown) amount of time, about 4 hours at the latest incident (but I hit it with less time earlier, somewhere around 1 hour), are causing the following exceptions to be caught: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host.[IBM U2][UODOTNET-UNIRPC][ErrorCode=81009] The RPC failed. Note that message 81009 does not exist in SYS.MESSAGE. Does anyone know how to make the sessions truly NOT time out, or fix whatever this problem is about?? Thanks in advance! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 lhan...@redwoodcity.orgmailto:lhan...@redwoodcity.org P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribehttp://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index .aspx --- 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] RE: IDE
Our UniData database is on a Unix box. I have mapped the key dirs to my PC. This allows me to use any PC editor I wish. I usually use SlickEdit because that is an editor that lots of other folks here use for other applications, but I have also used Primal Script (the 2nd most popular editor here). But again, since all my Unix stuff is mapped, I use whatever I want. Of course, this is only for things in non-hashed/PICK files, but that is what I spend 99% of my time doing. Since we use Redback, I use these same editors for my web pages too. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Cooper, Rudy Sent: Monday, March 16, 2009 4:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] IDE Hi List, I need some recommendations. We've been coding using our UV text editor. You know the routine, copy and paste from 1 program to another. I have finally been given the green light to get pricing on a tool for development, creating forms (screens), document as you go, reusability, gui-izing, etc. Any recommendations? I was thinking of SB+, Redback, and even U2.NET (Since we have access to visual studio). We're a development team of 3 for about 100 UV users. If your using any of the newer development tools, I'd really like your opinion, good or bad. thx, rudy Rudy Cooper Technical Project Lead Sage Publications Inc. 2455 Teller Road Thousand Oaks, CA. 91320 USA T: 805.410.7724 www.sagepub.com Los Angeles | London | New Delhi Singapore | Washington DC The natural home for authors, editors societies Please consider the environment before printing this email --- 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] Re: Email from a Old Friend!!!!!!!!!!! Oops! I didn't mean to send it to everyone
Sorry Guys! --- On Sun, 3/15/09, Fawaz Ashraff fawazashr...@yahoo.com wrote: From: Fawaz Ashraff fawazashr...@yahoo.com Subject: Email from a Old Friend!!! To: u2-users@listserver.u2ug.org Date: Sunday, March 15, 2009, 8:59 PM Hi Mike, How are you? I left couple of e-mails earlier but no luck. Please pass me your home number and the mobile and I'll call you one of these days. Man, it has been a loong long time and like to talk to you soon. Hope every thing is fine at your end. Cheers Mo Home: +94112527461 Cell: +9449247 --- On Fri, 3/13/09, Michael Rajkowski mraj...@us.ibm.com wrote: From: Michael Rajkowski mraj...@us.ibm.com Subject: Re: [U2] - UniBasic String Search To: u2-users@listserver.u2ug.org Cc: owner-u2-us...@listserver.u2ug.org, u2-users@listserver.u2ug.org Date: Friday, March 13, 2009, 10:07 AM If you are looking for something quick then create a dict item with the match criteria you want to search for, the following example is based of the UniData demo account file TAPES Add an item: AE DICT TAPES MTYPE Top of MTYPE in DICT TAPES, 6 lines, 33 characters. *--: p 001: I 002: 'C':@VM:'R' 003: 004: MY TYPES 005: 10L 006: S Bottom. Then use the MATCH keyword on you query statement. LIST TAPES WHEN CATEGORIES MATCH MTYPE CATEGORIES 11:06:14 Mar 13 2009 1 TAPES. Type of Video V4951 C V1231 C V1249 R V110 C V9431 C B914 R B2297 R V8181 C 8 records listed Michael Rajkowski SWG Client Support - Information Management Software Software Engineer ? IBM U2 Client Support Team 1-800-729-3553 mraj...@us.ibm.com Brutzman, Bill bi...@hkmetalcraft.com Sent by: owner-u2-us...@listserver.u2ug.org 03/13/2009 08:39 AM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] - UniBasic String Search I need to examine fields for perhaps one thousand part.numbers looking for tech specs that contain character strings like MIL Spec SPEC -14 etc While I can do this with commands like... execute 'SELECT IM WITH OP.SPEC LIKE ...-14... ', this technique is awkward since I have a few dozen strings to look for... I have the IBM tech manual describing the MATCH operator and the MATCHFIELD function. Is there a handy UniBasic method to handle this or should I write a little program to do this myself? Fixes would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif] [demime 1.01d removed an attachment of type image/gif] [demime 1.01d removed an attachment of type image/jpeg] --- 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] RE: UV Timed INPUT
I Tried to write something similar, but kept getting random program lockups or universe bombouts. What I was trying to do was as letters were being typed, fine tune a listing to the right. Also, I tried to make a full screen editor, allowing the arrows to allow the user to move from field to field, and the insert key would function as expected. Because I was only taking one key at a time, I had to use KEYIN (otherwise backspace wouldn't trigger the routine as a key typed, or a function key would be returned as only the first character of the key. Most of the time it worked, just everynow and again, it would blow up, and I could never figure out why (although I was told it was most like something in the keyin() internally). The gist of the routine is below: It requires you to roll your own input routine, that is you have to check for an ENTER, and check for a backspace, then remove the last char from BUFFER. 1000: INPUT TEST,-1: LOOP WHILE(TEST=1) DO BUFFER=BUFFER:KEYIN() INPUT TEST,-1: REPEAT RETURN George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, March 11, 2009 11:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Timed INPUT I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- 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] RE: UV Timed INPUT
George, I've run into that before - it's probably network latency. If there's nothing in your keyboard buffer, your routine will bail. If a multi-character keystroke gets broken between packets, that can happen. Experiment with a delay before the INPUT TEST,-1 to allow the network to catch up with you. It takes some tweaking, but faster hardware lessens the effect. Of course, if you're not networked in any way, then I'm probably all wet. I've been there before. Regards, Charlie Noah Inland Truck Parts Company George Gallen wrote: I Tried to write something similar, but kept getting random program lockups or universe bombouts. What I was trying to do was as letters were being typed, fine tune a listing to the right. Also, I tried to make a full screen editor, allowing the arrow s to allow the user to move from field to field, and the insert key would function as e xpected. Because I was only taking one key at a time, I had to use KEYIN (otherwise back space wouldn't trigger the routine as a key typed, or a function key would be returned as o nly the first character of the key. Most of the time it worked, just everynow and again, it would blow up, and I co uld never figure out why (although I was told it was most like something in the keyin( ) internally). The gist of the routine is below: It requires you to roll your own input routin e, that is you have to check for an ENTER, and check for a backspace, then remove the last char from BUFFER. 1000: INPUT TEST,-1: LOOP WHILE(TEST=1) DO BUFFER=BUFFER:KEYIN() INPUT TEST,-1: REPEAT RETURN George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, March 11, 2009 11:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Timed INPUT I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- 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] RE: UV Timed INPUT
George, Email me tomorrow at charlien at inlandtruck.com and remind me and I'll share some code with you that worked extremely well on Universe, and now on Jbase - it's almost identical. I almost never get those straggling characters anymore. Charlie Charlie Noah wrote: George, I've run into that before - it's probably network latency. If there's nothing in your keyboard buffer, your routine will bail. If a multi-character keystroke gets broken between packets, that can happen. Experiment with a delay before the INPUT TEST,-1 to allow the network to catch up with you. It takes some tweaking, but faster hardware lessens the effect. Of course, if you're not networked in any way, then I'm probably all wet. I've been there before. Regards, Charlie Noah Inland Truck Parts Company George Gallen wrote: I Tried to write something similar, but kept getting random program lockups or universe bombouts. What I was trying to do was as letters were being typed, fine tune a listing to the right. Also, I tried to make a full screen editor, allowing the arrow s to allow the user to move from field to field, and the insert key would function as e xpected. Because I was only taking one key at a time, I had to use KEYIN (otherwise back space wouldn't trigger the routine as a key typed, or a function key would be returned as o nly the first character of the key. Most of the time it worked, just everynow and again, it would blow up, and I co uld never figure out why (although I was told it was most like something in the keyin( ) internally). The gist of the routine is below: It requires you to roll your own input routin e, that is you have to check for an ENTER, and check for a backspace, then remove the last char from BUFFER. 1000: INPUT TEST,-1: LOOP WHILE(TEST=1) DO BUFFER=BUFFER:KEYIN() INPUT TEST,-1: REPEAT RETURN George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, March 11, 2009 11:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Timed INPUT I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- 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] RE: DO/WHILE vs IF THEN
If you might also want to play with putting the WHILE... line just before the REPEAT. This would be dependent upon your actual program (might need to consider if the loop starts with a failed condition). Your mileage may vary. John Israel -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, February 27, 2009 11:20 AM To: Ardent Subject: [U2] DO/WHILE vs IF THEN OK Aside from programming styles Is there any functional difference between WHILE expression DOand IF NOT(expression) THEN EXIT and UNTIL expression DOand IF expression THEN EXIT First I thought that the DO/WHILE would activate as soon as the condition occurred and drop out of a loop, but that is not the case, the condition has to be active AND control has to be back at the WHILE statement. Example: 0001: CTR=0 0002: LOOP 0003: CTR=CTR+1 0004: WHILE CTR4 DO 0005: PRINT CTR 0006: CTR=CTR+1 0007: PRINT CTR 0008: CTR=CTR+1 0009: PRINT CTR 0010: CTR=CTR+1 0011: PRINT CTR 0012: CTR=CTR+1 0013: PRINT CTR 0014: CTR=CTR+1 0015: PRINT CTR 0016: CTR=CTR+1 0017: PRINT CTR 0018: REPEAT 0019: STOP 0020: END My first thought was that once CTR = 5, the loop would end (at LINE 12) but it didn't until control was passed back to LINE 4, then it ended. --- 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] RE: DO/WHILE vs IF THEN
I hadn't really played much with RAID/VLIST, so I guess this is my springboard.. VLISTING the WHILE/DO vs IF THEN yielded some interesting results WHILE/DO 3 6 : 1C2 vec_addCTR 1 = CTR 5 E : 10C nop 5 00010 : 0DC lt CTR 4 = $R0 5 00018 : 2DE testfw $R0 00084: 6 00020 : 130 printcrlf CTR 7 00026 : 1C2 vec_addCTR 1 = CTR 8 0002E : 130 printcrlf CTR 9 00034 : 1C2 vec_addCTR 1 = CTR IF/THEN EXIT 3 6 : 1C2 vec_addCTR 1 = CTR 4 E : 0DC lt CTR 4 = $R0 4 00016 : 10E not$R0 = $R1 4 0001C : 2DE testfw $R1 0002C: 4 00024 : 0C2 jump 00090: 6 0002C : 130 printcrlf CTR 7 00032 : 1C2 vec_addCTR 1 = CTR 8 0003A : 130 printcrlf CTR Seems the IF/THEN EXIT adds a few extra opcodes in, but in general it's pretty much the same effect. So with large loops (many records) it might slow the process down a couple seconds. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, February 27, 2009 11:20 AM To: Ardent Subject: [U2] DO/WHILE vs IF THEN OK Aside from programming styles Is there any functional difference between WHILE expression DOand IF NOT(expression) THEN EXIT and UNTIL expression DOand IF expression THEN EXIT First I thought that the DO/WHILE would activate as soon as the condition occurred and drop out of a loop, but that is not the case, the condition has to be active AND control has to be back at the WHILE statement. Example: 0001: CTR=0 0002: LOOP 0003: CTR=CTR+1 0004: WHILE CTR4 DO 0005: PRINT CTR 0006: CTR=CTR+1 0007: PRINT CTR 0008: CTR=CTR+1 0009: PRINT CTR 0010: CTR=CTR+1 0011: PRINT CTR 0012: CTR=CTR+1 0013: PRINT CTR 0014: CTR=CTR+1 0015: PRINT CTR 0016: CTR=CTR+1 0017: PRINT CTR 0018: REPEAT 0019: STOP 0020: END My first thought was that once CTR = 5, the loop would end (at LINE 12) but it didn't until control was passed back to LINE 4, then it ended. --- 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] RE: Inter-Process Control...
Could you have the first PHANTOM fire off the 2nd PHANTOM when that critical point is reached? John Israel -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, February 26, 2009 7:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] Inter-Process Control... We have two phantom processes. The first phantom needs to wait for an event to occur with the second phantom. I realize that I could have the first phantom loop, check, then sleep. However, I'd like to avoid wasting resources. Back on the Prime, I could use semaphores, to control this flow and this was clean, and simple. Has anyone come across a means of having a phantom wait on something, so it only wakes up when it needs to perform its function? To try to explain better: Phantom1: Loop Wait on semaphore Perform a shared process (batch updates would be an example) Repeat Phantom2 (3, 4, ...): Loop Process records Notify semaphore Repeat Thanks, Tom Whitmore RATEX Business Solutions --- 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] RE: Inter-Process Control...
If you are running unix, you could have an email alias run a script that triggers the phantom, then to start the phantom, just have unix send an email to that address. George -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Thursday, February 26, 2009 7:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] Inter-Process Control... We have two phantom processes. The first phantom needs to wait for an event to occur with the second phantom. I realize that I could have the first phantom loop, check, then sleep. However, I'd like to avoid wasting resources. Back on the Prime, I could use semaphores, to control this flow and this was clean, and simple. Has anyone come across a means of having a phantom wait on something, so it only wakes up when it needs to perform its function? To try to explain better: Phantom1: Loop Wait on semaphore Perform a shared process (batch updates would be an example) Repeat Phantom2 (3, 4, ...): Loop Process records Notify semaphore Repeat Thanks, Tom Whitmore RATEX Business Solutions --- 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] Re: RE: [sbs] GUI screen will not show in /SD
Sorry for stating the obvious, but... is the .GUI record in the dictionary for that /SD? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: UDR initialisation failed
Following up to myself, could the following have any bearing on the matter? Wed Feb 04 12:02:31 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:31 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:02:53 -2761 PROG1\Administrator Program *vmadmsub: pc = 8c66, Message[02] Wed Feb 04 12:09:18 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:18 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = b4f2, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = 94a0, Message[02] Wed Feb 04 12:09:20 -2761 PROG1\Administrator Program *vmadmsub: pc = 94a0, Message[02] Wed Feb 04 12:09:21 -2761 PROG1\Administrator Program *vmadmsub: pc = 94a0, Message[02] Wed Feb 04 12:09:21 -2761 PROG1\Administrator Program *vmadmsub: pc = 94a0, Message[02] This lot is in our errlog, *vmadmsub looks suspiciously like a system routine, and message 02 is Bad file descriptor Cheers, Wol -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Anthony Youngman Sent: 05 February 2009 13:24 To: u2-users@listserver.u2ug.org Subject: [U2] UDR initialisation failed Replication is giving me grief ... I've found the programs in APP.PROGS (which seem so much more usable than UvAdmin :) bit I'm getting nowhere. Looking at the files in the UV account it seems okay but I'm not at all sure. I *think* it's all configured about right, but I'm getting UDR initialization failed with a return value of -2. In the logs. Any ideas anyone? Also when I ran REPSUBLIST I got the error Unable to read record from file UV in account AWY, STATUS() is 0. That's a double-space after record by the way, so it was trying to read a null key from a non-existent file (I couldn't find any file called UV, not in the account I was replicating from, to, or in the UV account). What's that about? I'm not making much headway. And the documentation just seems to assume that everything will work fine - it doesn't even *mention* troubleshooting as far as I can see, just says if it doesn't work, once you've fixed the problem ... and assumes it's a dodgy file you're trying to replicate. I've just created two clean accounts to try and get things working between them ... Any help/ideas gratefully received. Cheers, Wol --- 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] RE: UV - Error when using WHEN [not-secure]
Colin and Ron are correct! A quick I-descriptor to CONVERT 4A to something else caused proved it. As soon as I read the first mention of MATCHING... I remembered, with a sinking feeling, that LIKE is just a synonym for MATCHING... Thanks again! Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Use LIKE ...'4A'... to prevent pattern matching -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: 03 February 2009 21:03 To: u2-users@listserver.u2ug.org Subject: [U2] RE: UV - Error when using WHEN [not-secure] Apologies - no one has gotten a package from me... important or otherwise! Apparently something in my e-mail triggered our security appliance to lock the message. Sorry! From: Hennessey, Mark F. Sent: Tuesday, February 03, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: UV - Error when using WHEN Solaris 10, UV 10.2.2, Information flavor. We are seeing some very odd behavior when trying to use SORT / WHEN on a multi-subvalued field. And by odd behavior I mean totally incorrect output... File Type: Dynamic File Makeup: The file contains associated multivalues and subvalues. Issue: When using the when clause with subvalued Field 7 like '...4a... (DISB LINE column), the only records displayed have PDSB in field 7 no records with 4A are displayed. Here's part of what an unconditional SORT looks like... Notice that OC34.UD.07 (DISB LINE) has values like 'PDSB', 4A. etc. SORT OC34UD.WORK.SP16504 OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 UD.07 09:27:25 02-03-09 PAGE 1 LINE. PYEAMT ADD.RPTD.AMT SUB. DISB OC34UD.KEYCDSTO 2a-2h2a-2hLN 2a-2hAMT DISB LINE 14464*19030799*27 10.81REP 10.81 10.81 PDSB 14683*20382253*13 509.00VRC509.00 509.00 PDSB 14811*21191410*115.00VRC 5.005.00 PDSB 14840*21417980*1 22 21.00REP 21.00 21.00 PDSB 14859*21512820*11 142.04VRC142.04 142.04 PDSB 14863*21553328*11 20.00VRC 20.00 20.00 PDSB 14865*700369*1 1 900.00VRC900.00 900.00 PDSB 14869*21548157*17 76.14VRC 76.14 76.14 PDSB 14871*21578431*173.89VRC 3.893.89 PDSB 14877*21601594*17 76.14VRC 76.14 76.14 PDSB 14879*21653295*21 61.002E 61.00 4A 14879*21654502*11 78.002E 26.00 7dF 52.00 4A 14879*21654965*11 232.002E 232.00 4A 14884*21649378*11 379.172E 379.17 4A 14886*21700617*11 432.002E 432.00 4A Now when we try to limit output to just 4A: SORT OC34UD.WORK.SP16504 WHEN OC34UD.07 LIKE ...4A... OC34UD.01 OC34UD.02 OC3 4UD.03 OC34UD.04 OC34UD.05 OC34UD.06 OC34UD.07 09:58:32 02-03-09 PAGE 1 LINE.LINE. PYE AMT ADD. RPTD. AMT SUB. SUBTD DISB OC34UD.KEY CDS TO 2a-2h 2a-2h LN 2a-2h 2a-2h AMT DISB LINE 14464*19030799*2 7 10.81 REP 10.81 2F10.81 PDSB 14683*20382253*1 3509.00 VRC 509.00 2B 509.00 PDSB 14811*21191410*1 1 5.00 VRC5.00 2H 5.00 PDSB 14840*21417980*1 22 21.00 REP 21.00 2C21.00 PDSB 14859*21512820*1 1142.04 VRC 142.04 2F 142.04 PDSB Any ideas/thoughts are welcome... Thanks! Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ - ** The contents of this e-mail are subject to contract in all cases and William Hill PLC, its subsidiaries or affiliates make no contractual commitment save where confirmed by hard copy. The contents of this e-mail do not necessarily represent the views of William Hill PLC, its subsidiaries or affiliates. We accept no liability, including liability for negligence, in respect of any statement in this e-mail. This e-mail and any files transmitted with it are confidential, may be subject to legal privilege and intended solely for the use of the individual or entity to which they are addressed. If you are not the intended recipient, you are hereby notified that any use or dissemination of this communication is strictly prohibited. If you have received this e-mail in error, please notify us immediately, then delete this e-mail. Please note that William Hill can accept no responsibility for viruses and it is your responsibility to scan any emails and their attachments. This message was from William Hill PLC whose registered office is Greenside House, 50 Station Road, Wood Green, London N22 7TP. Company Registration Number: 4212563 England
Re: [U2] RE: UV - Error when using WHEN [not-secure]
Yes, WHEN can be frustrating. 1st, make sure the multi-valued associated fields are properly defned with M's in field 6, association name in field 7 and, for good measure, create a phrase with said association name as the id of the phrase, and all the associated fields listed in 2. Then add a BY.EXP to the SORT(or other RetrieVe statement) statement, even if you don't care about the sort on the values, sub-values. Just piuck a field to sort by. If you really care about sorting by @IDs do that explicitly as the primary sort, the by.exp sort secondary: LIST OC34UD.WORK.SP16504BY @ID BY.EXP OC34UD.01_ OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 I was really looking forward to that package. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Isn't the ...4A... evaluating to the match string and not the literal? That means it will match anything with 4 alphanumeric chars??? Hth Colin Alfke Calgary, Canada -Original Message- From: Charles Stevenson Yes, WHEN can be frustrating. 1st, make sure the multi-valued associated fields are properly defned with M's in field 6, association name in field 7 and, for good measure, create a phrase with said association name as the id of the phrase, and all the associated fields listed in 2. Then add a BY.EXP to the SORT(or other RetrieVe statement) statement, even if you don't care about the sort on the values, sub-values. Just piuck a field to sort by. If you really care about sorting by @IDs do that explicitly as the primary sort, the by.exp sort secondary: LIST OC34UD.WORK.SP16504BY @ID BY.EXP OC34UD.01_ OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 I was really looking forward to that package. cds --- 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] RE: UV - Error when using WHEN [not-secure]
Remember 4A is a valid match qualifier, to look for 4 alphabetic characters. I experience this sort of behavior and had a real challenge to force it to find the values for which I was looking. Subject: [U2] RE: UV - Error when using WHEN [not-secure] Date: Tue, 3 Feb 2009 16:03:00 -0500 From: mark.hennes...@ct.gov To: u2-users@listserver.u2ug.org Apologies - no one has gotten a package from me... important or otherwise! Apparently something in my e-mail triggered our security appliance to lock the message. Sorry! From: Hennessey, Mark F. Sent: Tuesday, February 03, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: UV - Error when using WHEN Solaris 10, UV 10.2.2, Information flavor. We are seeing some very odd behavior when trying to use SORT / WHEN on a multi-subvalued field. And by odd behavior I mean totally incorrect output... File Type: Dynamic File Makeup: The file contains associated multivalues and subvalues. Issue: When using the when clause with subvalued Field 7 like '...4a... (DISB LINE column), the only records displayed have PDSB in field 7 no records with 4A are displayed. Here's part of what an unconditional SORT looks like... Notice that OC34.UD.07 (DISB LINE) has values like 'PDSB', 4A. etc. SORT OC34UD.WORK.SP16504 OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 UD.07 09:27:25 02-03-09 PAGE 1 LINE. PYEAMT ADD.RPTD.AMT SUB. DISB OC34UD.KEYCDSTO 2a-2h2a-2hLN 2a-2hAMT DISB LINE 14464*19030799*27 10.81REP 10.81 10.81 PDSB 14683*20382253*13 509.00VRC509.00 509.00 PDSB 14811*21191410*115.00VRC 5.005.00 PDSB 14840*21417980*1 22 21.00REP 21.00 21.00 PDSB 14859*21512820*11 142.04VRC142.04 142.04 PDSB 14863*21553328*11 20.00VRC 20.00 20.00 PDSB 14865*700369*1 1 900.00VRC900.00 900.00 PDSB 14869*21548157*17 76.14VRC 76.14 76.14 PDSB 14871*21578431*173.89VRC 3.893.89 PDSB 14877*21601594*17 76.14VRC 76.14 76.14 PDSB 14879*21653295*21 61.002E 61.00 4A 14879*21654502*11 78.002E 26.00 7dF 52.00 4A 14879*21654965*11 232.002E 232.00 4A 14884*21649378*11 379.172E 379.17 4A 14886*21700617*11 432.002E 432.00 4A Now when we try to limit output to just 4A: SORT OC34UD.WORK.SP16504 WHEN OC34UD.07 LIKE ...4A... OC34UD.01 OC34UD.02 OC3 4UD.03 OC34UD.04 OC34UD.05 OC34UD.06 OC34UD.07 09:58:32 02-03-09 PAGE 1 LINE.LINE. PYE AMT ADD. RPTD. AMT SUB. SUBTD DISB OC34UD.KEY CDS TO 2a-2h 2a-2h LN 2a-2h 2a-2h AMT DISB LINE 14464*19030799*2 7 10.81 REP 10.81 2F10.81 PDSB 14683*20382253*1 3509.00 VRC 509.00 2B 509.00 PDSB 14811*21191410*1 1 5.00 VRC5.00 2H 5.00 PDSB 14840*21417980*1 22 21.00 REP 21.00 2C21.00 PDSB 14859*21512820*1 1142.04 VRC 142.04 2F 142.04 PDSB Any ideas/thoughts are welcome... Thanks! Mark --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Windows Live Hotmail.:more than just e-mail. http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t2_hm_justgotbetter_explore_ 012009 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UV - Error when using WHEN [not-secure]
Aw shucks, LIST I_Love_it WHEN I.Get.Packages ;-) -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org]on Behalf Of Hennessey, Mark F. Sent: Tuesday, February 03, 2009 1:03 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UV - Error when using WHEN [not-secure] Apologies - no one has gotten a package from me... important or otherwise! Apparently something in my e-mail triggered our security appliance to lock the message. Sorry! From: Hennessey, Mark F. Sent: Tuesday, February 03, 2009 3:59 PM To: u2-users@listserver.u2ug.org Subject: UV - Error when using WHEN Solaris 10, UV 10.2.2, Information flavor. We are seeing some very odd behavior when trying to use SORT / WHEN on a multi-subvalued field. And by odd behavior I mean totally incorrect output... File Type: Dynamic File Makeup: The file contains associated multivalues and subvalues. Issue: When using the when clause with subvalued Field 7 like '...4a... (DISB LINE column), the only records displayed have PDSB in field 7 no records with 4A are displayed. Here's part of what an unconditional SORT looks like... Notice that OC34.UD.07 (DISB LINE) has values like 'PDSB', 4A. etc. SORT OC34UD.WORK.SP16504 OC34UD.01 OC34UD.02 OC34UD.03 OC34UD.04 OC34UD.06 OC34 UD.07 09:27:25 02-03-09 PAGE 1 LINE. PYEAMT ADD.RPTD.AMT SUB. DISB OC34UD.KEYCDSTO 2a-2h2a-2hLN 2a-2hAMT DISB LINE 14464*19030799*27 10.81REP 10.81 10.81 PDSB 14683*20382253*13 509.00VRC509.00 509.00 PDSB 14811*21191410*115.00VRC 5.005.00 PDSB 14840*21417980*1 22 21.00REP 21.00 21.00 PDSB 14859*21512820*11 142.04VRC142.04 142.04 PDSB 14863*21553328*11 20.00VRC 20.00 20.00 PDSB 14865*700369*1 1 900.00VRC900.00 900.00 PDSB 14869*21548157*17 76.14VRC 76.14 76.14 PDSB 14871*21578431*173.89VRC 3.893.89 PDSB 14877*21601594*17 76.14VRC 76.14 76.14 PDSB 14879*21653295*21 61.002E 61.00 4A 14879*21654502*11 78.002E 26.00 7dF 52.00 4A 14879*21654965*11 232.002E 232.00 4A 14884*21649378*11 379.172E 379.17 4A 14886*21700617*11 432.002E 432.00 4A Now when we try to limit output to just 4A: SORT OC34UD.WORK.SP16504 WHEN OC34UD.07 LIKE ...4A... OC34UD.01 OC34UD.02 OC3 4UD.03 OC34UD.04 OC34UD.05 OC34UD.06 OC34UD.07 09:58:32 02-03-09 PAGE 1 LINE.LINE. PYE AMT ADD. RPTD. AMT SUB. SUBTD DISB OC34UD.KEY CDS TO 2a-2h 2a-2h LN 2a-2h 2a-2h AMT DISB LINE 14464*19030799*2 7 10.81 REP 10.81 2F10.81 PDSB 14683*20382253*1 3509.00 VRC 509.00 2B 509.00 PDSB 14811*21191410*1 1 5.00 VRC5.00 2H 5.00 PDSB 14840*21417980*1 22 21.00 REP 21.00 2C21.00 PDSB 14859*21512820*1 1142.04 VRC 142.04 2F 142.04 PDSB Any ideas/thoughts are welcome... Thanks! Mark --- 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] RE: Internal Visage
Beau, I'm trying to hook into the Virtual Server Manager @ NILWA as I've just had to restart the Linux virtual ` trying to logon as administrator with our usual invisible password with no joy. Created a STAMINA user that I assigned to administrator group ... same story Has anything changed? Is there another user/password I need to be using to get access to this console. Ross Ferris Stamina Software Visage Better by Design! From: Sally Clark [mailto:sallycl...@nilwa.com.au] Sent: Tuesday, 20 January 2009 8:42 AM To: Ryan Hafey; Ross Ferris Cc: NILWA Subject: Internal Visage Hi Guys, We have been experiencing some slow processing speeds this week. No errors till this morning just slow moving. This morning when I opened the BIT viewer to list all cubes I got a pick core dump error (no screen print, I closed out too quick). Could this be related to our slow processing speeds? Cheers Sally Clark IT/HUB Manager Accounts Receivable National Independent Liquor Wholesalers Association Pty Limited Phone: 02 4929 5866 Fax: 02 4929 3622 Mobile: 0438 48 77 99 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Internal Visage
Oops -- obviously I didn't mean to do that. (NOTE TO SELF: check email address after outlook auto-completes) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Tuesday, 20 January 2009 10:17 AM To: Beau Murray Cc: NILWA; Sally Clark; u2-users@listserver.u2ug.org Subject: [U2] RE: Internal Visage Beau, I'm trying to hook into the Virtual Server Manager @ NILWA as I've just had to restart the Linux virtual ` trying to logon as administrator with our usual invisible password with no joy. Created a STAMINA user that I assigned to administrator group ... same story Has anything changed? Is there another user/password I need to be using to get access to this console. Ross Ferris Stamina Software Visage Better by Design! From: Sally Clark [mailto:sallycl...@nilwa.com.au] Sent: Tuesday, 20 January 2009 8:42 AM To: Ryan Hafey; Ross Ferris Cc: NILWA Subject: Internal Visage Hi Guys, We have been experiencing some slow processing speeds this week. No errors till this morning just slow moving. This morning when I opened the BIT viewer to list all cubes I got a pick core dump error (no screen print, I closed out too quick). Could this be related to our slow processing speeds? Cheers Sally Clark IT/HUB Manager Accounts Receivable National Independent Liquor Wholesalers Association Pty Limited Phone: 02 4929 5866 Fax: 02 4929 3622 Mobile: 0438 48 77 99 --- 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] Re: Unidata 6.1 [AIX] DIGEST() function Not Working
Followup. this code works perfectly on Unidata 7.1 on Windows. So is the problem the Unidata version, or the underlying platform? Regardless, is the problem fixable? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: A-correlative explanation
In English: if either or both (attribute 5 value 0) and (attribute 6 Not Equal empty) then show attribute 5 else show value 0 In Step-by-Step: 1. Load value of attribute 5 on stack 2. Load constant value 0 on stack 3. Compare and replace top two elements of stack with 1 if 5 greater than 0 else replace with 0 4. Load value of attribute 6 on stack 5. Load empty string on stack 6. Compare and replace top two elements of stack with 1 if 6 is not empty else replace with 0 7. Replace top two elements of stack with the sum of the top two elements of stack. 8. Load constant value 0 on stack 9. Compare and replace top two elements of stack with 1 if sum(from step 7) is not equal to 0 else replace with 0 10. Load value of attribute 5 on stack 11. Replace top two elements of stack with their product. 12. Return the top element of the stack. As a formula: (((50)+(6#))#0)*5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: Wednesday, November 05, 2008 9:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] A-correlative explanation A coworker asked me if I could help him understand this. I haven't used A-correlatives in about 14-15 years. Based on the data, it looks like if the value of field 6 is greater than 0 or less than zero it displays the value of field 5 otherwise it displays zero. Here is the A-correlative: 0001: A 0002: 99 0003: DEP/AMT 0004: 0005: 0006: 0007: MR2$ 0008: F;5;C0;;6;;#;+;C0;#;5;* 0009: R 0010: 10 And here is the data that is displayed based on it. LIST VISA.DEPOSITS 5 6 5A 11:45:21am 05 Nov 2008 PAGE1 VISA.DEPOSITS TRANS/AMT. APPROVAL DEP/AMT... 24160478 $6.95 $0.00 24158698 $6.95 $0.00 24155720 $6.95 $0.00 24157958 $6.95 $0.00 15180527 $20.00 086489 $20.00 24157310 $6.95 $0.00 24159616 $6.95 $0.00 24157674 $6.95 $0.00 24156462 $6.95 $0.00 24160668 $6.95 $0.00 11751332$-626.18$-626.18 Can anyone explain what F;5;C0;;6;;#;+;C0;#;5;* is doing. Brenda Price UniVerse Programmer Market America Greensboro, NC --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.6/1766 - Release Date: 11/5/2008 7:17 AM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Triggers on a NFS file?
Owww Firstly I doubt the trigger on one system will spot changes made by the other system. But, rather more seriously, we have had UV file corruption which was laid pretty conclusively down to two systems accessing the same dynamic file - oh and one of them, allegedly, only had read access! If you're doing this, I'd say the first rule is DON'T use dynamic files. Preferably use a type 1 file. And only use the file as a staging post. Even then, don't expect it to work all the time, every time. If you control the third system, look at firewalling the UV ports and using port forwarding - with a bit of effort you should be able to get the first two systems to network transparently. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of George Gallen Sent: 23 October 2008 22:05 To: u2-users@listserver.u2ug.org Subject: [U2] Triggers on a NFS file? If I have a NFS mounted directory (on a third non-UV system) which houses a UV format file. I have (2) linux system that have that directory mounted, which each have UV that have a VOC pointer to that file. 1F , 2 /mnt/directory/filename , 3 /mnt/directory/D_filename Both UV systems can read/write to this file, but only one system will be writing to the file, the other will only be reading.I realize locking is not respected from one system to another. If I defined a trigger on this file on the system that will only be doing the reading, will it detect any changes to the file when the other UV makes changes? Basically System1 will be making changes to that file. And System2 will need to update on it's system based on those changes. The reason I'm using NFS is that the two UV systems can't interact easily because they are on different networks, but both have access to the system which is exporting the UV formatted file. George Gallen Senior Programmer/Analyst Accounting/Data Division [EMAIL PROTECTED] ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.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] RE: Triggers on a NFS file?
Hi Wol, But, rather more seriously, we have had UV file corruption which was laid pretty conclusively down to two systems accessing the same dynamic file - oh and one of them, allegedly, only had read access! This is an even worse case of what I brought out in my earlier reply. A dynamic file keeps information about its current modulus and load values (etc) in shared memory. Having this on two separate systems is a recipe for disaster. UV introduced the ALLOWNFS configuration option long ago with a default setting of 0 (no). When I deliver UV training, I take great care to emphasise that setting this to 1 (yes) also means it's all my fault if the file gets corrupted. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
That could be the answer to my question. Tony, you've got to slow down. We all enjoy your posts on this list and you would be missed, but, life is too short, smell some roses. You and I don't know each other personally but I can tell by your writing that you should probably take a vacation instead of paying for a doctor to take one. Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Saturday, October 04, 2008 3:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: spaces in file names I enjoy Tonys insights, what I dont understand is how he ever finds the time to post such long responses not only in here but in cdp and on his own blog as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 04 October 2008 16:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.5/1702 - Release Date: 01/10/2008 09:05 --- 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] RE: spaces in file names
Holy cow. Um, thanks for the concern. Now that this thread has gone non-technical, I'll be the first to request its termination. Best, T --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: spaces in file names
Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
I enjoy Tonys insights, what I dont understand is how he ever finds the time to post such long responses not only in here but in cdp and on his own blog as well -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: 04 October 2008 16:47 To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names Nah, Tony's solid. A bit stressed out - aren't we all? - and amazingly comprehensive in his explanations, but SOLID overall. Then again, not like he needs my endorsement... On Fri, Oct 3, 2008 at 7:59 PM, JPB-U2UG [EMAIL PROTECTED] wrote: Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.7.5/1702 - Release Date: 01/10/2008 09:05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: spaces in file names
For reference, Windows still stores path/file names internally in short 8.3 format. Support for long names and additional characters was added in Windows 95 as an abstraction (a view) over that for common usage where non-technical people want to use file names like: J. Jones Budget, 2007-2008 (revised).doc Chelsea smashed! at homecoming '07.jpg Windows was designed to be an operating system for home users and later became a server. (Most people forget that PC stands for Personal Computer.) Macintosh supported long, friendly filenames back in 1984 for the same reasons. Unix is a system for engineers, not intended to be used by people creating OS-level filenames for their docs or pictures. Now, just to be clear, I didn't suggest that DBMS files should be allowed to have spaces in them, like CUSTOMER MASTER. I was giving IBM a little grief for not making use of a file system enhancement which was added to Windows 13 years ago so that we can put IBM programs under Program Files. There's no need for *nix compatibility at this level, commands like uv, udt, UniAdmin, and the UniSDK tools are all platform-specific, OS-level programs, and have nothing to do with the data in the DBMS. It's almost understandable that paths to data may give the DBMS grief if they contain spaces, like: D:\Data Sources\ABC Company\UV\Accounts\WAREHOUSE But even in this case, if ported to *nix anyone would know to move that to something more appropriate like: /home/data/abc_company/uv/acccounts/WAREHOUSE In either case, the DBMS-level file system should abstract the MV DBA from OS-level issues. For example, we should be allowed to create files like the following without OS-related issues: .TEMP OPEN-A/R CUSTMAST*DEPT That said, the CREATE.FILE verb should also prevent the creation of filenames that are commonly agreed as being a bad idea, like CUSTOMER MASTER. As always (like case sensitivity) this whole situation is just another case of engineers who decide not to make changes because they speak Unix and they expect the rest of the world to do so as well. The burden is not on them to make software work for the target OS but on developers to have to know how another OS works so that they understand why their own platform isn't working. That's just lazy and backwards thinking. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: spaces in file names
Do you wake up on the wrong side of the bed every morning? Jerry Banker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Friday, October 03, 2008 3:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: spaces in file names For reference, Windows still stores path/file names internally in short 8.3 format. Support for long names and additional characters was added in Windows 95 as an abstraction (a view) over that for common usage where non-technical people want to use file names like: J. Jones Budget, 2007-2008 (revised).doc Chelsea smashed! at homecoming '07.jpg Windows was designed to be an operating system for home users and later became a server. (Most people forget that PC stands for Personal Computer.) Macintosh supported long, friendly filenames back in 1984 for the same reasons. Unix is a system for engineers, not intended to be used by people creating OS-level filenames for their docs or pictures. Now, just to be clear, I didn't suggest that DBMS files should be allowed to have spaces in them, like CUSTOMER MASTER. I was giving IBM a little grief for not making use of a file system enhancement which was added to Windows 13 years ago so that we can put IBM programs under Program Files. There's no need for *nix compatibility at this level, commands like uv, udt, UniAdmin, and the UniSDK tools are all platform-specific, OS-level programs, and have nothing to do with the data in the DBMS. It's almost understandable that paths to data may give the DBMS grief if they contain spaces, like: D:\Data Sources\ABC Company\UV\Accounts\WAREHOUSE But even in this case, if ported to *nix anyone would know to move that to something more appropriate like: /home/data/abc_company/uv/acccounts/WAREHOUSE In either case, the DBMS-level file system should abstract the MV DBA from OS-level issues. For example, we should be allowed to create files like the following without OS-related issues: .TEMP OPEN-A/R CUSTMAST*DEPT That said, the CREATE.FILE verb should also prevent the creation of filenames that are commonly agreed as being a bad idea, like CUSTOMER MASTER. As always (like case sensitivity) this whole situation is just another case of engineers who decide not to make changes because they speak Unix and they expect the rest of the world to do so as well. The burden is not on them to make software work for the target OS but on developers to have to know how another OS works so that they understand why their own platform isn't working. That's just lazy and backwards thinking. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.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] RE: spaces in file names
jpb-u2ug wrote: Do you wake up on the wrong side of the bed every morning? snip Um, I'm not sure why you found what Tony wrote offensive. I thought it was a reasonable presentation of his point of view. -- Allen Egerton [EMAIL PROTECTED] 860-912-8067 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: spaces in file names
Not offensive, I just think he sounds angry in a lot of his emails. He really should watch his blood pressure. -- From: Allen Egerton [EMAIL PROTECTED] Sent: Friday, October 03, 2008 5:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: spaces in file names jpb-u2ug wrote: Do you wake up on the wrong side of the bed every morning? snip Um, I'm not sure why you found what Tony wrote offensive. I thought it was a reasonable presentation of his point of view. -- Allen Egerton [EMAIL PROTECTED] 860-912-8067 --- 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] RE: Ssh connections to Universe DB?
Bob Rasmussen wrote: I'm exploring a possibility, and would like feedback. The problem: administrators want the security that SSH offers, but Universe (and some others) running on Windows offers only telnet access. Possible solution: One possible solution would be to setup a linux PC local to the Universe host running a sshd daemon, and configure your windows ssh client to connect to the linux PC with automatic port forwarding, that would open a standard telnet session thru to the Universe host. This telnet session is then passed automatically back thru the ssh connection to the ssh client. This does require a ssh client that understands port forwarding. I used to setup putty on the windows client to open the ssh tunnel for the windows terminal emulator. Art --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: Ssh connections to Universe DB?
I'm exploring a possibility, and would like feedback. The problem: administrators want the security that SSH offers, but Universe (and some others) running on Windows offers only telnet access. Possible solution: 1) Obtain and run an SSH daemon on the Windows server, such as WinSSHd. 2) Run an SSH client with tunneling capabilities, to connect from a Windows desktop, via SSH, to the WinSSHd on the server. 3) Configure that SSH client to do local port forwarding (tunneling) of some arbitrary port (say, 1234) on the client PC to port 23 (the telnet port) on the server's localhost (that is, the server). 4) Run a (2nd) terminal emulator on the client, connected to the client's localhost, port 1234. The client's SSH receives a connection on its port 1234, and forwards it to the server, causing a connection to the server's port 23, where Universe's telnetd receives it. Connection is made. Because the tunneled connection is within the SSH session, it is authenticated and encrypted. I just tested this scenario using AnzioWin (our terminal emulator/SSH client) and it all appears to work. Is anyone doing this? Does anyone have any thoughts on this? It occurs to me that we could add functionality to AnzioWin to allow telnet over SSH all in one running program. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: [EMAIL PROTECTED] company e-mail: [EMAIL PROTECTED] voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Ssh connections to Universe DB?
HI Laure, SSH is possible on windows. However, There isn't a complete SSH solution You have to purchase it (there are some free ones but they are very weak) They don't work with many of the terminal emulators, but it does work with Putty We are using SSL, which is an encrypted telnet protocol. The emulators seem to like SSL better than ssh for windows. SSL is easier but there is work either way. Tom Thomas Whitmore Phone: 800-417-2839 x 4110 Director of Product Development Fax:610-828-8632 E mail: [EMAIL PROTECTED] RATEX Business Solutions, Inc. Web: http://www.ratex.com 2250 Hickory Road, Suite 10 Plymouth Meeting, PA 19462-1047 PRIVACY STATEMENT: The information contained in this electronic mail transmission (including all attachments) is intended only for the use of the individual or entity named in this transmission. If you are not the intended recipient of this transmission, you are hereby notified that any disclosure, copying or distribution of the contents of this transmission is strictly prohibited and that you should delete the contents of this transmission from your system immediately. Any comments or statements contained in this transmission do not necessarily reflect the views or position of RATEX Business Solutions, Inc. or its subsidiaries and/or affiliates. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of IT-Laure Hansen Sent: Wednesday, September 24, 2008 4:13 PM To: u2-users@listserver.u2ug.org Subject: [U2] Ssh connections to Universe DB? I apologize in advance if this has already been covered, but a quick search did not give me what I need (quickly - the inevitable quantifier); that, and a lost battle with the IBM knowledge bases access controls: Universe 10.2.3 on Windows server 2003. Are ssh connections possible? What would it take? Users are coming in using AccuTerm, which supports an ssh connection type. I would like to know about server-side setup. TIA! Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] P Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe http://www.redwoodcity.org/eGov/login.aspx?ref=/egov/index.aspx --- 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] RE: Universe Lock Error
Closing a file apparently releases all the locks. There's an implied close in read_prog, therefore the lock gets released. To fix it, you need to remove the OPEN in read_prog, either by opening the file in COMMON or passing the file pointer as an argument. Yup, I agree that behaviour *might* be broken, but then again it might not. There's arguments both for and against. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bjorn Behr Sent: 18 September 2008 12:05 To: u2-users@listserver.u2ug.org Subject: [U2] Universe Lock Error Morning All We are running on UV 10.2.11 and have encountered an error. Scenario: PROGRAM MAIN_PROG OPEN FILE TO FILE ELSE STOP 201,FILE CALL READ_PROG CRT YOU SHOULD BE HERE...: INPUT X RELEASE FILE, TESTER PROGRAM READ_PROG (A) OPEN FILE TO FILE ELSE STOP 201,FILE READU REC FROM FILE, TESTER ELSE REC = REC1 = 1 WRITEU REC ON FILE, TESTER RETURN PROGRAM READ_PROG (B) OPEN FILE TO FILE ELSE STOP 201,FILE READU REC FROM FILE, TESTER ELSE REC = RETURN With both Program (A) and (B) when READ_PROG returns to MAIN_PROG it releases the Record Lock before the release. Has anybody else encountered this, is there a way to fix it (Work Around / Setting etc...) Regards Bjvrn Behr SUMMIT CORE Developer Tel No: +27 12 673 3251 Fax No: +27 12 673 4681 E-Mail: [EMAIL PROTECTED] [demime 1.01d removed an attachment of type text/x-vcard which had a name of Bjorn Behr.vcf] --- 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] RE: UNIVERSE on Red Hat?
Hi. We have a lot of clients in linux-boxes, with and without cluster. Most of them are new installations, but others came from Aix, from HP-UX, and even from Windows. No one complaints. The biggest one has 350 users (rpc sessions): CentOS 2.6.9-34.ELsmp on a Xeon 3.40GHz and 5Gb RAM Don't forget to have at least MFILES 400 And make sure your Universe release is high enough to manage 64bit files, or you will be in trouble with your 5Gb file. (Try doing RESIZE TESTFILE 18 101 1 64BIT) Regards, __ Augusto Alonso Alonso I.T. Manager Quiter Servicios Informaticos Tel: +34 902 23 33 23 Fax: +34 902 23 42 80 [EMAIL PROTECTED] www.quiter.com __ - Original Message - From: Doug Chanco [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, September 05, 2008 9:56 PM Subject: [U2] RE: UNIVERSE on Red Hat? Hey all, First off thanks for the responses I have gotten so far! A couple more questions: 1. what kind of systems are you running red hat/universe on (model, specs, etc ) 2. what are you doing for high availability? 3. what are you using for backups (software/type of tape drives)? These questions are for people running universe on red hat enterprise server Thanks again everyone! Dougc From: Doug Chanco Sent: Friday, September 05, 2008 9:36 AM To: 'u2-users@listserver.u2ug.org' Subject: UNIVERSE on Red Hat? Hey all, Does anyone have any experience running universe on red hat in an enterprise environment? I have run UV PE on centos and red hat just fine BUT I am talking about 400+ users, uniobjects, tons of printers, etc .. I would LOVE to hear about enterprise experiences running universe on a red hat system in particular; 1. any gotchas? 2. any praises? 3. any performance issues? 4. any universe/OS issues? 5. any printing issues? 6. any issues with terminals or termdefs/termcaps? 7. uniobject problems? 8. anything else anyone may have run across that I did not mention This is really a question for fitzgerlad/long but what about running FAST on linux? (a wonderful chance for a plug here) :-) Any and ALL experiences/thoughts/whatever are welcomed! IF we move it would be from aix 5.2/universe 10.1 to red hat enterprise server/universe 10.2 on a beefed up dell server Our current setup is about @400 users @40 printers @250 uniobjects connections (from a windows app) Connections from datastage throughout the day @3000 pick databases The biggest being @ 5 gig in size Also while this is not really pick related does anyone have any experience with flash copy on linux/red hat? It allows us to unmount file systems and 'flash copy the data to another area and the remount the file system and then make a backup from the flash copy area. Thanks! Dougc --- 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] RE: UNIVERSE on Red Hat?
Hey all, First off thanks for the responses I have gotten so far! A couple more questions: 1. what kind of systems are you running red hat/universe on (model, specs, etc ) 2. what are you doing for high availability? 3. what are you using for backups (software/type of tape drives)? These questions are for people running universe on red hat enterprise server Thanks again everyone! Dougc From: Doug Chanco Sent: Friday, September 05, 2008 9:36 AM To: 'u2-users@listserver.u2ug.org' Subject: UNIVERSE on Red Hat? Hey all, Does anyone have any experience running universe on red hat in an enterprise environment? I have run UV PE on centos and red hat just fine BUT I am talking about 400+ users, uniobjects, tons of printers, etc .. I would LOVE to hear about enterprise experiences running universe on a red hat system in particular; 1. any gotchas? 2. any praises? 3. any performance issues? 4. any universe/OS issues? 5. any printing issues? 6. any issues with terminals or termdefs/termcaps? 7. uniobject problems? 8. anything else anyone may have run across that I did not mention This is really a question for fitzgerlad/long but what about running FAST on linux? (a wonderful chance for a plug here) :-) Any and ALL experiences/thoughts/whatever are welcomed! IF we move it would be from aix 5.2/universe 10.1 to red hat enterprise server/universe 10.2 on a beefed up dell server Our current setup is about @400 users @40 printers @250 uniobjects connections (from a windows app) Connections from datastage throughout the day @3000 pick databases The biggest being @ 5 gig in size Also while this is not really pick related does anyone have any experience with flash copy on linux/red hat? It allows us to unmount file systems and 'flash copy the data to another area and the remount the file system and then make a backup from the flash copy area. Thanks! Dougc --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: UNIVERSE on Red Hat?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Chanco Sent: Friday, September 05, 2008 12:56 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: UNIVERSE on Red Hat? Hey all, First off thanks for the responses I have gotten so far! A couple more questions: 1.what kind of systems are you running red hat/universe on (model, specs, etc ) 2.what are you doing for high availability? 3.what are you using for backups (software/type of tape drives)? We're running UV 10.2.7 on RH ES 5.1. The hardware is a pair of IBM xSeries 3650s with 2GHz CPUs and 15K rpm hard drives configured in a 2-node HA cluster. The HA management software is LifeKeeper from Steeleye. We've been running on this hardware since sometime in April, and prior to that we ran UV 10.1.4 with RH AS 3.0 on a pair of IBM xSeries 345s in the same 2-node HA setup for a little over 3 years. The servers have been running contiuously since the upgrade: 14:58:19 up 139 days, 5:12, 52 users, load average: 0.05, 0.18, 0.17 There is one gotcha with terminal setup if you use ADDS Viewpoint emulation. You'll want to make sure any Viewpoint users have the following entry in their .bash_profile: if tty --quiet; then stty erase '^H' stty susp undef fi Actually, the '^H' backspace fix is needed for any emulation, but without the susp undef setting, Viewpoint terminal sessions with hang if the up-arrow key is pressed. We usually have around 100 terminal users at peak times, and probably average around 30K UniObjects for Java connections per day from our web site. For backups we're currently using a disk-to-disk-to-tape appliance solution from UniTrends. The UniTrends appliance dumps 200GB of UV on-disk backups to a Certance (now Quantum) 8-slot LTO-2 autoloader at the beginning of each month. We also do additional redundant backups before and after our end-of-month batch processing to a 2TB NAS appliance from Aberdeen. I just have a script that uses cp -r at the OS level to copy to an NFS mount for those. -John --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2UG Board Meeting
Yes, that would be nice BUT! Ordinary members would be observers, and that's quite difficult to enforce on a conference call. What would be best if the call could be streamed so that anyone could listen in, but (unless it's changed) the calls are courtesy of IBM on IBM's equipment, and I don't know whether the equipment the board are using even has that capability. Cheers, Wol (ex board member) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 28 August 2008 19:12 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] RE: U2UG Board Meeting Consider opening these conference calls up to ordinary U2UG members. --Bill --- 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] RE: U2UG Board Meeting - Mini Minutes - Aug 26
The U2 User Group Board met via conference call at 4:00p US Eastern time on Tuesday, August 26, 2008. In attendance were Laura Hirsh, David Jordan, Chuck Barouch, Ross Morissey and Susan Joslyn Business discussed included: 7 New logo and color scheme to refresh our image and the web-site 7 Charter amendment to provide for voting when no quorum is present. 7 The vacated position will be filled according to who was next in the vote count, with their acceptance 7 U2UG / IBM liaison still needed. Anyone attending U2U will mention to IBM staff 7 There will be a U2UG meeting at Spectrum (Denver, March 23-26), time to be determined. 7 A new idea was proposed to create a title that is awarded to people to recognize their contribution. Title ideas will be forwarded and this will be discussed again at the next meeting. 7 Carry over business 7 U2UG.COM ` U2UG.ORG 7 Board will nominate thankees and these people/companies will be added with links to the web site (Action: Board to nominate, Brian to add links.) 7 A WIKI training session will be scheduled with Brian Leach so that everyone can post wikis 7 We are still working to get an automated Better Better procedure. [Better Better is the name of the process for users to make recommendations and requests for enhancement to the U2 databases and tools and to get the weight of the user group behind those requests, vet them and take them to IBM.] We have a potential volunteer site host. Submitted by Susan Joslyn, board member at large serving as secretary. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2UG Board Meeting
Consider opening these conference calls up to ordinary U2UG members. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: U2 Users Digest V1 #2329
I will be out of the office on vacation Thursday 8/21 and Friday 8/22. During this time I will have limited access to email. If you need to contact me, please try me on my cell phone. Thanks, Russ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Re: U2 Users Digest V1 #2326
That makes perfect sense. I am only handling UniSessionException and UniSubroutineException in the routine. If I am understanding correctly, I should add a catchall exception. Sort of a KitchenSinkException to account for other exceptions. Thanks a lot. Charles Shaffer Senior Analyst NTN-Bower Corporation David Beahm [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/18/2008 09:29 PM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:[U2] Re: U2 Users Digest V1 #2326 Charles- As I read it, the unhandled exception is happening within the U2 object when you are trying to execute the Java method PbrGetMgrList. I never heard of JavaBridge before, but after reading the requirements at http://php-java-bridge.sourceforge.net/doc/overview.php, I don't think that is the source of the problem (java.inc is a PHP include file, and might be referenced through a URL such as |once(http://localhost:9090/JavaBridge/java/Java.inc;);|). You can verify that the JavaBridge is working by calling a Java method outside of the U2 object prior to calling the PbrGetMgrList method; if it works, then something is happening to your U2 object. I don't have enough to troubleshoot any further at this point. HTH, David Beahm Date: Fri, 15 Aug 2008 11:23:41 -0500 From: [EMAIL PROTECTED] Subject: [U2] Uniobjects for Java Hello, I am accessing our Unidata server from PHP using the java bridge for a few months It has been working pretty well up until the current project I am working on. PHP calls a method in a U2 object, which uses Uniobjects for Java to invoke a UniBasic Subroutine on our Unidata 7.1 redhat based server. Recently I have intermittently received the following error message. ** Fatal error: Uncaught [[o:Exception]:java.lang.Exception: Invoke failed: [[o:U2]]-PbrGetMgrList. Cause: java.lang.NoSuchMethodException: PbrGetMgrList(). Candidates: [] Responsible VM: [EMAIL PROTECTED]://java.sun.com/ at: #-5 php.java.bridge.JavaBridge.Invoke(JavaBridge.java:1045) #-4 php.java.bridge.Request.handleRequest(Request.java:405) #-3 php.java.bridge.Request.handleRequests(Request.java:481) #0 java.inc(257): java_ThrowExceptionProxyFactory-getProxy(52, '@N', true) #1 java.inc(473): java_Arg-getResult(true) #2 java.inc(479): java_Client-getWrappedResult(true) #3 java.inc(672): java_Client-getResult() #4 java.inc(1786): java_Client-invokeMethod(51, 'PbrGetMgrList', Array) #5 java.inc(1910): java_JavaProxy-__call('PbrGetMgrList', Array) #6 java.inc(2072): java_AbstractJava-__call('PbrGetMgrList', Array) #7 [internal function]: Java-__call('PbrGetMgrList', Array) #8 /var/www/pbr/pbr.php(14): Java-PbrGetMgrList() #9 {main}] thrown in java.inc on line 220 I am not sure what this is referring to. I don't find a java.inc anywhere on the web server host. This works most of the time, but sometimes not. and I don't see a pattern. Most of the time it can be fixed by recompiling and rejarring the Java object, but that doesn't always fix it. One thing I wondered about is that this is the first time that I have called a program with no input parameters. Here is the java code. /** * @param none * @return Tab delimited list of MGR_NAMES */ public String PbrGetMgrList() { String result = ; try { OpenU2Session(); UniSubroutine uSub = uSession.subroutine(PbrGetMgrList, 1); uSub.call(); result = uSub.getArg(0); CloseU2Session(); } catch (UniSessionException e) { result = N; } catch (UniSubroutineException e) { result = N; } finally { return result; } } Here is the UniBassic Subroutine code $BASICTYPE 'U' SUBROUTINE PbrGetMgrList(RESULT) * Tab delimits data items EQU HTABTO CHAR(9) * Select records for this supervisor RESULT = 'N' ECMD = SELECT MGRACCT.DATA SAVING UNIQUE NAME EXECUTE ECMD IF @SYSTEM.RETURN.CODE = 0 THEN RETURN *** * Build the list *** RESULT = '' FIRST = 1 LOOP READNEXT ID ELSE ID = '' UNTIL ID = '' * Insert a delimiter unless this is the first record IF FIRST = 0 THEN RESULT := HTAB END ELSE FIRST = 0 END * ADD THE ID RESULT := ID REPEAT
[U2] Re: U2 Users Digest V1 #2326
Charles- As I read it, the unhandled exception is happening within the U2 object when you are trying to execute the Java method PbrGetMgrList. I never heard of JavaBridge before, but after reading the requirements at http://php-java-bridge.sourceforge.net/doc/overview.php, I don't think that is the source of the problem (java.inc is a PHP include file, and might be referenced through a URL such as |once(http://localhost:9090/JavaBridge/java/Java.inc;);|). You can verify that the JavaBridge is working by calling a Java method outside of the U2 object prior to calling the PbrGetMgrList method; if it works, then something is happening to your U2 object. I don't have enough to troubleshoot any further at this point. HTH, David Beahm Date: Fri, 15 Aug 2008 11:23:41 -0500 From: [EMAIL PROTECTED] Subject: [U2] Uniobjects for Java Hello, I am accessing our Unidata server from PHP using the java bridge for a few months It has been working pretty well up until the current project I am working on. PHP calls a method in a U2 object, which uses Uniobjects for Java to invoke a UniBasic Subroutine on our Unidata 7.1 redhat based server. Recently I have intermittently received the following error message. ** Fatal error: Uncaught [[o:Exception]:java.lang.Exception: Invoke failed: [[o:U2]]-PbrGetMgrList. Cause: java.lang.NoSuchMethodException: PbrGetMgrList(). Candidates: [] Responsible VM: [EMAIL PROTECTED]://java.sun.com/ at: #-5 php.java.bridge.JavaBridge.Invoke(JavaBridge.java:1045) #-4 php.java.bridge.Request.handleRequest(Request.java:405) #-3 php.java.bridge.Request.handleRequests(Request.java:481) #0 java.inc(257): java_ThrowExceptionProxyFactory-getProxy(52, '@N', true) #1 java.inc(473): java_Arg-getResult(true) #2 java.inc(479): java_Client-getWrappedResult(true) #3 java.inc(672): java_Client-getResult() #4 java.inc(1786): java_Client-invokeMethod(51, 'PbrGetMgrList', Array) #5 java.inc(1910): java_JavaProxy-__call('PbrGetMgrList', Array) #6 java.inc(2072): java_AbstractJava-__call('PbrGetMgrList', Array) #7 [internal function]: Java-__call('PbrGetMgrList', Array) #8 /var/www/pbr/pbr.php(14): Java-PbrGetMgrList() #9 {main}] thrown in java.inc on line 220 I am not sure what this is referring to. I don't find a java.inc anywhere on the web server host. This works most of the time, but sometimes not. and I don't see a pattern. Most of the time it can be fixed by recompiling and rejarring the Java object, but that doesn't always fix it. One thing I wondered about is that this is the first time that I have called a program with no input parameters. Here is the java code. /** * @param none * @return Tab delimited list of MGR_NAMES */ public String PbrGetMgrList() { String result = ; try { OpenU2Session(); UniSubroutine uSub = uSession.subroutine(PbrGetMgrList, 1); uSub.call(); result = uSub.getArg(0); CloseU2Session(); } catch (UniSessionException e) { result = N; } catch (UniSubroutineException e) { result = N; } finally { return result; } } Here is the UniBassic Subroutine code $BASICTYPE 'U' SUBROUTINE PbrGetMgrList(RESULT) * Tab delimits data items EQU HTABTO CHAR(9) * Select records for this supervisor RESULT = 'N' ECMD = SELECT MGRACCT.DATA SAVING UNIQUE NAME EXECUTE ECMD IF @SYSTEM.RETURN.CODE = 0 THEN RETURN *** * Build the list *** RESULT = '' FIRST = 1 LOOP READNEXT ID ELSE ID = '' UNTIL ID = '' * Insert a delimiter unless this is the first record IF FIRST = 0 THEN RESULT := HTAB END ELSE FIRST = 0 END * ADD THE ID RESULT := ID REPEAT RETURN I suspect that an exception is happening that is not being handled. Any ideas? Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: TCL literal select
Rather than writing a simple program ... SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0 Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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] RE: TCL literal select
Ooops ... COUNT, not DCOUNT Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 13 August 2008 12:01 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Rather than writing a simple program ... SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0 Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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] RE: TCL literal select
Hi, I ended up using this from Martin C. (of Epicor fame). I don't know why none of the TCL examples would work for me. Something to do with Unidata 5.2 and my particular flavor I guess. Thanks to you all a Virtual Field type dictionary using the INDEX function... i.e. 001: V 002: INDEX(F1,'',1) 003: 004: 005: 6L 006: S -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 7:08 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Ooops ... COUNT, not DCOUNT Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 13 August 2008 12:01 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Rather than writing a simple program ... SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0 Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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/ Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: TCL literal select
Bruce: I think it's UD specifically (even D3 works with a number of the suggestions). UD is very finicky with AQL and drives almost ALL PICK people crazy, and many who work both UD and something else concurrently. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Wednesday, August 13, 2008 8:26 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: TCL literal select Hi, I ended up using this from Martin C. (of Epicor fame). I don't know why none of the TCL examples would work for me. Something to do with Unidata 5.2 and my particular flavor I guess. Thanks to you all a Virtual Field type dictionary using the INDEX function... i.e. 001: V 002: INDEX(F1,'',1) 003: 004: 005: 6L 006: S -Original Message- From: Anthony Youngman [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2008 7:08 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Ooops ... COUNT, not DCOUNT Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: 13 August 2008 12:01 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select Rather than writing a simple program ... SELECT PARTS WITH EVAL DCOUNT(F1, '') GT 0 Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: 12 August 2008 21:59 To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: TCL literal select I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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/ Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions
[U2] RE: TCL literal select and SQL Injection
From: Bruce Ordway I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I don't didn't get the original post to this, only replies - weird. What's being described here is the concept called SQL Injection where users intentionally or unintentionally put something in data that causes queries to misbehave. For example: PRINT Enter your customer ID to see your data INPUT CUSTID EXECUTE SELECT ORDERS WITH CUST ':CUSTID:' LOOP ... DISPLAY RESULTS ... What if the user enters: ME' OR NOT 'ME Please excuse my Pick-style syntax, but obviously embedding the user response into the query without filtering will allow anyone to see pretty much anything. Knowledge of the specific query isn't always required, but if the user knows they're working with a MV DBMS it's not tough to alter the query as easily as any SQL query. This isn't the sort of thing MV people grew up on with telnet clients, but it's critical when deploying apps to a public website - even with secured login. The rest of the development world is VERY aware of this concept and we aren't any more immune to it - we've just survived with the good fortune of using obscure software and being a more difficult target than your average LAMP-based website. This is a topic that I decided to NOT write about as the second entry to my blog on website hacking. But considering this is still something I see on a daily basis I decided maybe it is something that needs to be discussed somewhere. remove.thisNebula-RnD.com/blog/tech/2007/01/website-hacks1.html/2 HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: TCL literal select
I tried using the lower case SELECT/LIST to use native UniData syntax, and that did not work. Try writing a simple program to convert the double quotes to something else (like a tilda) then search the I-desc for that. ED BP TILDA SUBROUTINE TILDA(RTN.VAL, ORIG.VAL) RTN.VAL = CONVERT(ORIG.VAL, '', '~') RETURN ED DICT PARTS F1.TILDA I SUBR(TILDA, F1) ... SELECT PARTS WITH F1.TILDA = [~] John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Ordway Sent: Tuesday, August 12, 2008 4:00 PM To: u2-users@listserver.u2ug.org Subject: [U2] TCL literal select Hi, I work with a Unidata/Dataflo system on HPUX. I am having trouble selecting records in my PARTS file. I want to select all parts that have a in the description field (F1). People have been using instead of INCH. This causes problems for me during processing some reports and exports. I have tried quite a few select statements with no success. LIST PARTS WITH F1 = [//] LIST PARTS WITH F1 = // LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = [''] LIST PARTS WITH F1 = '' LIST PARTS WITH F1 = /''/ LIST PARTS WITH F1 = \[]\ LIST PARTS WITH F1 = [\\] LIST PARTS WITH F1 = '' Wildcards on my system are brackets, [ leading and ] following Any ideas on what would work? Somebody showed me once, so I know it can be done. I lost my notes though. Thanks, Bruce Ordway Viking Engineering Development Inc. 5750 Main St. N.E. Fridley, MN 55432 Visit us at www.Vikingeng.com This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. --- 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] RE: SELECT problem with quote characters
In message [EMAIL PROTECTED], Israel, John R. [EMAIL PROTECTED] writes You need the double quotes on the outside of the ... SELECT FILE WITH FIELD LIKE ...LLOYD'S... Alternatively, you can often get away with no quotes. Loosely speaking, you only NEED quotes on the outside if you have spaces in your search string, though if you have a single quote in your search string, that would likely confuse it. The problem is, this is a program constructing a select string. I have no control over what the user types in, and I want to do a literal match. What if they enter something like 6A'S? Basically, I need to quote the search string to get a literal match, which means I need to put quotes outside the dots, which means I need to use all three different quote characters, which then doesn't work :-( Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: SELECT problem with quote characters
OK - I see the problem. True, it will not work the way it is, but there might be a work around. If the string we are looking for could contain both single and double quotes, we are out of luck with the standard way of searching. However, we could write a simple I-desc that calls a program which would return a value where the quotes are replaces with some odd character (like a tilda or some non-printing character). Then have the program tweaked to select on the I-desc looking for these odd characters. For example: Raw data = LLOYD'S I-desc = LLOYD~S Now, instead of: SELECT FILE WITH FIELD LIKE ...LLOYD'S... We would do: SELECT FILE WITH I-desc LIKE ...LLOYD~S... This is not as fancy as you would likely need, but it shows the concept of something that should work. I have also had situations where I needed to determine a non-standard delimiter. To do this, I would build a string of potential characters like: DELIMITERS = [EMAIL PROTECTED]*()_+{}[]\|:;? I would then loop through each of the characters in DELIMITER attempting to find a character that was NOT found in the target string. Once I find one, that character is stored in some fashion and used to encrypt/decrypt as needed. Hopefully, between these two ideas you can get pointed in a useful direction. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: Wednesday, August 06, 2008 7:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RE: SELECT problem with quote characters In message [EMAIL PROTECTED], Israel, John R. [EMAIL PROTECTED] writes You need the double quotes on the outside of the ... SELECT FILE WITH FIELD LIKE ...LLOYD'S... Alternatively, you can often get away with no quotes. Loosely speaking, you only NEED quotes on the outside if you have spaces in your search string, though if you have a single quote in your search string, that would likely confuse it. The problem is, this is a program constructing a select string. I have no control over what the user types in, and I want to do a literal match. What if they enter something like 6A'S? Basically, I need to quote the search string to get a literal match, which means I need to put quotes outside the dots, which means I need to use all three different quote characters, which then doesn't work :-( Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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] RE: SELECT problem with quote characters
You need the double quotes on the outside of the ... SELECT FILE WITH FIELD LIKE ...LLOYD'S... Alternatively, you can often get away with no quotes. Loosely speaking, you only NEED quotes on the outside if you have spaces in your search string, though if you have a single quote in your search string, that would likely confuse it. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Wednesday, August 06, 2008 11:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] SELECT problem with quote characters I'm trying to select a string that contains a single-quote, using the LIKE operator. It works fine with EQ. So if I do a SELECT FILE WITH FIELD EQ LLOYD'S , the select returns exactly what I expect. But if I do a SELECT FILE WITH FIELD LIKE ...LLOYD'S... it returns pretty much the entire file And if I do a SELECT FILE WITH FIELD LIKE \...LLOYD'S...\ it returns nothing. What on earth is the syntax for picking up an embedded quote in data in a LIKE comparison? PIOPEN flavour, by the way. Cheers, Wol --- 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] RE: U2 Users Digest V1 #2306
Here we go again, with the digest sending individual emails. Thanks, Jan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 11:25 AM To: [EMAIL PROTECTED] Subject: U2 Users Digest V1 #2306 U2 Users DigestTuesday, August 5 2008Volume 01 : Number 2306 In this issue: RE: [U2] Wondering why select is not working -- Date: Tue, 5 Aug 2008 10:57:35 -0500 From: Jon Wells [EMAIL PROTECTED] Subject: RE: [U2] Wondering why select is not working Thank you everyone for responding... After seeing this response I had to look it up in the Uniquery Commands Reference manual. I did not know that the UniQuery LIKE keyword was a synonym for MATCH. *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 [EMAIL PROTECTED] 608-363-2100 (fax) *---* - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Friday, August 01, 2008 4:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Wondering why select is not working Because 8a is a pattern that matches 8 consecutive alpha characters. Try this instead: SELECT B10.COMMONAPP WITH ANY AVAILABILITY LIKE '...8a...' Larry Hiscock Western Computer Services - -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Wells Sent: Friday, August 01, 2008 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Wondering why select is not working Hi all, We have a file (Unidata 7.1) called B10.COMMONAPP where a MV'd attribute called AVAILABILITY contains values representing a day and time. AE DICT B10.COMMONAPP AVAILABILITY Top of AVAILABILITY in DICT B10.COMMONAPP, 6 lines, 24 characters. *--: P 001: D 002: 63 003: 004: AVAILABILITY 005: 10L 006: M Bottom. Example record -- 063: sun8a}mon8a}tue8a}wed8a}thu8a}fri8a}sat8a}sun830a}mon830a}tue830a}wed830 a}th u830a}fri830a}sat830a}sun9a}mon9a}tue9a}wed9a}thu9a}fri9a}sat9a}sun930a} mon9 30a}tue930a}wed930a}thu930a}fri930a}sat930a}sun10a}mon10a}tue10a}wed10a} thu1 0a}fri10a}sat10a}sun1030a}mon1030a}tue1030a}wed1030a}thu1030a}fri1030a}s at10 30a}sun11a}sat11a}sun1130a}sat1130a}sun12p}sat12p}sun1230p}sat1230p}sun1 p}sa t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat3 30p} sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun6 30p} mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p} thu7 p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}su n8p} mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu8 30p} fri830p}sat830p Bottom. Can anyone tell us why - SELECT B10.COMMONAPP WITH AVAILABILITY LIKE ...8a... Produces- No data retrieved from current (S)SELECT statement. Thanks, *---* Jon Wells Database Administrator Beloit College Information Services Resources Beloit, Wisconsin 608-363-2290 [EMAIL PROTECTED] 608-363-2100 (fax) *---* - --- 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/ -- End of U2 Users Digest V1 #2306 *** u2-users-digest 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] RE: Invalid Lock Sequence Write Errors
We are also running Epicor's Avanti. I looked at my program vs. what you had written. I noticed 2 things, neither one of which should cause such a serious error, but it might point you in some direction. 1) we are running unaltered software, and the WRITE statement you mentioned is on a different line. Our WRITE is on line 112 while yours is on 115. 2) in our code, it is using a key of WHKEY. You wrote that you are using WH.KEY (note the extra period). If neither of these point you in a useful direction, I would take Wally's advice and call Epicor. I have asked another PICK programmer here with 20+ years of experience, and that error does not sound familiar to either of us. Let us know what the solution is. John Israel Sr. Programmer/Analyst Dayton Superior Corporation 721 Richard St. Dayton, OH 45342 937-866-0711 x44380 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Amy Cook Sent: Tuesday, July 29, 2008 4:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Invalid Lock Sequence Write Errors I'm getting the following error that's bailing me out of a UniData (version 6.0.9) subroutine. Because I thought it might be corruption, I ran guide, found no corruption, but a little undersized. I created a new file at correct modulo, then copied all records from original file over, then renamed new file to INVWHS. All records copied over (did a count on both). Ran guide on the new file and everything was as it should be. But I'm still getting the errors. So...I went in and verified I could edit the individual record, file it, even copy to new record name and delete original, and that's all working. In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 UPL error = 102 : Invalid lock sequence In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 Lockname (376257 1073807361) RX -- 13359104 PT-fid -- (376257 1073807361) IX R(13359104)--[1 0] 703(X 1) In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 upl lock error(102). In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 1:error in U_dyn_hash for file 'INVWHS', key '46483*195', number=6522 In ../../../floprogs/live/LIVE.IIBASE8/BP8.0/_MRPS4029.1 at line 115 Fatal error: WRITE error This is not just one record (hit about 20 so far), but here's the syntax below: The syntax at line 115 is WRITE ITEM.WH ON FILE.WH,WH.KEY. The record was locked about 10 lines earlier... --- 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] RE: Universe ODC field association
What help exactly do you need? Make sure that the @ID is listed in @SELECT or whereever (I try to always list it as the very first field). That way, you can simply JOIN the single-value table to the ASSOCiated table. And have you seen the article on PickWiki? It's a bit out-of-date but still useful - go to the UniVerse page and it's linked from there. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David Katz Sent: 29 July 2008 13:08 To: u2-users@listserver.u2ug.org Subject: [U2] Universe ODC field association I have been working with ODBC on Universe 10.x for a short time, and seem to have the basics working. I need some help setting up the association between the MV fields and regular fields in the file. Any help or examples would be appreciated. Thanks David. --- 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] RE: English phrases
No, they don't... PA LIST MASTER _ BY ATTR1 _ BREAK.ON ATTR1 _ ATTR2 _ TOTAL ATTR3 _ HEADING this is the best heading you ever saw 'D'PAGE 'PLL' _ ID.SUP _ DET.SUP _ LPTR Works a bomb! (provided of course you have a file called MASTER with dict items ATTR1, ATTR2, ATTR3, AND ATTR3 is numeric ;-) Oh, yeah - put a space before each '_' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: 24 July 2008 07:34 PM To: u2-users@listserver.u2ug.org Subject: [U2] RE: English phrases Sorry to bother - I have found that on Universe , all the definitions have to be listed on attribute 2 instead of being in subsequent attributes as we can do on our jBASE system. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: English phrases
Sorry to bother - I have found that on Universe , all the definitions have to be listed on attribute 2 instead of being in subsequent attributes as we can do on our jBASE system. Boyd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: Thursday, July 24, 2008 12:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] English phrases I am trying to use the same phrase in Universe as I use in jBASE, but it is not working properly on our Universe systems. The beginning of my definitions on both jBASE and Universe look like this: ED DICT DH CA.ATTRS DICT DH CA.ATTRS (BACS) Top .P 001 PH 002 PHONE-CHECK 003 COLL.SCORE 004 CA.AVAILCR 005 SSN.DECEASED 006 SSN.DOD 007 292 008 CA.BK7 009 CA.BK11 010 CA.BK13 The problem with the phrase is that it only lists the first definition in the phrase. I just tested by removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others are normal, local definitions), but that is not the issue. Here is the output: LIST DH 6793700 CA.ATTRS 10:36:09am 18 Jul 2008 PAGE1 DEBHIST... COLLECTABILITY 6793700 592 1 records listed. Many more attributes should have been listed. Any ideas? Boyd Parks HOV Services CUBS Software Engineering O: 678-229-5002 C: 770-975-3303 Any technology distinguishable from magic is insufficiently advanced. --Larry Niven's Corollary to Clarke's 3rd Law. [cid:image001.jpg@01C8ED87.ACA82E10] The information contained in this message, including any attachments, is privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution, or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message and destroy all copies of the original message The information contained in this message, including any attachments, is attorney privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message and destroy all copies of the original message. [demime 1.01d removed an attachment of type image/jpeg which had a name of image001.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this message, including any attachments, is attorney privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message 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] RE: English phrases
You can use the underscore at the end of attributes 2 to 9 to indicate continuation on Universe. Laure Hansen, City of Redwood City - Information Technology 1017 Middlefield Road - Redwood City, CA 94063 Office 650-780-7087 - Cell 650-207-3235 - Fax 650-556-9204 [EMAIL PROTECTED] o Please think green before printing this e-mail Subscribe to receive Redwood City E-News, news releases, or other documents via email: Click here to register/subscribe -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: Thursday, July 24, 2008 10:34 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE: English phrases Sorry to bother - I have found that on Universe , all the definitions have to be listed on attribute 2 instead of being in subsequent attributes as we can do on our jBASE system. Boyd -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boyd Parks Sent: Thursday, July 24, 2008 12:21 PM To: u2-users@listserver.u2ug.org Subject: [U2] English phrases I am trying to use the same phrase in Universe as I use in jBASE, but it is not working properly on our Universe systems. The beginning of my definitions on both jBASE and Universe look like this: ED DICT DH CA.ATTRS DICT DH CA.ATTRS (BACS) Top .P 001 PH 002 PHONE-CHECK 003 COLL.SCORE 004 CA.AVAILCR 005 SSN.DECEASED 006 SSN.DOD 007 292 008 CA.BK7 009 CA.BK11 010 CA.BK13 The problem with the phrase is that it only lists the first definition in the phrase. I just tested by removing PHONE-CHECK (it is a Basic subroutine call, whereas all the others are normal, local definitions), but that is not the issue. Here is the output: LIST DH 6793700 CA.ATTRS 10:36:09am 18 Jul 2008 PAGE1 DEBHIST... COLLECTABILITY 6793700 592 1 records listed. Many more attributes should have been listed. Any ideas? Boyd Parks HOV Services CUBS Software Engineering O: 678-229-5002 C: 770-975-3303 Any technology distinguishable from magic is insufficiently advanced. --Larry Niven's Corollary to Clarke's 3rd Law. [cid:image001.jpg@01C8ED87.ACA82E10] The information contained in this message, including any attachments, is privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution, or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message and destroy all copies of the original message The information contained in this message, including any attachments, is attorney privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message and destroy all copies of the original message. [demime 1.01d removed an attachment of type image/jpeg which had a name of image001.jpg] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this message, including any attachments, is attorney privileged and/or confidential information intended only for the use of the individual or entity named as addressee. The review, dissemination, distribution or copying of this communication by or to anyone other than the intended addressee is strictly prohibited. If you have received this communication in error, please immediately notify the sender by replying to the message 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Basic SORT() Function not avail in UniVerse?
John - me too, when I can. In this case I'm reading in a mv list of other record ID's. They are likely in order, but its imperative that they are, so the SORT is a precaution, since 'stuff' happens. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:44 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? When I need an array to be sorted, I always build it that way using the LOCATE command with the BY option. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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] RE: Basic SORT() Function not avail in UniVerse?
Thanks WOL, A colleague also directed me to PickWiki and the thoughts on SORT there are a good read, and show the options. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Tuesday, July 22, 2008 10:53 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? Look on PickWiki - there are several sort routines there. Of course, I'd recommend the SHELL sort :-) NB - which version of UV are you using - it's long fixed but there's a nasty bug in the COMPARE function in 9.6. Cheers, Wol --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: Basic SORT() Function not avail in UniVerse?
Baker, In that case, I do not think there is exactly what you want (or not one I know of). I would write a simple subroutine to do this, and write it such that you can just plug it in where ever you need it, including (and maybe most importantly), into a Dict. Pass it several arguments (like the raw data, what the delimiter is (FM, VM, etc), and such) so that it can be reused anywhere. John -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 1:35 PM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? John - me too, when I can. In this case I'm reading in a mv list of other record ID's. They are likely in order, but its imperative that they are, so the SORT is a precaution, since 'stuff' happens. -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Israel, John R. Sent: Tuesday, July 22, 2008 10:44 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] RE: Basic SORT() Function not avail in UniVerse? When I need an array to be sorted, I always build it that way using the LOCATE command with the BY option. John Israel -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Tuesday, July 22, 2008 10:51 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Basic SORT() Function not avail in UniVerse? Hey, I'm needing to SORT a dynamic array and apparently UniVerse doesn't have this Function. Other MV implementations have this, such as D3 - The sort() function sorts an attribute or value mark delimited str.exp in ascending order. [from ePick] There was also a user exit u1072 that did the same thing. Does anyone have a work around or fast path to same thing maybe I'm missing something but can't see this in UV docs. -Baker --- 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] Re: Going to U2 University 2008?
One of Janet Oswald's email ad broadcasts for U2U indicated that there would be pre-conference chargeable tutorials the day before each of the 4 editions of the conference. The list of tutorials and their charges are not yet on the web-site, but she tells me they should be there tomorrow. These tutorials have been worthwhile in years past. I'm holding off on registering for San Diego until I can see those. I think the regional conference idea is a good one. I attended the San Francisco one 2 prior pan-IBM ones, as well as others off and on dating back to Infocus/VMark days. Pluses: + Cheaper. + Shorter. 2 nights lodging only. + More targeted. (That 2006 Anaheim Information on Demand event for all IBM software users was ghastly. Sure, we got to see Gladys Knight and the Pips and got in free one night to part of Disneyland where the music blared that you couldn't network (the primary purpose for the social events), provided you could even find any fellow U2 users amid the AIX, Tivoli, DB2, etc. users, almost half of whom seemed to be IBM employees.) + If you attend the later venues, the presenters have honed their show a bit. + The audience seemed a bit more technical last year. I'm guessing the lower price shorter time span allowed companies to send technical people other than the mucky-mucks who see these conferences like junkets. + More content, less junket. Minuses: - You don't see some users from other parts of the world. I miss that. - Almost all sessions are presented by IBM staff, since not many independent presenters want to commit to 4 such events. I have always appreciated the presentations by users independent consultant groups, myself, so I miss that. - More content, less junket. (Some people will see that as a minus, anyway.) cds P.S. Pardon me if some of this has already been discussed. I've been unsubscribed for a month long vacation. -Original Message- From: Louie Bergsagel Ah, found the U2 University session abstracts: http://www-306.ibm.com/software/info/u2/university/index3.jsp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Re: Going to U2 University 2008?
Unfortunately I'll be in the wrong part of the planet for all four sessions. I note that the fourth session (in England) clashes directly with Information on Demand 2008 (which is where I will be that particular week). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Re: Going to U2 University 2008?
Ah, found the U2 University session abstracts: http://www-306.ibm.com/software/info/u2/university/index3.jsp --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/