Re: [U2] [UV] ED PERMISSIONS subroutine
On windows, the hosts file is at %windir%\system32\drivers\etc\hosts -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, August 15, 2013 8:04 AM To: U2 Users List Subject: Re: [U2] [UV] ED PERMISSIONS subroutine When we had delays with telnet logins, we traced it back to the reverse DNS That telnetd was doing. If you put the IP addresses of the telnet clients into the hosts file on the UV server Does the delay go away? I believe on windows servers the hosts file is at c:\ but I'm not sure. Format is: IPaddresstabmachinename Ex. 192.168.0.15tabcomputer1 It does not have to be a fully qualified domain name, as if it's in the hosts file, that Usually prevents a reverse DNS lookup. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Thursday, August 15, 2013 10:59 AM To: U2 Users List Subject: Re: [U2] [UV] ED PERMISSIONS subroutine Yes! Actually, the login does also have the same delay. Sad to hear you didn't find a solution... On 8/15/2013 10:35 AM, mhilb...@ppcsoftware.com wrote: Dianne, Does your login to telnet sessions also have this same delay? We experienced this problem (with ED and with Login); never fixed it. The company was a multinational that managed user priveleges at an international corporate level, so even though we are in Argentina, supoosedly there was some validation going on at a server in the US or elsewhere. The multinational sold local operations to a local company and the problem went away when we left the corportate network. On Thu, 15 Aug 2013 09:25:35 -0500, George Gallen wrote: To me, if it is causing a delay that was not there before - raises red flags and back hairs of read disk errors (or gonna be errors soon). Can you do a disk scan? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dianne Ackerman Sent: Thursday, August 15, 2013 9:51 AM To: U2-Users@listserver.u2ug.org Subject: [U2] [UV] ED PERMISSIONS subroutine Does anyone know anything about the -PERMISSIONS subroutine used by the ED verb in Universe? Running 11.1.12 on Windows, the ED verb has a huge delay and we've tracked it down to that subroutine call in the basic ED program. If I could look at that subroutine to see what it's doing, maybe I can figure out what's causing that delay. Thanks! -Dianne ED BP ED.B The file BP is read-only and cannot be updated. 3988 lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS' : L 0308: CALL @PERMISSIONS(EDIT.FILE,EDIT.PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT) : EX ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7
\windows\syswow64 With Microsoft typical logic this is where 32 bit versions of commands reside on x64. 64 bit ones are in system32. Sent from my cell phone. On 2013-07-17, at 3:50 PM, Phil Walker p...@gnosys.co.nz wrote: You need to use the 32bit ODBC Driver Manager which is under the a WOW64??? directory or something similar. I don't have access to a system at the moment. And then use the 32bit ODBC Driver. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 18 July 2013 10:35 a.m. To: U2 Users List Subject: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7 The shipping clerk's XP PC died. I bought him a new Win7 PC. I guess I made the mistake of installing the 64-Bit Rocket ODBC. When I tried to do an ODBC mapping, the United Parcel Service WorldShip desktop software indicated something like an architecture incompatibility when trying to connect to UniVerse 10,3.6 running on HP-Ux Itanium. Even though I uninstalled the 64-bit ODBC from Win7... the 64 bit ODBC still appears in the Win7 Control Panel, Administrative Tools, ODBC Data Sources. Help sorting all this out would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7
I agree... I think moving all the real stuff out of system32 would have been monumental. And the WOW64 part of SysWOW64 stands for Windows On Windows-x64. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Wednesday, July 17, 2013 4:22 PM To: U2 Users List Subject: Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7 Yes, that is it. I always though it strange that the 64 bit ones are under system 32, and 32 under 64sort of reverse psychology. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Thursday, 18 July 2013 11:11 a.m. To: U2 Users List Subject: Re: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7 \windows\syswow64 With Microsoft typical logic this is where 32 bit versions of commands reside on x64. 64 bit ones are in system32. Sent from my cell phone. On 2013-07-17, at 3:50 PM, Phil Walker p...@gnosys.co.nz wrote: You need to use the 32bit ODBC Driver Manager which is under the a WOW64??? directory or something similar. I don't have access to a system at the moment. And then use the 32bit ODBC Driver. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Thursday, 18 July 2013 10:35 a.m. To: U2 Users List Subject: [U2] [U2} UniVerse, ODBC, 64-Bit, Windows7 The shipping clerk's XP PC died. I bought him a new Win7 PC. I guess I made the mistake of installing the 64-Bit Rocket ODBC. When I tried to do an ODBC mapping, the United Parcel Service WorldShip desktop software indicated something like an architecture incompatibility when trying to connect to UniVerse 10,3.6 running on HP-Ux Itanium. Even though I uninstalled the 64-bit ODBC from Win7... the 64 bit ODBC still appears in the Win7 Control Panel, Administrative Tools, ODBC Data Sources. Help sorting all this out would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] Recognition for Rocket and Rocket's U2 in dual rankings today!
Thank you for this information! Very helpful when an outsider wants to know what a MultiValue system is and why it matters... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Monday, June 3, 2013 1:59 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today! If you haven't seen it already, U2 got dual mentions today in top ranks. First: The UniData and UniVerse databases from Rocket Software have been listed for the first time in the database ranking site DB-Engines, making 45/169 (top 27%) on debut. http://db-engines.com/en/ranking Second: Rocket has been listed in the 'DBTA 100: The Companies That Matter Most in Data' with a big mention of the U2 databases from our CEO, Andy Youniss. http://www.dbta.com/Articles/Editorial/Trends-and-Applications/View-from-the-Top-Rocket-Software-89919.aspx http://www.dbta.com/Articles/Editorial/News-Flashes/DBTA-100-The-Companies-That-Matter-Most-in-Data-89876.aspx Regards, Dan ___ 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] [UV] UniObjects.Net vs Thrid-party Products
Hi Perry, I'm a bit late to the party, but we (FusionWare) have a Managed Provider (ADO.NET) that works with U2 and is portable to other MultiValue platforms. If you're looking at options, you might as well have them all. Here are some YouTube playlists that show how our Managed Provider works: http://www.youtube.com/user/fusionwareInt/videos?flow=gridview=1 We've been around for a long time, having released an ODBC driver for MultiValue back in 1992. We have customers who still use both the ODBC, OLEDB, JDBC, and our Managed Provider and have seen some very innovative extensions of MultiValue with 3rd party apps over the years. Thank you, Robert Houben Chief Technology Officer FusionWare Integration Corp. An IBM Advanced Business Partner p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.net http://twitter.com/fusionwareint https://www.linkedin.com/in/roberthouben -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, May 30, 2013 7:34 AM To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Thanks to everyone for all the great feedback! I think I have a much better understanding of the available options. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Peters Bluefinity Sent: Wednesday, May 29, 2013 10:12 AM To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products And from Bluefinity we certainly welcome Dan's endorsement to technology that enhances the use of U2 and makes for happy, long term users as this is great for everyone. There are certainly a lot of happy mv.NET customers in that category. Regards David Peters, Sales Manager at Bluefinity -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 29 May 2013 15:27 To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Thanks for the reply Tony, I can't speak for anyone but Rocket, but we definitely don't feel threatened and encourage everyone to write great applications and share the story, regardless of what technology you use to connect U2 to your front-end. Did I mention share the story? :) Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, May 28, 2013 1:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products From: Daniel McGrath Tony, out of curiosity, have you looked at UO.NET's replacement: U2 Toolkit for .NET? Not recently bud. Once I settle on a toolkit that works well, my research in that specific area slows down. How much research do we continue to do on cars after we've made a purchase? Do we keep house hunting after we move into a new home? It's appropriate to be informed about what's happening in our industry, but I have dozens of platforms, frameworks, toolkits, and related versions that I need to keep up with - that still means time needs to be allocated for hundreds of permutations of all of these blasted software packages that are all supposed to save us time. Like everyone else here, I need to use whatever free time I have to hone my skills with the latest versions of the tools I already use, rather than continue to look into replacements. Despite professional curiosity, at some point we need to stop playing with tools and just hunker down to write real code. I'd like to say that at some point I'll cycle back around for another look at the U2 toolkit, but remember that for my purposes of writing applications that are the same across all MV platforms, a platform-specific tool is generally off of my radar. Sure, it would be nice to save my clients money using free tools, but I have U2 clients that have been running a single license of mv.NET for years. The tiny cost of the tool is trivial in the big picture. People need to think hard about exactly how much free costs them, or how adverse they are to buying a low-cost license for something that will last years. And that's just the cost of the tool. When a U2 site posts a job ad for someone to do UI work or web services, they might say must know U2 Toolkit for .NET. If they have a tool that anyone in the MV industry can use, the scope of candidates broadens to include U2 developers And everyone else. .NET developers have already broadened their scope to the outside world. Once they/we have made that jump, there's no reason anymore to limit one's self to a single MV platform and related tools. A company that is going in this direction should think hard about branching out and then snapping right back again to platform-specific tools. Sure, you're going to find someone who does U2-only work
Re: [U2] [UV] UniObjects.Net vs Thrid-party Products
Hi Perry, We license a server component plus concurrent connections, but we have a starter bundle that includes everything you need including 2 connections. The starter bundle is very competitively priced, and we have customers ranging from small to fortune 500 with workloads ranging from small to huge. Thank you, Robert -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, May 30, 2013 8:35 PM To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Hello Robert. Thanks for the info. I will definitely be having a look at the videos. BTW... what is your licensing model? Thanks. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Thursday, May 30, 2013 9:30 AM To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Hi Perry, I'm a bit late to the party, but we (FusionWare) have a Managed Provider (ADO.NET) that works with U2 and is portable to other MultiValue platforms. If you're looking at options, you might as well have them all. Here are some YouTube playlists that show how our Managed Provider works: http://www.youtube.com/user/fusionwareInt/videos?flow=gridview=1 We've been around for a long time, having released an ODBC driver for MultiValue back in 1992. We have customers who still use both the ODBC, OLEDB, JDBC, and our Managed Provider and have seen some very innovative extensions of MultiValue with 3rd party apps over the years. Thank you, Robert Houben Chief Technology Officer FusionWare Integration Corp. An IBM Advanced Business Partner p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.net http://twitter.com/fusionwareint https://www.linkedin.com/in/roberthouben -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Perry Taylor Sent: Thursday, May 30, 2013 7:34 AM To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Thanks to everyone for all the great feedback! I think I have a much better understanding of the available options. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Peters Bluefinity Sent: Wednesday, May 29, 2013 10:12 AM To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products And from Bluefinity we certainly welcome Dan's endorsement to technology that enhances the use of U2 and makes for happy, long term users as this is great for everyone. There are certainly a lot of happy mv.NET customers in that category. Regards David Peters, Sales Manager at Bluefinity -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: 29 May 2013 15:27 To: U2 Users List Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products Thanks for the reply Tony, I can't speak for anyone but Rocket, but we definitely don't feel threatened and encourage everyone to write great applications and share the story, regardless of what technology you use to connect U2 to your front-end. Did I mention share the story? :) Cheers, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, May 28, 2013 1:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] UniObjects.Net vs Thrid-party Products From: Daniel McGrath Tony, out of curiosity, have you looked at UO.NET's replacement: U2 Toolkit for .NET? Not recently bud. Once I settle on a toolkit that works well, my research in that specific area slows down. How much research do we continue to do on cars after we've made a purchase? Do we keep house hunting after we move into a new home? It's appropriate to be informed about what's happening in our industry, but I have dozens of platforms, frameworks, toolkits, and related versions that I need to keep up with - that still means time needs to be allocated for hundreds of permutations of all of these blasted software packages that are all supposed to save us time. Like everyone else here, I need to use whatever free time I have to hone my skills with the latest versions of the tools I already use, rather than continue to look into replacements. Despite professional curiosity, at some point we need to stop playing with tools and just hunker down to write real code. I'd like to say that at some point I'll cycle back around for another look at the U2 toolkit, but remember that for my purposes of writing applications that are the same across all MV platforms, a platform-specific tool is generally off of my radar. Sure, it would be nice to save my clients money using free tools, but I
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
Actually, Excel does NOT keep the trailing zero, but simply displays it that way. The underlying data (what you get if you retrieve the data from the cell programmatically) is 12.2. Or worse, it could be the result of a division, and you could get 12.20333, but you told Excel to display 2 decimal places. You're right that the original explanation was that we were transforming MM.MM, but this raises two concerns. First, what happens with numbers greater than 99.99? The user gave me a definition and I'm always going to either clarify VERY CAREFULLY or assume that they are making all kinds of assumptions. In short, there are some reasonable human assumptions that you should always account for. Secondly, even if the customer intends that we always get 12.20 stored, someone, someday will look at the data and say to themselves, 'Hey, I can store 12.2! That will save space, and the decimal makes it clear what the number is!' and they'll make a change that breaks your code. I always try to account for reasonable assumptions. E.g: 112.2 and 112.20 and 0112.2000 are the same number. Even a child knows that. If my code isn't at least as smart as a 5th grader, it's too stupid to go to production. ICONV(var,MDn) will always give you a number with 'n' implied decimals, and on most MV platforms will round for you (check your platform - don't assume this one, either!) INT((var * 100) + 0.5) do the same to 2 decimal places (in this case 'n' is the number of zeros you are multiplying your number by.) Simply stripping the decimal out is a very brittle solution, and one I'd never accept in a code review. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: May-08-13 9:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. No when I tell Excel that a column is dollars, or time, it always leaves the trailing zero. What are you doing that makes it remove that? -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, May 8, 2013 9:36 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. They call it Excel! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, May 08, 2013 12:31 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. Haha yes, but again, the original request... If a client sent me dollar figures where 12.2 was supposed to mean 12.20 I would go like ... what kind of system do you run where 12.2 means 12.20 ? I'm assuming that a file you want to read into a Pick system, with embedded MM.MM dollars is coming from an outside source. I can't recall ever seeing 12.2 used for 12.20 outside of a Pick system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable.
But the problem is that those 5th graders are already programming! They get number theory (better than some of us) and they get that 12.2 is the same as 12.20. When you tell them that your program can't handle real numbers, they'll look at you with a look that says Boy, these old guys are DUMB! and then you'll be embarrassed! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: May-08-13 10:15 AM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. You have obviously never watched Are you smarter than a 5th grader?! I wouldn't write off those gradeschoolers quite yet. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Wednesday, May 08, 2013 1:04 PM To: U2 Users List Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. If my code isn't at least as smart as a 5th grader, it's too stupid to go to production. ___ 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] [way ot] - Electronic Button Purshers?
Have to say, I'm enjoying this line of conversation, too. I did some RD work with a guy who created a PC card that pretended to be RS232, so PICK could drive it, but actually drove a wireless. We did some pretty fun things with that device. It died due to problems getting permission to use a meaningful radio frequency for what they really wanted it for. I believe I have a floppy somewhere (probably not readable any more) with the BASIC code that drove the whole thing. Also have code that drove a Motorola pager from PICK. I have to agree that every once in a while it's fun to play around with something challenging and real, where digital and real worlds collide... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: May-03-13 2:03 PM To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? Off subject but just stupid in my case, I lost vertical on my tv lst night. I opened it up found a bad cap in the vert supply 10uf at 100v and transposed the numbers when going throught the caps, inserted a 100uf 10v cap and blew the supply resistor. A new resistor ( why I have resistor on the brain today ) and the right cap and all is well. I seem to be transposing numbers a lot lately. Brain damage finally showing up. Robert - Original Message - From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Friday, May 03, 2013 10:26 AM Subject: Re: [U2] [way ot] - Electronic Button Purshers? I love this conversation - great to see some really geeky stuff going on in the MV community :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 03 May 2013 17:20 To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? OK. Nevermind, I got what you mean. Not pull as push/pull, but rather remove. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, May 03, 2013 12:18 PM To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? ?? not sure what you mean by pull the button? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Frailey Sent: Friday, May 03, 2013 12:12 PM To: U2 Users List Subject: Re: [U2] [way ot] - Electronic Button Purshers? Having a Pi and using it to actuate a solenoid to push a button is like going back into the dark ages with the star ship enterprise. Pull the button and wire in a solid state relay. - Original Message - From: Robert Frailey rfrai...@utahmed.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Friday, May 03, 2013 10:07 AM Subject: Re: [U2] [way ot] - Electronic Button Purshers? magnetic solenoid and a return spring - Original Message - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] Social Networks for MV
Here's another article about social media. While it addresses more consumer facing data, you can easily see how some B2B companies can take advantage of the same concepts: http://www.thetibcoblog.com/2013/03/12/why-do-companies-find-it-so-hard-to-get-social-media-right/?goback=%2Egde_43707_member_225094184%2Egde_43707_member_222896835 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: March-19-13 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Social Networks for MV From: Robert Houben And just to mess with your heads a bit more... http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html Oh dear, you seem to have provoked yet another blog. :) http://nebula-rnd.com/blog/tech/mv/2013/03/socialmv3.html Summary: It's not just the individual services. Each of us has different roles in life. Pinterest might not appeal to us as MV people but it might appeal to the companies we support who wish to use it for marketing. And while you might not want to tweet about your MV epiphanies, in the broad landscape of social media there are many APIs (web services) for extracting data into your MV system, and publishing data from your MV system. As professionals and business people, ignoring this can be a strategic mistake. Thanks for the ongoing inspiration. T ___ 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] Social Networks for MV
Hi Bill, Hootsuite (hootsuite.com) is a tool that allows you to manage the multiple ways to do the same thing problem very handily. There is a free variation that's probably good for any company starting out as it lets you do up to 5 social media outlets for free. Let's see, that's Twitter, a corporate Facebook page, LinkedIn, Google+, I wouldn't recommend starting with more than that, but you can essentially send the same posts to all these places. What's more, you can take a half hour each week, and plan a series of posts, which Hootsuite will let you schedule, and then ignore them. If you set things up right, you can be email notified if someone actually tries to contact you using social media. Alternately, check to see if you have any posts directed to you twice a day. You probably already check email... If you are consumer oriented, you may need to assign more resources to managing the activity on a Facebook page, but then you'll probably get more value from it, too. Note that we are a very small B2B company, but in my opinion, the effort I've put into social media has been hugely rewarded. Of course, your mileage may vary... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: March-28-13 2:55 PM To: U2 Users List Subject: Re: [U2] Social Networks for MV The biggest issue I have this all of this social media craze (emperor's new clothes) is the time it takes to manage multiple ways to do predominately the same thing. Although with enough resources, these marketing avenues are manageable, for small businesses, there aren't enough resources in house. In addition, to outsource requires tremendous luck in the selection process. Secondly, the level of self-absorption in these social media outlets is so monumental, what can I say? It's like talking with someone who spends the entire time preening themselves in from me. Just a thought, or two... :-) Bill Untitled Page - Original Message - *From:* robert.hou...@fwic.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 3/28/2013 2:14 PM *Subject:* Re: [U2] Social Networks for MV Here's another article about social media. While it addresses more consumer facing data, you can easily see how some B2B companies can take advantage of the same concepts: http://www.thetibcoblog.com/2013/03/12/why-do-companies-find-it-so-har d-to-get-social-media-right/?goback=%2Egde_43707_member_225094184%2Egd e_43707_member_222896835 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: March-19-13 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Social Networks for MV From: Robert Houben And just to mess with your heads a bit more... http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html Oh dear, you seem to have provoked yet another blog. :) http://nebula-rnd.com/blog/tech/mv/2013/03/socialmv3.html Summary: It's not just the individual services. Each of us has different roles in life. Pinterest might not appeal to us as MV people but it might appeal to the companies we support who wish to use it for marketing. And while you might not want to tweet about your MV epiphanies, in the broad landscape of social media there are many APIs (web services) for extracting data into your MV system, and publishing data from your MV system. As professionals and business people, ignoring this can be a strategic mistake. Thanks for the ongoing inspiration. T ___ 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] Social Networks for MV
And just to mess with your heads a bit more... http://smallbiztrends.com/2013/03/10-reasons-business-pinterest.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: March-18-13 2:50 AM To: 'U2 Users List' Subject: Re: [U2] Social Networks for MV Tony Good post well stated. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 17 March 2013 04:13 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Social Networks for MV Wow, what an awesome set of responses. Thank you VERY much. There are consistent opinions in many of the responses. So I hope all of you will forgive if I respond to my own post here with a new sub-thread, and with another blog, as I wanted to keep all of the thoughts together. http://Nebula-RnD.com/blog/tech/mv/2013/03/socialmv2.html In summary, what We think about social media is unimportant. What is important is, that is where other people are, so that is where we should be too. I'd be interested to know if this second blog entry prompts any re-consideration. I recognize that this isn't directly a U2 topic. This is more of an industry topic, of which U2 users are a part. Increasingly, U2 is becoming less associated with the MV industry and more a self-contained industry of its own. I don't think that's the right direction. We all lose personally, and the industry suffers, because there are so few common places where MV/Pick users congregate. I'm encouraging people to broaden the horizons rather than furthering the contraction. Our scope as more diversified professionals shouldn't be limited to any one group, or just to U2 groups in different web sites. In this forum in the past, we've discussed the merits of email versus browser-based forums, Usenet, Google Groups, etc. The passionate preferences expressed for all of these media is exactly the same as that expressed, for or against the various social media. I'm suggesting that now the question is not just which forum but what other media should we consider in addition to forums? It's almost the next inevitable question ... Twitter is OK for some purposes, not others. Same with LinkedIn, etc. No one medium is good for all purposes. I think everyone should give proper consideration to each venue, individually, on its merits as a tool for providing and receiving specific kinds of information. Your (really really verbose, thankful, and apologetic) colleague :) Tony Gravagno, Nebula Research and Development USA 949-380-1668 Skype: gravagnot http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno http://www.LinkedIn.com/in/TonyGravagno Visit http://PickWiki.com! Contribute! http://groups.google.com/group/mvdbms ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
How you use these networks depends on the nature of your brand. LinkedIn is the clear winner for B2B interaction, while Facebook is huge for B2C brands, or anything with a mainstream consumer component. I use Facebook for personal connections and LinkedIn for business connections, and I try not to cross-pollinate too much! :) Be aware that according to Gartner, the largest single demographic using Twitter is not teens and tweens, but baby boomers! While the former get all the media attention, your prospective customers and suppliers are probably among the latter. They can all improve your SEO more than anything else you do, but note that Google+ improves it inordinately (I'm pretty sure Google gives it priority.) Your business can curse it if they wish, but ignore it at your peril! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: March-16-13 7:17 AM To: U2 Users List Subject: Re: [U2] Social Networks for MV I try to dabble in the social network stuff. My issue is energy/motivation. Whether we like it or not, social networks aren't going anywhere. I would go so far as to say in about 10 years no one is going to check their email anymore. And if you want new folks talking about MV in an online setting, mailing lists definitely aren't going to get you there. Just visit your local church, or some place where kids hangout and observe them- and you will see. Its a brave new world, whether we like it or not. Learn how to relate to the culture and pass on what you know- or the knowledge will be lost. Happens all the time in the history books. On Sat, Mar 16, 2013 at 8:39 AM, Brian Leach br...@brianleach.co.uk wrote: All social networks are not the same. I am happy to be on LinkedIn which incidentally has good Rocket and Pick groups, but share the distrust of Facebook. Sent from my iPhone On 16 Mar 2013, at 10:31, Symeon Breen syme...@gmail.com wrote: Every company I am involved in has a facebook/linkedin/twitter account and we keep them updated regularly - it is essential in modern business marketing to do this. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 15 March 2013 22:12 To: u2-users@listserver.u2ug.org Subject: [U2] Social Networks for MV I'm on a mini campaign to make more MV colleagues aware of the benefits of using Twitter and other social media. Everyone is welcome to visit my blog on the topic and to comment here or there. http://Nebula-RnD.com/blog/tech/mv/2013/03/socialmv1.html Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services http://Nebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms ___ 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: 2012.0.2240 / Virus Database: 2641/5677 - Release Date: 03/15/13 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Social Networks for MV
Well put! It's not directly a U2 issue, but it will AFFECT U2 developers, users and their customers, so we need to understand it and where appropriate, use it! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: March-16-13 9:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Social Networks for MV Wow, what an awesome set of responses. Thank you VERY much. There are consistent opinions in many of the responses. So I hope all of you will forgive if I respond to my own post here with a new sub-thread, and with another blog, as I wanted to keep all of the thoughts together. http://Nebula-RnD.com/blog/tech/mv/2013/03/socialmv2.html In summary, what We think about social media is unimportant. What is important is, that is where other people are, so that is where we should be too. I'd be interested to know if this second blog entry prompts any re-consideration. I recognize that this isn't directly a U2 topic. This is more of an industry topic, of which U2 users are a part. Increasingly, U2 is becoming less associated with the MV industry and more a self-contained industry of its own. I don't think that's the right direction. We all lose personally, and the industry suffers, because there are so few common places where MV/Pick users congregate. I'm encouraging people to broaden the horizons rather than furthering the contraction. Our scope as more diversified professionals shouldn't be limited to any one group, or just to U2 groups in different web sites. In this forum in the past, we've discussed the merits of email versus browser-based forums, Usenet, Google Groups, etc. The passionate preferences expressed for all of these media is exactly the same as that expressed, for or against the various social media. I'm suggesting that now the question is not just which forum but what other media should we consider in addition to forums? It's almost the next inevitable question ... Twitter is OK for some purposes, not others. Same with LinkedIn, etc. No one medium is good for all purposes. I think everyone should give proper consideration to each venue, individually, on its merits as a tool for providing and receiving specific kinds of information. Your (really really verbose, thankful, and apologetic) colleague :) Tony Gravagno, Nebula Research and Development USA 949-380-1668 Skype: gravagnot http://Nebula-RnD.com/blog http://Twitter.com/TonyGravagno http://www.LinkedIn.com/in/TonyGravagno Visit http://PickWiki.com! Contribute! http://groups.google.com/group/mvdbms ___ 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] [AD] Recipe for MultiValue Data Integration with SSIS made easy!
http://fusionwaremultivalue.blogspot.ca/2013/01/recipe-for-multivalue-data-integration.html Robert Houben Chief Technology Officer FusionWare Integration Corp. An IBM Advanced Business Partner p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.nethttp://www.fwic.net/ LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_badge Twitter http://www.twitter.com/fusionwareint FaceBookhttp://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integration-Corp/115116258510923 Visit our IBM Services Showcasehttp://www.fwic.net/Company/Partners/IBMPartnerShowcase.aspx ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe and ADO connections
[ad] Hi Mike, FusionWare has an ADO.NET managed provider, as well as an OLE DB driver that works with legacy ADO (MDAC). You can find more information about the managed provider here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxManagedProvider.aspx And there OLE DB driver here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxOLEDBProvider.aspx Please don't hesitate to contact us if you have any questions. Thank you, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mike Randall Sent: January-23-13 12:20 PM To: 'U2 Users List' Subject: [U2] Universe and ADO connections Anyone out there have a list of the various ADO connectors for Universe? I'm looking for pros and cons of the various offerings. We had been using the data provider from IBM and now have Rocket's version. As we have experienced some issues,I need to know what is available as options to possibly migrate our current web applications over to. New management and customer complaints about the web applications are a bad combination. Thanks in advance. Mike Randall ___ 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] External database [ad]
Hi Rauf, We at FusionWare have a product called the Connect API that will allow you to do what you are trying to do: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxConnectAPI.aspx This is a blog post that shows code examples: http://www.fwic.net/NewsInfo/FusionWareIntegrationBlogs/tabid/116/EntryId/6/Easy-access-to-SQL-data-from-MV-BASIC.aspx Feel free to contact us at i...@fwic.net or at 1-604-777-4254 x158 for more information. Thank you, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of asad50089 Sent: January-12-13 5:23 AM To: u2-users@listserver.u2ug.org Subject: [U2] External database Hi everyone, I am U2 administrator and needs an assistance. I need read Oracle table from U2 code. Please assist in this regard Thanks Rauf -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39618.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] External database
We work with UV, UD and others on both Windows and *nix, and our customers do intensive volume. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc Hilbert Sent: January-12-13 9:19 AM To: U2 Users List Subject: Re: [U2] External database What os and uv flavor? If its windows and uv ita fairly straight forward for non-intensive use... asad50089 asadr...@live.com wrote: Hi everyone, I am U2 administrator and needs an assistance. I need read Oracle table from U2 code. Please assist in this regard Thanks Rauf -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/External-database-tp39 618.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Secrets was Vinnie Smith
Too late! It's already tomorrow in Australia! The end is HERE!!! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: December-20-12 10:44 AM To: U2 Users List Subject: Re: [U2] Secrets was Vinnie Smith Uh oh, I think the world is coming to an end tomorrow! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, December 20, 2012 1:36 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Secrets was Vinnie Smith When WJ talks about publishing a list of MV end-users I strongly object. But in this case I agree that a list of MV VARs and applications is of value. ___ 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] Advantage of indirect call in BASIC
We use the indirect call method to allow a user to create, for instance, an ITEMPROC subroutine. The subroutine implements a defined interface and the name is provided in the command syntax, so we parse out the subroutine name and call it at run-time. There's no way at compile time that we can anticipate the names that a user might choose for their subroutines that implement our interface. So, providing an open API is a very real case where the CALL @ syntax is critical. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Martin Phillips Sent: December-04-12 6:13 AM To: 'U2 Users List' Subject: Re: [U2] Advantage of indirect call in BASIC Hi, A direct call has to be looked up once in the catalogue system when it is first used. Subsequent calls will be fast because the link has been created. However, if the call is itself in a subroutine and that subroutine exits, it starts clean again on next call and hence may need to rebuild the link. I say may need to because there are various layers of caching that speed all this up. An indirect call starts out with a string variable. The first call will do the catalogue search, link the program, and replace the string with a variable that acts as a fast link to the subroutine. The link only needs to be rebuilt if the variable is overwritten or discarded. This means that putting the indirection variable in a common block that is only initialised once will do the catalogue search only once. Resetting the variable (local or common) before every call will require the search every time, though again caching may help. Long ago, I did some performance comparisons on UV when delivering an Internals course. I have lost the results but I seem to recall that it was well worth using links in common for subroutines that are called enormous numbers of times. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: 04 December 2012 14:01 To: 'U2 Users List' Subject: Re: [U2] Advantage of indirect call in BASIC Does anyone have any current benchmarks on this type of call? Several years ago when I tested it in UniData it was very slow call compared to using the name. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, December 03, 2012 5:39 PM To: u2-users@listserver.u2ug.org Subject: [U2] Advantage of indirect call in BASIC I've not encountered this is my career previously, but now I'm seeing a system written almost entirely with the use of indirect calls in Universe BASIC. That is SOURCE = *SOME.PROGRAM ... CALL @SOURCE(INPUTS) Is there some advantage to the use of indirect calls that a system would be written entirely in this fashion? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] mailserver test
pong... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Egerton Sent: November-18-12 3:46 AM To: .U2 List Subject: [U2] mailserver test ping... ___ 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] [AD] SOAP, REST, and JSON for MultiValue using .NET or Java
[AD] So you all know what assume stands for. I was assuming that our posts to the LinkedIn group would show up here, and they don't. So, with a bit of egg still plastered to my face, here is a summary of some of the recent blog posts we've been posting to Twitter, LinkedIn, Facebook and Google+. Just in case you were feeling left out... Rapid RESTful services for MultiValue http://fusionwaremultivalue.blogspot.ca/2012/10/rapid-restful-services-for-multivalue.html MultiValue to JSON Made Easy http://fusionwaremultivalue.blogspot.ca/2012/10/multivalue-to-json-made-easy.html MultiValue to JSON Made Easy - Java Edition http://fusionwaremultivalue.blogspot.ca/2012/10/multivalue-to-json-made-easy-java.html Rapidly Creating MultiValue Web Services with JDeveloper and mvLynx Java Data Adapter http://www.fwic.net/Resources/FusionWareIntegrationBlogs/tabid/116/EntryId/65/Rapidly-Creating-MultiValue-Web-Services-with-JDeveloper-and-mvLynx-Java-Data-Adapter.aspx?s=uu2d=20121101c=1 Generating W3C Standard Web Services from you MultiValue DAL http://www.fwic.net/Resources/FusionWareIntegrationBlogs/tabid/116/EntryId/46/Generating-W3C-Standard-Web-Services-from-Your-MultiValue-DAL.aspx?s=uu2d=20121101c=1 Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.nethttp://www.fwic.net/ LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_badge Twitter http://www.twitter.com/fusionwareint FaceBookhttp://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integration-Corp/115116258510923 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
I could pretend to do all of these, but frankly, I've never actually written production RPL code. I've also not written anything in about 2 years in Revelation and that was for Revelation G (really old) so I'm not sure it would count. I think that the RPL is the killer. There are people who have done work on multiple MV platforms who can do all the rest, though if you're not talking Revelation G, then Revelation is different, and you have to have done more than just BASIC coding. Of course, as noted, people with that depth of skill are not generally on the hunt... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: November-01-12 10:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Another job ad written by people who have no clue Usually if your experience is more than five years old, employers don't consider it. By the way, I notice that all the people who responded saying they had it, aren't actually looking Can any of you actually write an input and update routine in RPL right now, without consulting a manual? -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Nov 1, 2012 10:02 am Subject: Re: [U2] Another job ad written by people who have no clue Show me a single person in the world who has all of : Universe, Unidata, D3, Jbase, Revelation AND RPL and I will show you a liar Better keep my mouth shut, then, hadn't I ? grin. Mind you I'm surprised they didn't add SMILE for GIRLS... Brian ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2] Parallel processing in Universe
Create an index on a dict pointing at the first character of the key, and have each phantom take two digits. (0-1, 2-3, 4-5, 6-7, 8-9) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: October-01-12 2:43 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Inverting/Pivoting a table
REFORMAT is a TCL command. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: September-10-12 12:39 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table REFORMAT perhaps? I am find no reference to a Unibasic command/statement REFORMAT. Sincerely, 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 Wjhonson Sent: Monday, September 10, 2012 2:20 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table REFOMAT -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Mon, Sep 10, 2012 11:07 am Subject: Re: [U2] Inverting/Pivoting a table On 10/09/12 14:39, Dave Laansma wrote: I get flat files that I'd like to 'flip' to accommodate the multi-value database. For example, given this table: I thought there was a command that would flip a FILE like that. I've never used it, but I recall a colleague making good use of it ... 123456vmDAVID JONESvm1234 MAIN ST.vmANYWHEREvmMIvm12345am 654321vmJOHN SMITHvm4321 MAIN ST.vmANYWHEREvmMIvm12345 Is there a function that will change it to: 123456vm654321am DAVID JONESvmJOHN SMITHam 1234 MAIN ST.vm4321 MAIN ST.am ANYWHEREvmANYWHEREam MIvmMIam 12345vm12345 Right now I use these nested loops, which tend to take a while depending on the size of TABLE: And here you're using dynamic arrays. If you're in PI syntax, do a DCOUNT to get the number of people, dimension some static arrays, and dump the data into that. It'll be MUCH faster. You can REMOVE the elements from the original dynamic array (fast), dump them into your static array(s) (fast), and MATBUILD your new array (fast). NEW.TABLE = FOR A1 = 1 TO DCOUNT(TABLE,@AM) FOR V1 = 1 TO DCOUNT(TABLEA1,@VM) NEW.TABLEV1,A1 = TABLEA1,V1 NEXT V1 NEXT A1 TABLE = NEW.TABLE Sincerely, David Laansma Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
On Windows 7, netstat -help shows this: -fDisplays Fully Qualified Domain Names (FQDN) for foreign addresses. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: September-06-12 1:01 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Windows] There is no -f option on netstat -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 12:15 pm Subject: Re: [U2] [Windows] netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [Windows]
As a professional who works (a lot) with MultiValued systems (many of them U2), I really like the technical content that I run into on here, and contribute when I think I have something useful to say. I get really put out with the personal attacks, but choose generally not to respond. I really, really hate flame wars... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: September-06-12 4:12 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Windows] When someone calls me an asshat, I tend to respond. Did you think somehow you'd get away with that sort of personal abuse? -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 4:11 pm Subject: Re: [U2] [Windows] Really kills you to not have the last word doesn't it. Sort of like a petulant 12 year old. Wjhonson wrote: Uh for a solution that ignored what I wanted? Yeah... uh.. thanks for not answering my question. -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 3:21 pm Subject: Re: [U2] [Windows] Oh yeah, and your welcome, asshat. Wjhonson wrote: There is no -f option on netstat -Original Message- From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Sep 6, 2012 12:15 pm Subject: Re: [U2] [Windows] netstat -f Wjhonson wrote: When a remote PC, asks the Windows server to open a Telnet session, Windows assigns a Process ID to that request. While the telnet session is open,that Process ID will appear in the Windows Task Manager. Is there a way to tell, WHO ask for that Telnet session to be opened? That is, the name of the remote PC, Foreign Address, Mac Address, IP or something of that sort that identifies the requestor/asker ? This has to be done *outside of* Universe, not inside it, for a particular reason. Anyone know the answer? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] OT: A little life humor
I can't find the Like button for this post... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: July-30-12 8:09 AM To: U2 Users Subject: [U2] OT: A little life humor Over the weekend, my son told us not buy any more cards or gifts for his girlfriend, because they have broken up. (not the humorous part). When we told him we were not surprised because we could see the writing on the wall, he seemed stunned And wanted to know whose wall we saw it on! (facebook reference). He still seem puzzled when we explained That it was just a figure of speech, and couldn't understand why we were laughing when we realized he Thought we saw it on facebook. ___ 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] UD - xAdmin Tool Support
In order to use these tools, there's probably a right that you have to grant to your Windows account. Something like Impersonate a client after authentication or something like that. Is there anything in the event log that gives you more information? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: July-12-12 3:03 PM To: U2 Users List Subject: Re: [U2] UD - xAdmin Tool Support Yes. I even did a jig spinning counter-clockwise. :-) Bill - Original Message - *From:* robert.hou...@fwic.net *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 7/12/2012 3:00 PM *Subject:* Re: [U2] UD - xAdmin Tool Support Did you try both user@domain and domain\user formats of user id? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: July-12-12 2:56 PM To: U2 Mail List Subject: [U2] UD - xAdmin Tool Support I have a client where I installed UD v7.3 on a new server in their domain. They use a VPN for external connectivity. I've connected to their VPN and can do the following using my standard (domain) Windows credentials: 1) Remote Desktop to the UD server, 2) Log into UD on the designated telnet port, 3) Telnet to the RDP port 31438. I cannot, however, use the Extensible Administration Tool to access their UD server. I get the following error: Login Failed The combination of user name and password provided is incorrect. I've tried logging in with the domain but nothing works. Any ideas what security settings are preventing me from accessing the UD server. The older UniAdmin tool doesn't work either. Any ideas? Bill P.S. When I go to the Rocket support site I can't access U2 support; I get a page with links to: 1) Rocket Aldon, 2) Rocket M204, and 3) Rocket PASSPORT. My credentials are filled in but the [Submit] button is disabled and I can't get it enabled; thus I can't access U2 support. Any ideas here also? Thanks, ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Select Statement Invalid
Not sure, but is it treating xy as 'xy'? I know in some parsers, if you want to embed a double quote inside of double quotes you just put two side by side. Most PICK systems don't do that, but within a paragraph the rules may be different. Try putting spaces between the values. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: July-11-12 4:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] Select Statement Invalid Unidata 7.1.20, pick flavor I have this quick paragraph to select records based on partial keys: 001: PA 002: SELECT WIPMTLRQ WITH @ID = 299486]302667]318583]337991]374396]376742]382767]385661] 398932]415256]445409]453821] 454353]478175]478845]502457] Bottom. However, this is what I get when I run it: No data retrieved from current (S)SELECT statement. Yet if I run SELECT WIPMTLRQ WITH @ID = 299486] I get records returned. What am I missing? Thanks. Albert DeWitt, CPIM ___ 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] Regarding : Usage of the SEL.CMD
Hi Satya, SEL.CMD is a variable. The := syntax is an append (: is concatenate). It is assigned and then appended to. Note that in this variant of BASIC the '.' can be used as part of a variable name. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: June-08-12 8:59 AM To: U2 Users List Subject: Re: [U2] Regarding : Usage of the SEL.CMD Hi Every One, RECORDS.PROCESSED = 0 ; COUNTER = 0 ; ITEM.CNT = 0 OLD.CLIENT = '' NEW.CLIENT = '' CLIENT.LIST = '' CLIENT.CNT = 0 SEL.CMD = 'SSELECT EMPLOYEE.ACTION.REGISTER USING D.EMPLOYEE.ACTION.REG SEL.CMD :=' WITH TYPE =HR ' IF CLIENT.IDS # '' THEN SEL.CMD :=' AND WITH CLIENT.ID = ':CLIENT.IDS END IF BEGINNING.DATE # '' THEN SEL.CMD :=' AND WITH ENTRY.DATE = ' :BEGINNING.DATE:'' END IF ENDING.DATE # '' THEN SEL.CMD := ' AND WITH ENTRY.DATE = ' :ENDING.DATE:'' END This is the code used.. Thank you, Satya On Fri, Jun 8, 2012 at 11:27 AM, Israel, John R. johnisr...@daytonsuperior.com wrote: Satya , It is probably a common way that the same programmer(s) wrote their code and not an actual command itself. Is SEL.CMD being set to some type of select? For example, does it say something like: SEL.CMD = SELECT file WITH some_criteria I am guessing it is an abbreviation for SELECT COMMAND. As others have said (and if you are still having trouble), please post some of the code (preferably with line #s). John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Colin Alfke Sent: Friday, June 08, 2012 11:22 AM To: 'U2 Users List' Subject: Re: [U2] Regarding : Usage of the SEL.CMD It's likely simply a variable being used to run various commands. Is it being used after EXECUTE/PCPERFORM/UDTEXECUTE statements? If so, you'll need to look up the commands that are being loaded into the variable. hth Colin -Original Message- From: satya satya Hi Everyone, Can any Explain What is the use of SEL .CMD? In the program i have observed many times using this statement. but i didn't getting clarity on it. So Let, me know your valuable suggestions on this topic. Thank you, Satya. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Multivalue Question
20480 == 0x5000 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: June-07-12 9:45 AM To: 'U2 Users List' Subject: Re: [U2] FW: Multivalue Question X = RECORD31 isn't your issue. This is your issue: CNT = DCOUNT(MVDATA, @VM) FOR PTR=1 TO CNT SNGDATA = MVDATA1, PTR ... NEXT PTR Use instead: MORE.FLAG = (MVDATA # ) LOOP WHILE MORE.FLAG DO SNGDATA = REMOVE(MVDATA, MORE.FLAG) ... REPEAT Of course other factors can help your decision on how to store your data. 1. Does it need to be sorted? 2. How do you need to retrieve it? David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt Sent: Thursday, June 07, 2012 9:30 AM To: u2-users@listserver.u2ug.org Subject: [U2] FW: Multivalue Question Unidata 7.1.20 Pick Flavor I am going to end up with a situation where I will have a multivalue field that contains 5500 +/- values. Each value will be 5-characters long. I'm concerned that this will issues with the following statement: X = RECORD31 I've tried searching the manuals and can't find a good answer. Appreciate your input. Albert DeWitt, CPIM ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FW: Multivalue Question
No idea why, but it is a round number when you view it as hex. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: June-07-12 10:01 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] FW: Multivalue Question But why is it significant that it is the same as a simple Octal? 20480 is also 1280 bytes, but I can't see why 1280 is especially significant versus 1200 or 1300 or any other number -Original Message- From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, Jun 7, 2012 9:51 am Subject: Re: [U2] FW: Multivalue Question 20480 == 0x5000 -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of David A. Green ent: June-07-12 9:45 AM o: 'U2 Users List' ubject: Re: [U2] FW: Multivalue Question X = RECORD31 isn't your issue. This is your issue: NT = DCOUNT(MVDATA, @VM) OR PTR=1 TO CNT SNGDATA = MVDATA1, PTR ... EXT PTR Use instead: ORE.FLAG = (MVDATA # ) OOP WHILE MORE.FLAG DO SNGDATA = REMOVE(MVDATA, MORE.FLAG) ... EPEAT Of course other factors can help your decision on how to store your data. 1. Does it need to be sorted? . How do you need to retrieve it? David A. Green 480) 813-1725 AG Consulting -Original Message- rom: u2-users-boun...@listserver.u2ug.org mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Al DeWitt ent: Thursday, June 07, 2012 9:30 AM o: u2-users@listserver.u2ug.org ubject: [U2] FW: Multivalue Question Unidata 7.1.20 Pick Flavor I am going to end up with a situation where I will have a multivalue field that ontains 5500 +/- values. Each value will be 5-characters long. I'm concerned that this will issues with the following statement: X = RECORD31 I've tried searching the manuals and can't find a good answer. Appreciate your input. Albert DeWitt, CPIM ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe/Unidata in the Cloud
As usual this group is a wealth of information. I think the talk to Rocket is the most useful thing. Our OLE DB driver uses Microsofts OLE DB Resource Pooling (built into Windows) to pool. Our other products provide built-in pooling. We've always told our U2 customers that they need to get connection pooling licenses. The wording of the license agreements suggests that whoever wrote it did not understand how most applications use connection pooling. I was curious if this had been cleared up. Unfortunately, if anything goes wrong, unless you have something written to refer to, the actual wording of the license will be used by the courts. Thank you, Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.net LinkedIn Twitter FaceBook -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: June-04-12 1:33 AM To: U2 Users List Subject: Re: [U2] Universe/Unidata in the Cloud I think that there is quite a bit of confusion on different terms. Firstly there is no problem in developing and hosting web based applications using U2, many of the successful U2 applications today are web based. But since U2 is licensed per user what you can't do is simply have a small license that connection pools - in other words runs a few processes that listen for work from a large user base and services them. Instead if you connection pool using Rocket's or your own technology then you need to buy connection pooling licenses. Whilst this pricing model is different to Oracle and Microsoft it is also often less expensive, it all depends on the configuration of the system being implemented. But that's different from SaaS, connection pooling is about a technical architecture whilst SaaS is really a pricing model. You can adopt a SaaS pricing model on an in house application just as you can adopt a conventional user licensing model on an application that is hosted/in the cloud. If you are implementing a true SaaS pricing model, so the customers pay per transaction or per some other metric, and you want to pay for your U2 licenses on the same metric then you need to talk to Rocket or your distributor if you are outside the US. It is almost impossible to have an 'off the shelf' pricing model for this environment because the metrics you use and the software you need to back it up will vary, particularly if the demand is going to be seasonal. But talk about it with whoever you buy from. George Land APT Solutions Ltd U2 UK Distributor On 03/06/2012 07:22, Robert Houben robert.hou...@fwic.net wrote: I should clarify my question. What is the legality behind licensing a SaaS (or BPaaS) offering with a U2 system behind it? I believe at one point there were terms of use in the user license that made a SaaS implementation potentially impractical. BTW, believe it or not, providing Microsoft products in a SaaS environment is a violation of their license agreement, unless you get a special variant of their licenses (these raise the price significantly). This is little known, and to date Microsoft has not been aggressive in enforcing it, but that apparently might be about to change. U2, to my knowledge requires a special type of network license if you are going to provide pooled connections of any sort (e.g. through a web server.) The special terms to look up seem to be Connection Pooling and Concurrent User. My initial read of the section describing these is that if I have potentially 2 million different users who may use my service through web-based connection pooling through the term of the license, (even if not concurrently), I must have licenses enough (2 million of them) to support this. I copy the block of text at the bottom of this message from a copy of the license agreement that I have (possibly out of date - that's part of the question). Their definition of Concurrent seems a bit odd... (BTW, I agree: I would *never* use an unprotected telnet session over the internet. I would be inclined to have the U2 server hiding behind a good solid commercial grade web server.) Connection Pooling (CP): Licensee is not authorized to enable or engage in Connection Pooling unless Licensee is able to count and acquire required Concurrent Session or Concurrent User entitlements covering all unique individuals or single, unique instances of a software application that might process transactions using the Program. CP session entitlements [ which would cover use by any and all unique individuals or unique single instances of software programs over a single logical open, persistent connection ] are optionally available for purchase for use with the Workgroup Edition, but are limited to a maximum of two (2) CP sessions. Enterprise Edition
Re: [U2] Universe/Unidata in the Cloud
I should clarify my question. What is the legality behind licensing a SaaS (or BPaaS) offering with a U2 system behind it? I believe at one point there were terms of use in the user license that made a SaaS implementation potentially impractical. BTW, believe it or not, providing Microsoft products in a SaaS environment is a violation of their license agreement, unless you get a special variant of their licenses (these raise the price significantly). This is little known, and to date Microsoft has not been aggressive in enforcing it, but that apparently might be about to change. U2, to my knowledge requires a special type of network license if you are going to provide pooled connections of any sort (e.g. through a web server.) The special terms to look up seem to be Connection Pooling and Concurrent User. My initial read of the section describing these is that if I have potentially 2 million different users who may use my service through web-based connection pooling through the term of the license, (even if not concurrently), I must have licenses enough (2 million of them) to support this. I copy the block of text at the bottom of this message from a copy of the license agreement that I have (possibly out of date - that's part of the question). Their definition of Concurrent seems a bit odd... (BTW, I agree: I would *never* use an unprotected telnet session over the internet. I would be inclined to have the U2 server hiding behind a good solid commercial grade web server.) Connection Pooling (CP): Licensee is not authorized to enable or engage in Connection Pooling unless Licensee is able to count and acquire required Concurrent Session or Concurrent User entitlements covering all unique individuals or single, unique instances of a software application that might process transactions using the Program. CP session entitlements [ which would cover use by any and all unique individuals or unique single instances of software programs over a single logical open, persistent connection ] are optionally available for purchase for use with the Workgroup Edition, but are limited to a maximum of two (2) CP sessions. Enterprise Edition is offered with two (2) initial Rocket CP sessions with optional additional CP session entitlements available for purchase. ... that might process transactions... This would effectively blow any SaaS or BPaaS option out of the water for a U2 based application. I may be misunderstanding the above, or there may be a different license available somewhere, hence my question. Thank you, Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.net -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: June-02-12 4:04 PM To: U2 Users List Subject: Re: [U2] Universe/Unidata in the Cloud Just so I'm clear... what exactly would be different about such a license? Seems to me the typical licensing terms would work just fine, as long as you have enough seats to handle the traffic. I would, however, be concerned about opening up the telnet port on a cloud architecture. On Fri, Jun 1, 2012 at 6:05 PM, Robert Houben robert.hou...@fwic.netwrote: Does Rocket license Universe or Unidata for use in the cloud? Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.nethttp://www.fwic.net/ LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_ba dge Twitter http://www.twitter.com/fusionwareint FaceBook http://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integra tion-Corp/115116258510923 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Universe/Unidata in the Cloud
Does Rocket license Universe or Unidata for use in the cloud? Robert Houben IBM Certified Solution Advisor and Architect - Cloud Computing Architecture Chief Technology Officer FusionWare Integration Corp. p: 604-777-4254 x158 f: 604-608-5544 http://www.fwic.nethttp://www.fwic.net/ LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_badge Twitter http://www.twitter.com/fusionwareint FaceBookhttp://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integration-Corp/115116258510923 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Proc question
In a PQN PROC, in addition to the MV command, the IH command can do output conversions: MV %2 IH%1:G1*1: Or input conversions: IH%2;D; -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: May-09-12 8:28 PM To: U2 Users List Subject: Re: [U2] Proc question PQN procs are supported in unidata for sure. Just wasn't sure if the conversions on the MV command work there. You can use the universe proverb documentation as a starting point for working with procs in unidata, but there are a lot of differences, including some fundamental ones. For example, both PQ and PQN proc on universe use attribute marks to delimit fields in the buffers, but PQ proc in unidata uses the standard space delimiters.The universe proverb manual doesn't mention conversions on the MV command On May 9, 2012, at 11:23 AM, Brenda Ives wrote: Guide to ProVerb - UniVerse proc documentation. Brenda L Ives UniVerse Team Lead Rapid Response Team marketamerica.com/SHOP.COM Greensboro, NC 336-389-5950 RRT Team Red -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Wednesday, May 09, 2012 11:05 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Proc question Hi Ed,I am pretty sure that PQN procs are supported in Unidata, I have never used them or seen a manual for them. Like you I have not found anything in the udtdocs that addresses Proc eitherKebbon From: u...@edclark.net Date: Mon, 7 May 2012 22:58:31 -0400 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Proc question On May 7, 2012, at 4:45 PM, Kebbon Irwin wrote: Anyone know/remember how to do this:I have a string in my input buffer XX*YYYNNI want to place just YYYNN in my output bufferI feel I should be able to do this without writing my own user mode or a program that does a procread/procwriteThanks,Kebbon Unidata 7.1 Ecltype P ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users I don't know if unidata supports this (has anyone ever seen a unidata proc manual?) but in PQN proc on Reality, the MV command can apply a conversion: MV Purpose To copy data between the input buffer, output buffers, file buffers and select registers. Syntax MV destination source{,source}...{,*{n}}{,_} or MV destination source{*source}... Syntax Elements destinationis a direct or indirect reference to a buffer or select register that you want the data copied to. If the destination is a select register, the source can only be a direct or indirect reference to a file buffer. source is the data you want to copy. The source can be: * a direct or indirect reference to a buffer or select register that contains the data you want to copy. * a direct or indirect reference to a buffer followed by ';input-conversion;' or ':output-conversion:'. See the topic English Conversions for details. *a string of zero or more characters enclosed in single or double quotes. An uneven number of quotes now gives a syntax error. *a SYSTEM function that returns system/database information. * a single character expressed in one of two ways: Xxwhere x is a hexadecimal number in the range 00 to FF. Thus, XFD is a value mark. In where n is a decimal number in the range 0 to 255. Thus, I253 is a value mark. ,* copies all source parameters starting with the specified parameter. The destination buffer or select register is truncated after the last parameter is copied if * is the last operand in the source field. ,*n copies n further source parameters following (and in addition to) the specified parameter. ,_ specifies that the destination is truncated after the source is copied. *source concatenates the source values into one attribute in the destination. Select Register Destination If you use a select register as the destination, then the only valid source is a direct or indirect reference to a file buffer. For example: MV !1 5.9 or MV !3 3.%1 Creating Null Attributes or Parameters If the attribute or parameter number in destination is larger than the current number of attributes or parameters, the Proc processor automatically creates null values to space out to the requested location. If the source is a literal string containing just two double quotes, then the destination is nulled. Input Buffer Pointer If you reference the primary input buffer as the destination, that buffer is selected as active and the buffer pointer is positioned at the beginning of the moved string. Copying a Series of Values If you give a
Re: [U2] FW: [MailServer Notification]Content Filtering Notification
You're probably not allowed to kill the zombie. It's discrimination. On the other hand, you *can* create a honeypot of brains and trap them. Much more humane! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: March-27-12 11:28 AM To: U2 Users Subject: [U2] FW: [MailServer Notification]Content Filtering Notification Is this real? Or did I get spammed by a bot scraping the U2 archives? I couldn't figure out what anything in my post that would have triggered it. Anyone else getting these? George -Original Message- From: Administrator [mailto:sme...@omnicare.com] Sent: Tuesday, March 27, 2012 1:44 PM To: George Gallen Subject: [MailServer Notification]Content Filtering Notification This email has violated the PROFANITY. and Quarantine entire message has been taken on 3/27/2012 1:43:37 PM. Message details: Server: OCR2K8EXHUB01 Sender: ggal...@wyanokegroup.com; Recipient: u2-users@listserver.u2ug.org; Subject: Re: [U2] Detecting idle time in INPUT statement. ___ 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] AS2 Integration
[AD] Better put this here, as it involves our products. We did this for a customer of ours, using VLTrader and FusionWare Integration Server with the mvLynx Connect VLTrader Edition. More info about it here: http://www.fwic.net/Resources/FusionWareIntegrationBlogs/tabid/116/EntryId/43/The-Unlock-Code-for-MultiValue-Trading-Partner-Interaction.aspx Our customer processes in excess of 200,000 instructions per year (both ways) between their trading partners and themselves. [/AD] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: March-01-12 12:50 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] AS2 Integration Hi all, Just a quick question to the group to see if anyone has done any integration between AS2 and Universe and how they have done this? Cheers Phil ___ 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] AS2 Integration
VLTrader is a Cleo product as well. I agree, their support has always been good. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: March-01-12 1:21 PM To: U2 Users List Subject: Re: [U2] AS2 Integration We use a product called Lexicom from a company called Cleo. It is a very nice server based product and serves us flawlessly. It imports the EDI documents and deposits them in a directory that we access from UV. The product is great and the support from Cleo is terrific ((except that it is a call back support format). Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, March 01, 2012 3:50 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] AS2 Integration Hi all, Just a quick question to the group to see if anyone has done any integration between AS2 and Universe and how they have done this? Cheers Phil ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org 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] AS2 Integration
From a blog post I did (linked to in my earlier reply to this question): Sometimes referred to as EDI over HTTP, AS2 is a specification about how to transport data securely and reliably over the internet, using digital certificates and encryption. Certification with this standard guarantees that your product will interact with all other certified products, enabling you to participate in electronic commerce with over 20,000 companies. This can help to identify you as a preferred supplier for larger companies who may wish to purchase or resell your products. In addition to ensuring that the instructions are transferred securely, the standard defines a mechanism whereby you will receive a receipt from the trading partner, which they cannot refute. The legal term for this is non-repudiation. The Drummond Group has been tasked by the standards body with certifying that all providers are interoperable. Information about them and the standard is available here: http://www.drummondgroup.com/index.php/b2b-certified-products/certified-products/as2 HTH, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: March-01-12 1:23 PM To: U2 Users List Subject: Re: [U2] AS2 Integration Ok. So I'm going to ask the dummy question. What is AS2? I found this, but, somehow I doubt this is what you are talking about... http://en.wikipedia.org/wiki/AS2 On Thu, Mar 1, 2012 at 4:21 PM, Robert Houben robert.hou...@fwic.netwrote: VLTrader is a Cleo product as well. I agree, their support has always been good. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: March-01-12 1:21 PM To: U2 Users List Subject: Re: [U2] AS2 Integration We use a product called Lexicom from a company called Cleo. It is a very nice server based product and serves us flawlessly. It imports the EDI documents and deposits them in a directory that we access from UV. The product is great and the support from Cleo is terrific ((except that it is a call back support format). Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -- -- -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Phil Walker Sent: Thursday, March 01, 2012 3:50 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] AS2 Integration Hi all, Just a quick question to the group to see if anyone has done any integration between AS2 and Universe and how they have done this? Cheers Phil ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- John Thompson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http
Re: [U2] XML arrays
Make sure that the programmer understands, if he is using an event-driven parser, that you may get the text in an element in multiple calls to the receivedText (or equivalent) event handler. You get to accumulate it. Don't assume it will come back in just one chunk. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Goble Sent: February-29-12 1:30 PM To: U2 Users List Subject: [U2] XML arrays I have a programmer who is performing an https call and retrieving data back from the webserver, but some of the data is coming back truncated. The web developer said that there is an array inside the xml that is being truncated. Has anyone seen this type of issue?We are running Unidata 7.2.12 on AIX. Thanks, Dan Dan Goble | IT Senior Software Engineer Interline Brands, Inc. 804 East Gate Drive Suite 100, Mount Laurel, NJ 08054 Office: 856.533.3110 | Mobile: 609.792.6855 E-mail: dan.go...@interlinebrands.com | Website: www.interlinebrands.com This e-mail and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. Please notify the sender immediately by e-mail if you have received this e-mail in error and delete all copies of this message. ___ 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] Universe's DOS command
They actually do document these. Go to a command prompt and type: cmd /? Or help cmd (Both produce the same output) Enjoy! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: February-15-12 11:00 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe's DOS command Oh... My... God Amazing try DOS /C DIR then try DOS /K DIR how come they don't document this and we have to make guesses? -Original Message- From: Bob Rasmussen r...@anzio.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 15, 2012 10:38 am Subject: Re: [U2] Universe's DOS command An educated guess would be that the DOS command invokes the command rocessor (command.com in long-ago Windows, cmd.exe now) and passes the \c (or is it /c?) to it. If in Windows you open a CMD prompt, and type cmd /? ou can see what options it accepts. My output includes: /C Carries out the command specified by string and then terminates Further down the help display, it gives more information. On Wed, 15 Feb 2012, Wjhonson wrote: The DOS command in Universe takes a /c argument and then you can specify a at file like DOS \c test.bat What does \c mean? Are there other arguments like \z or \x that it can take? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Regards, ...Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com 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 __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe's DOS command
The /k option is used to run a command (like a batch file) and keep the command shell around for more commands. The only difference to the /c option is that it does not immediately close after running your command. *nix doesn't have a /k option (but might have a different one). I suspect Universe doesn't document it because what that CMD prompt can do is dependent on the version of DOS/Windows you are running. They pass off to the O/S cmd.exe executable and it's up to that to determine what it does. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: February-15-12 1:14 PM To: U2 Users List Subject: Re: [U2] Universe's DOS command I Tried doing the same with UV/Unix (except with the SH command). Sh -c 'ls' gives me directory Sh -k 'ls' gives a strange error: /bin/ls: /bin/ls: cannot execute binary file I don't have a DOS box to test DOS on, so what happened when you did DOS /K...? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, February 15, 2012 4:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe's DOS command I mean they are not document in the Universe manuals for the DOS command executable at TCL. You only get the /c It doesn't even tell you where to go to get more information. Like There are other options, go to Dos and type cmd /? ___ 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] Universe's DOS command
It depends... You are in DOS mode (as opposed to window mode). If you launch anything that requires a graphical environment, it will launch that environment as LocalSystem or something equivalent and you'll have a problem (you can end-task in task-manager - you've probably already figured that out). In theory, you can execute just cmd.exe (with no /c option) and you will be able to provide it input through the keyboard. You just can't do anything that requires window mode. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: February-15-12 3:57 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe's DOS command Oh wow. Urm So any command that requires input will hang, I got that, because it's not actually opening an interactive session with *your process* but rather with the server (or thereabouts). So I just connected to the server and checked Task Manager and there are a lot of processes with my name on them from failed attempts where some input was requested. Which also tells me why files weren't closing and updating, and why I was getting errors that files were still in use and so on. -Original Message- From: Ed Clark u...@edclark.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 15, 2012 3:35 pm Subject: Re: [U2] Universe's DOS command yeah, they left that out. If you look at the docs for the SH. CSH, and VI ommands, they suggest that you look at the unix documentation on those ommands, but they don't mention it in the manual for DOS. Maybe they assumed ou would figure that out by looking at the VOC entry: DOS 01 V 02 cmd.exe 03 U 04 TICERGM 07 /Q The U on line 3 of the VOC means that running the verb will execute line 2 as an s command and pass the rest of the command line to the os command. If you anted to you could create your own verbs like this, for example if you have ygwin installed you could run the cygwin shell instead of the cmd.exe shell. his is more useful on unix than on windows, because the command needs to run in he console and not try to open desktop windows. If, for example, you try to run OTEPAD.EXE like this, your terminal will hang because notepad is running omewhere in a virtual desktop that you can't get to. If you try to use the SH verb on windows, or the DOS verb on unix, you get a essage telling you the command doesn't work on your OS. The E on line 4 of he voc controls this. Verbs with an E run on windows but not on unix. (There's chapter on this in the system description manual). On Feb 15, 2012, at 4:08 PM, Wjhonson wrote: I mean they are not document in the Universe manuals for the DOS command xecutable at TCL. You only get the /c It doesn't even tell you where to go to get more information. Like There are other options, go to Dos and type cmd /? -Original Message- From: Robert Houben robert.hou...@fwic.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Feb 15, 2012 1:00 pm Subject: Re: [U2] Universe's DOS command They actually do document these. Go to a command prompt and type: cmd /? Or help cmd (Both produce the same output) Enjoy! -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: February-15-12 11:00 AM o: u2-users@listserver.u2ug.org ubject: Re: [U2] Universe's DOS command h... My... God mazing try DOS /C DIR hen try DOS /K DIR how come they don't document this and we have to make guesses? -Original Message- rom: Bob Rasmussen r...@anzio.com o: U2 Users List u2-users@listserver.u2ug.org ent: Wed, Feb 15, 2012 10:38 am ubject: Re: [U2] Universe's DOS command n educated guess would be that the DOS command invokes the command rocessor command.com in long-ago Windows, cmd.exe now) and passes the \c (or is it /c?) to it. f in Windows you open a CMD prompt, and type cmd /? u can see what options it accepts. My output includes: /C Carries out the command specified by string and then terminates urther down the help display, it gives more information. n Wed, 15 Feb 2012, Wjhonson wrote: The DOS command in Universe takes a /c argument and then you can specify a t ile like DOS \c test.bat What does \c mean? Are there other arguments like \z or \x that it can take? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users egards, ..Bob Rasmussen, President, Rasmussen Software, Inc. ersonal e-mail: r...@anzio.com ompany e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com treet address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA
Re: [U2] Building an Excel File
The trick is to NOT read up to a CR or LF, first, and process that as a line. You have to read the file as a stream, literally byte-by-byte, and recognize when you are processing quotes and handle that with different logic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: February-09-12 9:04 AM To: U2 Users List Subject: Re: [U2] Building an Excel File What Symeon suggests should still work, since the break is inside the quotes (assuming your using Quoted csv and not tabs), so if you go byte by byte, if you encounter a cr that is inside quotes Escape it and keep reading, if you encounter a cr that is between quotes, consider that the end of the row. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:57 AM To: U2 Users List Subject: Re: [U2] Building an Excel File The problem occurs before it ever gets to UV (or in my case jBASE). The csv flat file already has the cell split into 2 lines. On 02-09-2012 10:53 AM, Symeon Breen wrote: It is entitrely possible and ok to have new lines inside a cell in excel and inside a cell in a csv The following col1,2,col3 and New line,col4 Is ok because the new line is inside the quotes of col3 The trick when parsing in u2 is to not do it line by line, but byte by byte ___ 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] Building an Excel File
Until someone decides to skip trailing, empty columns... :o YMMV -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: February-09-12 9:25 AM To: U2 Users List Subject: Re: [U2] Building an Excel File Hmmm... getting a bit complicated now. I think George's suggestion to DCOUNT the header line and concat if the number of columns are less might be simpler. I really appreciate all the ideas, though. They give me something to think about. Charlie Make things as simple as possible, but not simpler. - Albert Einstein On 02-09-2012 11:16 AM, Robert Houben wrote: The trick is to NOT read up to a CR or LF, first, and process that as a line. You have to read the file as a stream, literally byte-by-byte, and recognize when you are processing quotes and handle that with different logic. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: February-09-12 9:04 AM To: U2 Users List Subject: Re: [U2] Building an Excel File What Symeon suggests should still work, since the break is inside the quotes (assuming your using Quoted csv and not tabs), so if you go byte by byte, if you encounter a cr that is inside quotes Escape it and keep reading, if you encounter a cr that is between quotes, consider that the end of the row. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Thursday, February 09, 2012 11:57 AM To: U2 Users List Subject: Re: [U2] Building an Excel File The problem occurs before it ever gets to UV (or in my case jBASE). The csv flat file already has the cell split into 2 lines. On 02-09-2012 10:53 AM, Symeon Breen wrote: It is entitrely possible and ok to have new lines inside a cell in excel and inside a cell in a csv The following col1,2,col3 and New line,col4 Is ok because the new line is inside the quotes of col3 The trick when parsing in u2 is to not do it line by line, but byte by byte ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [U2} Job Opportunity
We had a customer with a QA app written in PowerBuilder, accessing data in Universe on HP, over 10 years ago, but it's probably not the most common combination! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: February-03-12 1:17 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [U2} Job Opportunity Powerbuilder with Universe? I have never heard of that combo until this very day -Original Message- From: Bill Brutzman bi...@hkmetalcraft.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Feb 3, 2012 1:11 pm Subject: [U2] [U2} Job Opportunity Location:Springfield, MA ull Time alary range : DOEk/Yearly OCKET SOFTWARE UniVerse development with 5 year experience owerBuilder 6 NIX pplication Support Daya Shashtri 30-246-6039 a...@enterprisesolutioninc.com ww.enterprisesolutioninc.com -Talk: daya.esi M: shashtri_2k6 __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Brilliant? or not?
And as a side-note most compilers worth using will generate the same machine instructions when you optimize, so there's no benefit in the cute versions. The more long-winded readable version is much more valuable in the long run... IMO -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: January-16-12 10:54 AM To: U2 Users List Subject: Re: [U2] Brilliant? or not? This is one of the reasons why I continue to x=x+1 instead of x++ Not all languages support the ++, but they all support x=x+1 George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, January 16, 2012 1:50 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Brilliant? or not? From: Charles_Shaffer Aside from it not being readable, compacting C code like that can reduce portability. Different compilers may evaluate complex, compacted code differently. Same thing has actually happened with BASIC code that's ported from one platform to another. Rule of thumb: Don't get cute. Spell out the code so that any dumb compiler or programmer can read it. On-topic: that makes my response to this thread, not. One of our colleagues from the mid 80's wrote code that was so clean I liked to say we could eat off of it. I think he still reads this forum: So to Mark Vander Veen, here we are over 20 years later and I Still appreciate your code. Now THAT is Brilliant. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD Win 7.2 / Line Number with warning messages
Your programs were not compiled with debugging info, so there are no line numbers in them. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: January-09-12 3:53 PM To: U2 Users List Subject: [U2] UD Win 7.2 / Line Number with warning messages When I was working with UD 6.x on an HP-UX (Unix) machine I remember warning messages such as uninitialized variables gave the line number in program. I just installed UD 7.2 for Windows and the warning messages just give the message no line number. Am I missing some secret config option? I should mention I'm also running SB 6.1. Any help would be greatly appreciated. Thanks, Don Verhagen ___ 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] Is there any ORM's for Universe. NHibernate, Entity Framework etc
[AD] Actually, there is another alternative. FusionWare's Managed Provider allows you to create a strongly typed dataset, and you can use this to create a Data Access Layer. The strongly typed dataset is actually a Microsoft DataSet object, not a proprietary object of any sort. To see more, view any of the Nothin' but .NET series at http://www.youtube.com/fusionwareint We also provide similar functionality for Java environments through our Java Data Adapter. [/AD] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: December-21-11 1:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] Is there any ORM's for Universe. NHibernate, Entity Framework etc From : Adrian Halid Has anybody tried or found an ORM for Universe. I am looking at something along the lines of NHibernate or Entity Framework. [AD] Yes, and to my knowledge there is only one. mv.NET includes a component called Solution Objects. You start with your standard dictionary defs. You add details required for strongly typed properties to create Extended definitions. You then define business objects which aggregate files and BASIC rules, and define strongly typed collections and relationships amongst the various classes. Then you generate C# or VB.NET code which you then compile into a DLL. The new modules are as capable as those of NHibernate or EF for validating data, supporting read-only properties, managing cascading updates, etc. You have all of the source and can walk through and change the functionality if required. The code is generated off of templates (like CodeSmith) which you can change to effect global changes to your apps. Direct file read/write is managed for you, or you can choose to have I/O go through your BASIC code (which is more in-line with the way we all prefer to do it). You can give your finalized library to clients or colleagues to represent their view into your platform. Some VARs want to offer their more sophisticated clients a new advanced interface into the app - this is it. Give them a DLL and support it just like any other component of your app (for free or fee). As a service I offer to build and support SDKs like this for VARs. Since you're in Australia, I recommend you contact T-Data Pty Ltd, as they are your regional resellers for mv.NET. As a worldwide Distributor I'll also be happy to answer all questions, and to provide mv.NET and related development services. Before Solution Objects, I created a MV provider for CSLA and ..netTiers, and I wrote my own Visual Studio plugin which generates strongly typed classes from a MV datasource. I was also writing a plugin based on the FOSS SQLite provider, which allows all Database Explorer functionality from VS, so that we could create EF libraries from MV as easily as we could from SQL Server. This was fun and the tools were very useful to me for that kind of work. But given that there is almost no market in this community for such things, and my time for tool development was limited, I decided to direct all of my efforts in this area toward helping to make Solution Objects the kind of solution that we all want in this kind of tool. There really isn't anything else like this in this market, so not only is mv.NET Solution Objects the only option, but it also happens to be a very good one. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ 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] Is there any ORM's for Universe. NHibernate, Entity Framework etc
Hi Tony, Within ADO.NET there is a concept called a Strongly Typed DataSet, which, if your Managed Provider supports the correct interfaces, Microsoft will auto-generate for you from a regular DataSet (which as you note is not strongly typed). The resulting Strongly Typed DataSet is a strongly typed business object, which will reject passing a String to a Date type, for instance, and will reject it at compile-time, not run-time. Wrap it with a simple DAL and you get a very powerful business object that can support a wide variety of clients. The DAL allows you to customize your accessors and expose data directly or through SOAP or RESTful Web Services. In order to support Silverlight, which does not support the System.Data assembly due to browser sandbox restrictions, we auto-generate classes for Silverlight, which can be used in other places, too, but we have found that the Strongly Typed DataSet and DAL are a very powerful combination, and where useable are more than adequate. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: December-21-11 7:43 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Is there any ORM's for Universe. NHibernate, Entity Framework etc Robert, sincere apologies, and thanks for the correction. To avoid misunderstandings, there is a huge difference between a DataSet and a strongly typed business object. They are sometimes used alternatively but there are times when one or the other is absolutely required. If ORM was as simple as returning a dataset we wouldn't have a need for ORM frameworks like NHibernate, CSLA, or commercial offerings like the Telerik OpenAccess ORM. Here is one excellent QA on the topic: http://stackoverflow.com/questions/657327/is-dataset-an-orm [Another obligatory AD tag here I guess] The word proprietary may prompt some discussion: Every framework does what it does in a unique fashion, that's what differentiates it from others. In this regard, all commercial and FOSS frameworks are proprietary. But I did mention that the source which mv.NET generates is completely open, as are the templates that it uses. The generated classes are all partial which means you can modify the generated code. But preferred and better, partial stub classes are also generated which allow developers to hook into functionality at many key points. Generate the base classes as many times as you want and never lose your mods. In the context of the request for an ORM, people actually do want to generate DLLs which are proprietary to their own application. There's nothing wrong with that, that's the goal, and that's exactly what mv.NET helps VARs to generate. I position this as a feature. In addition to Solution Objects and the code generator component, mv.NET also includes the Adapter Objects library which renders collections of items as a strongly-typed DataSet, with Tables, Rows, Columns, etc. UO.NET has similar functionality. All this, yes, and much much more, are included in the same reasonably priced offering. Now, mv.NET does Not have any functionality related to Java. If you need to deploy over *nix or you're creating JARs for existing Java clients, then I highly recommend investigation of FusionWare's offerings as a valuable superset of UOJ. As an independent developer, my position in this game of tool sales is different from others. I sell specific software packages because I like them - I don't like them because I sell them. I won't sell software or services to a company if I know there's a better solution for a specific need. So I recommend that anyone interested in connectivity above and beyond UO should look at all of the options. If it turns out that someone likes the same tools I like, great, the commission earns me a cup of coffee for my time. If not, I hope to benefit by learning why people made other choices. It's all about solutions, not tools - or should be anyway. T From: Robert Houben [AD] Actually, there is another alternative. FusionWare's Managed Provider allows you to create a strongly typed dataset, and you can use this to create a Data Access Layer. The strongly typed dataset is actually a Microsoft DataSet object, not a proprietary object of any sort. To see more, view any of the Nothin' but .NET series at http://www.youtube.com/fusionwareint We also provide similar functionality for Java environments through our Java Data Adapter. [/AD] ___ 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] UniVerse/NT default login account
I was trying to think what we had to deal with on W2008R2 that gave us similar grief, and it just came to me. You must make sure that the users you are working with actually have permissions to the directory where the UV/UD accounts are. They WILL NOT by default when these are in a directory of the root of the system drive on W2008R2! This will result in the error you are seeing, as you will have your default directory in the right place but will not be able to access anything. This includes the VOC. Since you can't access the voc, the assumption for the uv/ud shell is that there *is* no VOC there, and hence the message. Actually log onto your server as that user or use runas with cmd to see if you can access the directories that you believe you need. HTH, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: December-10-11 12:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse/NT default login account If there are no UV.LOGINS entries on the one, then don't create them on the other. Go to the console attached to that server, log in as admin, start the UV shell (not telnet) to confirm that you can get to TCL IF you cannot, then your Universe was not installed properly. If you can, then telnet from that system to get the login prompt in Universe and see if you can login at the Universe login prompt and get to TCL -Original Message- From: Kathleené M Hunter kmhun...@resolutionprovider.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Sat, Dec 10, 2011 7:10 am Subject: Re: [U2] UniVerse/NT default login account I do not believe that I have been clear on this issue. Have a current server windows 2003/ UniVerse 10.0.21 where everything works. All user are directed to the live account when then login. There are no entries in the UV.LOGINS. There is a register entry in UvAccount which contains the account name that is in UV.ACCOUNT. On a New server windows 2008 R2 / UniVerse 10.3.10 set it up the same way and it does not work. So then I added the users to the UV.LOGIN and have they go to the live account but it does not work no matter what user policy is picked ( Home, Any, UV). I have stopped and restated the service after each change. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Friday, December 09, 2011 11:39 AM To: U2 Users List Subject: Re: [U2] UniVerse/NT default login account Hi Kathleen Try any directory. You will run into a problem with UAC in Windows and will have to set it to the lowest security level and then reboot. Then try changing the directory and see if that works. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter Sent: Saturday, 10 December 2011 6:14 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse/NT default login account In UniAdmin I have the option set to ANY UV ACCOUNT, tried it as UV HOME and it still did not work. On the window user account the profile has all the path blank. Is there any way to know where it is getting this path from. The only Admin user can log on because you have to enter a path. Everyone else is going to who knows where. I cannot make every user an Admin user. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, December 07, 2011 4:01 PM To: U2 Users List Subject: Re: [U2] UniVerse/NT default login account Hi Kathleen The uniadmin telnet area is where you resolve this. It is currently pointing at their login directory on windows. You have options to change to login into particular uv.account, or directory. There can be a problem here with Windows UAC that inhibits this from working properly. Are you getting a permissions error when you access the telnet menu in uniadmin. Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kathleené M Hunter Sent: Thursday, 8 December 2011 9:57 AM To: 'U2 Users List' Subject: Re: [U2] UniVerse/NT default login account We use wIntegrate to telnet to the server. The UniVerse logon prompt appears, the user logins in and enter their password. Then the message This directory is not set up for UniVerse... Y/N. No matter what the user answers it logs them off. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, December 07, 2011 12:53 PM To: U2 Users List Subject: Re: [U2] UniVerse/NT default login account Kathleene: When you say ...does not work, what does that mean? With networking all kinds of things are happening
Re: [U2] End of Month date routine
But that would break the rhyme... :o -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: December-05-11 12:26 PM To: U2 Users List Subject: Re: [U2] End of Month date routine Damn February...We need to pull a day from two of the 31 months and give them to February So it will have 30 or 31 days, and almost be like a normal month (all will have 30 or 31 days). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Monday, December 05, 2011 3:21 PM To: U2 Users List Subject: Re: [U2] End of Month date routine Ditto. Sincerely, 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 George Gallen Sent: Monday, December 05, 2011 3:10 PM To: U2 Users List Subject: Re: [U2] End of Month date routine Haven't checked it, but what happens on 01/31 by adding 31, it should take you March, backing up Will give you 02/xx (28 or 29)? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, December 05, 2011 3:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] End of Month date routine On 05/12/11 19:03, Wjhonson wrote: Does someone have a routine that, no matter what day you run it, returns the End of Month Date ? (Assume the end of month date, is the calendar end of month date not some screwy business date) Hmmm... no-one seems to have done my approach ... TODAY = @DATE THIS.MONTH.O = OCONV (TODAY, DMY) ;* strip day off NEXT.MONTH.I = ICONV( THIS.MONTH.O, D) + 31 ;* random day next month NEXT.MONTH.O = OCONV( NEXT.MONTH.I, DMY) ;* strip day off LAST.DAY.I = ICONV( NEXT.MONTH.O, D) - 1 ;* subract one day If you don't have a day in your i/oconv it defaults to 1, so the logic works. Unfortunately you can't combine the first three lines because there's no number you can pick that will guarantee to land you in next month whatever today's date :-( Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] Suggestions for flattening Multivalues... [AD]
[AD]Hi George, Our 2SQL product allows you to map graphically, then automatically creates all the tables for multivalues and subvalues. This youtube video shows how we mapped the table: http://youtu.be/-blc5rE1_CM and this one shows how we used the mapped view to create SQL Server tables (or Oracle, DB2, Progress, MySQL...) http://youtu.be/aI9TcMfCRDg -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:34 AM To: U2 Users Subject: [U2] Suggestions for flattening Multivalues... I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ 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] Extracting XML attributes
It would look like this: /*/Data/Products/Product/@ProductId Note that the document element has a namespace attached so if you assigned the namespace-uri urn_someurl to the prefix pr you could make that: /pr:Feed/Data/Products/Product/@ProductId The '@' specifies an attribute as opposed to an element. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: November-09-11 10:45 AM To: U2 Users List Subject: [U2] Extracting XML attributes Does anyone have an example of an XPath definition to extract an attribute from an XML element? The universe documentation for 10.3 and 11.1 doesn't cover this. I am trying to get the value of ProductId from the following XML example: pr:Feed xmlns:pr=urn:someurl Data Products Product ProductId=ABC ... /Product Product ProductId=123 ... /Product Product ProductId=XYZ ... /Product /Products /Data /pr Using the this extraction file: U2XML_extraction xmlns:USxml=http://www.rocketU2.com/U2-xml; file_extraction start=/Data dictionary=XMLTESTFILE null=EMPTY / field_extraction field=@ID path=Products/Product/@ProductId ,/ /U2XML_extraction I get the following error: LIST XMLDATA EDGENET_XML XML/test.ext Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Open XML data file failed. XMLParser error message: Fatal error at file '/Volume1/MIS/XML/test.ext', line 3, column 69. Message: Expected an attribute name Unable to open XMLDATA:EDGENET_XML,XML/test.ext file. ___ 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] Suggestions for flattening Multivalues...
Whenever the fields are related (an association) the related fields can all make a single table. The only other thing you can do is to explode the single values to match the multivalues, but with different multivalue counts, you wind up with lots of null values. To make it really useful, I'm not aware of any other simple options. Relational databases really work best with normalized data... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: November-09-11 10:57 AM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... I was looking more for ideas on how to setup the database structure to handle the 1:n other than the Sidebar tables joined to the master table. Right now, the scope of the data being moved off is fairly small, I didn't want to involve any other apps The querying app would be custom in itself (most likely php or something) Just this one file we are moving contains about 20 different multivalued fields, and it seemed a little Overkill to have to create 21 tables to contain the data in a form MySQL can handle. I guess that what Happens when you've been raised on multivalue database structure, and are forced to work with one that Does not handle it natively! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Wednesday, November 09, 2011 1:41 PM To: U2 Users List Subject: Re: [U2] Suggestions for flattening Multivalues... It might be worth doing some of this work with an ORM (Object Relation Mapper). Almost all higher level languages have them. Once you get things configured, the messiness of the joins is hidden behind syntactic sugar. Here is a comparison of a lot of them from wikipedia. http://en.wikipedia.org/wiki/Comparison_of_object-relational_mapping_software SQLAlchemy is a market leader for python. If you are a microsoft shop, I understand LINQ us really nice. http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL On Wed, Nov 9, 2011 at 1:34 PM, George Gallen ggal...@wyanokegroup.com wrote: I'm in the process of creating/updating a MySQL database for external applications to analyze some of the data. My initial method of dealing with a multivalued field, is to create it's own table, keyed to the master table (1:n) But this gets a little tedious if you have a bunch of multivalued fields - and creates really bulky SQL statements with all the joins. What other ways are people using to work with 1:n relationships? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SLOW
Just don't get both, or you may go to plaid... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: October-08-11 7:28 AM To: U2 Users List Subject: Re: [U2] SLOW Wouldn't that mean xlr8ing? Sorry, couldn't resist either either :) -Original Message- From: Mecki Foerthmann Sent: Saturday, 8 October 2011 9:27 To: u2-users@listserver.u2ug.org Subject: Re: [U2] SLOW Maybe you should get him to buy FAST? sorry, couldn't resist either Mecki On 07/10/2011 21:21, Drew William Henderson wrote: with apologies to Jeff and Peggy...and, ok, everyone else, too! My boss has noticed today that we've been running SLOW, and isn't happy about it. He wants to know if SLOW is industry standard, and what other U2 shops might be running SLOW. I told him that I didn't know about other U2 shops, but that I know a lot of SQL shops have been running SLOW for years, and seem to be very satisfied. I also let him know that running SLOW on Friday afternoons was almost industry standard, but I'm not sure he's buying it. So, if you're running SLOW in your environment, please let me know; otherwise, we might not be running SLOW on Monday morning. (sorry...couldn't help myself! Have a good weekend, all!) Drew Henderson Director, Enterprise Systems Architecture and Security Morehead State University 301 Howell-McDowell Bldg Morehead, Ky 40351 606/783-2445 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Question about accessing external SQL database [AD]
Two points: First, we have a product that does this for you. You can see it here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxConnectAPI.aspx It uses Universe's built-in HTTP GET/POST capability to call a local web services layer that in turn uses the SQL Server JDBC driver (from Microsoft) to interact with SQL Server. We also talk to Oracle, DB2, DB2/400, MySQL and Progress OpenEdge and could probably work with most JDBC drivers. Our Connect API product uses connection pooling in the web services layer, so it really screams. Secondly, as noted, you can use the SQL Server JDBC driver, if you want to roll-your-own solution. No bridge required... SQL Server connects are relatively quick, so connecting every time you shell out is not that painful unless you do a ton of volume. Some of the other relational databases have very painful connect times. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: October-06-11 1:19 AM To: 'U2 Users List' Subject: Re: [U2] Question about accessing external SQL database The bridge is required because there is no ms sql odbc driver for linux. An alternative would be to use an install of UV on a windows machine to do the actual odbc interaction, it would just use the standard ms odbc driver. This in turn could communicate somehow to your main HP uv install the required data (i.e. csv file, uv.net, soap etc). Or as you say write a web service that runs on a windows machine and can acquire the data. Or write a .net console app for windows that gets the data and uses uniobjects.net to send it back to your UV install. The app can be instantiated via the windows scheduler every x minutes, or maybe using Cygwin or samba from the HP box. ... Rgds Symeon. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jason Lin Sent: 06 October 2011 01:02 To: U2 Users List Subject: [U2] Question about accessing external SQL database Hi, I am exploring a good way to access data on an external SQL database from our Universe (10.2.7) environment running on HP-UX (11.23). I personally prefer to use SOAP API in Universe BASIC to query the database provided the appropriate web service is available. However, the owner of the SQL database prefer not to create web services for this purpose because his dept will need to maintain an additional web server. (Alternatively, we could create our own web service on a Windows 2003 server which can connect to the SQL database server directly). Instead, he offers two options: direct database connection to SQL database (possibly via ODBC) or RPC. I'm not familiar RPC in Universe but after reading documentation on RPC.CONNECT and RPC.CALL functions, it looks like they were designed for Universe to Universe (or Universe to Unidata) type of remote procedure call. Is that correct? So the only other option is to use SQL/ODBC. After reading some archived message from this mailing list, it looks we would need to install a third party ODBC bridge/manager. Several messages recommended Easysoft ODBC-ODBC Bridge but Easysoft lists its price at $2000! Does anyone know if there any other ways of accessing external SQL database from Universe? Thank you. Jason ___ 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.1410 / Virus Database: 1520/3939 - Release Date: 10/05/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] Changing TCL prompt?
It used to be byte 0 of frame 6, in the old Microdata Reality/R83 days... :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of gcan...@coverys.com Sent: October-05-11 11:06 AM To: u2-users@listserver.u2ug.org Subject: [U2] Changing TCL prompt? Hi everyone, Maybe I am going back to my Prime INFORMATION days, but I thought there was a way to set the '' prompt to a free form prompt, or to display the account name you were in as the TCL prompt. I know that can be done at the OS level. Am I dreaming, or is there a (fairly easy) way without having to write code to do it? Thanks Gary P. Canedy Senior Database Analyst P: 617.757.6775 F: 617.428.9803 gcan...@coverys.com (Embedded image moved to file: pic24821.jpg) 101 Arch Street, 4th Floor Boston, MA 02110 www.coverys.com Toll Free: 800.225.6168-- This email and any files transmitted with it are intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you received this email in error, please contact the sender immediately and delete this email from your system. If you are not the named addressee, you should not disseminate, distribute, print, or copy the email, or take any action in reliance on its contents. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] uniobjects question [AD]
[AD]While it may be impossible with UO, FusionWare's Direct Data Access Server supports a mechanism called EXEC TCL in which you can call any program that can be run from TCL, and pass it inputs, like a PROC or a CGI program. If you miss an input, things will get kind of stuck, but if you know your inputs, it works like a dream. We have customers who have been using it quite happily for a number of years. You can access this functionality from Java, OLE DB and Managed .NET (ADO.NET) clients. We give some very simplistic examples here: http://www.fwic.net/Resources/FusionWareIntegrationBlogs/tabid/116/EntryId/55/Other-Ways-to-Access-Our-MultiValue-SALESORDER-Data.aspx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, August 08, 2011 4:39 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uniobjects question Doug, as confirmed by the experience of others, and confirming your own suspicion, we can say with certainty it's not possible to have a functional app where CRT and INPUT are encountered by UO. The only way to use traditional code like that is to skip UO and to use a telnet or SSH client from your language of choice, feeding input to the server, waiting for a response, and parsing the output. That mechanism works fine until something unexpected comes up. Then you need some supporting handlers around your code to recover from the error, avoid keeping the process and license locked, restart a new process, log the event, etc. This is screen scraping, and while there are some fine solutions that do this, they are generally shunned for heavy processing in favor of less volatile solutions. In summary, do you see the two big glowing eyes peering back at you from deep inside of that dark cave? You know better than to go in there, right? :) HTH T From: Doug Chanco I totally agree with your response but what me and the java developer are discussing is if it's even possible (I say nay) I will write a java program to test but I was hoping with the vast sea of knowledge on this group that someone would know, if it was possible or not Yes it should never be done and yes your standards are spot on. This is just a I wonder if this is possible question Dougc ___ 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] Using SSL, with .Net to make a connection to Linux/Unix
Just on the off chance that this helps, here are a few things we've run into in the past with SSL connectivity to Linux: 1. Depending on your Linux version, make sure that the firewall software is not blocking access to the uvtelnetd server. 2. Make sure that you have the certificate that uvtelnetd is using to secure communication in your client software's trust store. 3. Check that uvtelnetd is not doing a reverse DNS lookup - this can cause connections to time out. HTH, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Michael Pflugfelder Sent: Tuesday, August 02, 2011 8:16 AM To: U2 Users List Subject: Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix Hi all, I work with Tom, and I'm more deeply entrenched in this project than he is, so let me try to clarify what Tom is asking for. Here's the facts: * We have a development server running RedHat Linux 5.6 and UniVerse 10.3.3. * The development server has the uvtelnetd service installed and running. * The development server has ssh installed and running. * We can use HostAccess to connect to the server using BOTH ssh and Secure Sockets (SSL) which makes an encrypted telnet session to the uvtelnetd backend. This proves to me that uvtelnetd is running successfully. Here's the task at hand: We are working with our vendor to replace a front-end application written in Delphi with a new front-end application written in .net. The vendor has decided to remove support for SSH and telnet completely. The only connection they will make is to a UniVerse server running uvtelnetd. The way I understand this, it is simply Telnet over SSL. They have this process working with a UniVerse server running on Windows. We are now trying to make it work with our UniVerse server running on linux and it will not connect. Has anyone gone through something like this before? If so, can you help us understand why it will connect to Windows uvtelnetd, and not linux uvtelnetd? Thanks, -Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Tuesday, August 02, 2011 10:05 AM To: U2 Users List Subject: Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix cd `cat /.uvhome`/bin ls -ls uvtelnetd But you only need this one is if you want to use their own secure telnet. Brian Sent from my ASUS Eee Pad Tom Whitmore tewhitm...@ratex.com wrote: Actually, Universe ships a telnet for Window but not *nix. The reason, according to U2 support, is that *nix provides telnet and Windows does not. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Monday, August 01, 2011 6:34 PM To: John Thompson; u2-users@listserver.u2ug.org Subject: Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix John Universe ships with its own secure telnet daemon for *nix running telnet over ssl (uvtelnetd). That's what you need to configure. Brian Sent from my HTC - Reply message - From: John Thompson jthompson...@gmail.com Date: Mon, Aug 1, 2011 21:44 Subject: [U2] Using SSL, with .Net to make a connection to Linux/Unix To: U2 Users List u2-users@listserver.u2ug.org Another thing to think about is that by default most Linux distro's heavily restrict telnet. My first question would be, are your Universe users using telnet or ssh? If they are using ssh only, then I doubt a telnet system is even installed on the Linux machine. If they are using telnet, you might try checking the following files to see if there are any security restrictions set: One place might be /etc/hosts.allow AND /etc/hosts.deny Here is a random blog entry on tcpwrappers (One package that can restrict telnet access) http://linuxhelp.blogspot.com/2005/10/using-tcp-wrappers-to-secure-linu x.html I think also many linux distro's use xinetd (instead of inetd) to run their telnet daemon. So, there may be some restrictions there also. I think the config file is called: xinetd.conf http://www.xinetd.org/sample.shtml From a root prompt... do a: find / -name xinetd.conf Other than that, I've never done a .NET telnet connection, but, I have worked with configuring telnet on Linux. On Sun, Jul 31, 2011 at 8:49 PM, Tom Whitmore tewhitm...@ratex.com wrote: Thank you everyone. I'll let you know how things progress this week. Tom -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, July 30, 2011 11:43 AM To: 'U2 Users List' Subject: Re: [U2] Using SSL, with .Net to make a connection to Linux/Unix Tom I don't know what '.NET TELNET tool' you refer to - but I wrote a customized terminal emulator in .NET for a client that makes a connection Telnet/SSL connection to UniVerse
Re: [U2] Found something interesting.....Bug or No Bug....that is my question?
While I agree that the user typing the commands may find the results unexpected, if you think about how the TCL commands are implemented, it actually makes sense. If I type: ED FOO BAR The ED command has been given an item-id so it attempts to read it. If I type: ED FOO it checks if there's a select-list and uses it, otherwise it either gives you an error message about syntax or prompts you for an item-id, depending on your mv flavor. Now consider: SELECT FILENAME 'itemid' Or SELECT FILENAME @ID = itemid both effectively say hey! I have given you an item id. The TCL SELECT verb, once given an item-id, doesn't bother to check for a select list. Like any TCL verb it just reads the supplied item-ids. Item-ids supplied on the command-line override any active SELECT list. Once you get that, and realize that the two variations above are interpreted by the SELECT command as being equivalent to an item-id being provided on the command line, then the behavior is understood. I didn't say expected. I also didn't say desirable. I said understood! :) It's one of those syntactical things you need to be aware of. Depending on your MV flavor SELECT FILENAME @ID = itemid May not be interpreted as an item-id on the command line. In order to make my commands portable, I always use the form: SELECT FILENAME 'item-id' ... using single quotes for item-id, if I really want to specify an item-id and not scan the whole file or use the active select list. I always use SELECT FILENAME WITH dictid = item-id ... If I want to simply add selection criteria based on the item-id to my SELECT statement, scanning the whole file or using the active select list. The same behavior applies to SSELECT, LIST, SORT and any other related TCL processors. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson Sent: Thursday, July 07, 2011 8:46 AM To: U2 Users List Subject: Re: [U2] Found something interesting.Bug or No Bugthat is my question? Prime information also returned a hit anytime the following syntax was used I'm guessing UV tried to emulate prime whenever possible SELECT filename recordid perhaps a different flavor would yield different results Rich Dianne Ackerman wrote: Yikes, not what I would have expected. Also happens on 10.2.7 -Dianne On 7/7/2011 11:02 AM, George Gallen wrote: UV on Unix - Version 10.0.1 If you do: SELECT FILENAME WITH FIELD = SOMETHING And you want to know if ITEM 1234 is in that list SELECT FILENAME 1234 Will always return a hit (unless it doesn't exist in the FILE) and ignores the active list whereas SELECT FILENAME WITH FIELD = SOMETHING SELECT FIELNAME WITH @ID = 1234 Will return a zero if it's not in the active list Soif you don't specify a WITH qualifier, it will ignore any active list and treat it as if it's a new SELECTion moral of the story, don't get used to omitting the WITH @ID when doing selects otherwise, it will bite you if your working with an active list. George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ 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] Verifying file existence
Or you could simply do it like this: :ED USER.PROGRAMS RH.TEST Top of RH.TEST in USER.PROGRAMS, 9 lines, 230 characters. *--: P 001: FILEPATH=./D_VOC 002: CMD = if [ -e :FILEPATH: ]; then echo yes; else echo no; fi; 003: PCPERFORM CMD CAPTURING OUTPUT 004: PRINT OUTPUT=:OUTPUT 005: IF INDEX(OUTPUT, yes, 1) THEN 006:PRINT FILE EXISTS 007: END ELSE 008:PRINT NO FILE THERE 009: END Bottom. *--: EX Quit RH.TEST in file USER.PROGRAMS unchanged. :RUN USER.PROGRAMS RH.TEST OUTPUT=yes FILE EXISTS -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, June 28, 2011 10:16 AM To: U2 Users List Subject: Re: [U2] Verifying file existence Since your using RHEL, would you know the actual directory or this file? if so, why not use unix? [george@alpha]$ ls /usr/hello ls: /usr/hello: No such file or directory [george@alpha]$ ls /bin/rm /bin/rm Or you could write a short script that uses the -f flag, and returns a YES or NO this way, you don't have to worry about the OS changing the wording of an error. if [ -f $1 ] ; then echo YES else echo NO fi -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Tuesday, June 28, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: [U2] Verifying file existence UD 7.1 RHEL Nahant 4 I am looking for an elegant way to verify a file in a remote directory has been created. Because it is a binary file and could be pretty big, I thought OPENing or OPENSEQing it might not be best. I briefly looked at stat within a PCPERFORM but found the @SYSTEM.RETURN.CODE returned 0 whether the file was there or not. Any other ideas? Cheers, Kebbon Irwin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Verifying file existence
Unidata on Windows version, change one line: CMD = 'if exist ':FILEPATH:' (echo yes) else (echo no)' -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Tuesday, June 28, 2011 11:53 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Verifying file existence Perfect! Thanks guys. Cheers, Kebbon From: robert.hou...@fwic.net To: u2-users@listserver.u2ug.org Date: Tue, 28 Jun 2011 10:17:23 -0700 Subject: Re: [U2] Verifying file existence Or you could simply do it like this: :ED USER.PROGRAMS RH.TEST Top of RH.TEST in USER.PROGRAMS, 9 lines, 230 characters. *--: P 001: FILEPATH=./D_VOC 002: CMD = if [ -e :FILEPATH: ]; then echo yes; else echo no; fi; 003: PCPERFORM CMD CAPTURING OUTPUT 004: PRINT OUTPUT=:OUTPUT 005: IF INDEX(OUTPUT, yes, 1) THEN 006:PRINT FILE EXISTS 007: END ELSE 008:PRINT NO FILE THERE 009: END Bottom. *--: EX Quit RH.TEST in file USER.PROGRAMS unchanged. :RUN USER.PROGRAMS RH.TEST OUTPUT=yes FILE EXISTS -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Tuesday, June 28, 2011 10:16 AM To: U2 Users List Subject: Re: [U2] Verifying file existence Since your using RHEL, would you know the actual directory or this file? if so, why not use unix? [george@alpha]$ ls /usr/hello ls: /usr/hello: No such file or directory [george@alpha]$ ls /bin/rm /bin/rm Or you could write a short script that uses the -f flag, and returns a YES or NO this way, you don't have to worry about the OS changing the wording of an error. if [ -f $1 ] ; then echo YES else echo NO fi -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Kebbon Irwin Sent: Tuesday, June 28, 2011 12:54 PM To: u2-users@listserver.u2ug.org Subject: [U2] Verifying file existence UD 7.1 RHEL Nahant 4 I am looking for an elegant way to verify a file in a remote directory has been created. Because it is a binary file and could be pretty big, I thought OPENing or OPENSEQing it might not be best. I briefly looked at stat within a PCPERFORM but found the @SYSTEM.RETURN.CODE returned 0 whether the file was there or not. Any other ideas? Cheers, Kebbon Irwin ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] Universe : different time zone from AIX
It seems you can do so from this link: http://www.unix.com/aix/77811-setting-connection-time-zone.html YMMV... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marcos Fogaca Sent: Tuesday, May 24, 2011 8:00 AM To: u2-users@listserver.u2ug.org Subject: [U2] Universe : different time zone from AIX Hi, It is possible configure UV to a different time zone for each user, and a different time zone that is running AIX? In Brazil we have 4 time zones, and that UV server is used for all users. Regards, Marcos Fogaça. São Paulo / Brazil ___ 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] 64 bit odbc/oledb drivers
Not that I know of. We've looked at doing it here at FusionWare, and could do it with ours, but it would need enough customers interested, or one willing to fund the development. There are a bunch of places where a 32-bit integer is replaced with 64-bit in the API parameters, and then we have to change all the underlying variables that support those API parameters. It's not a simple recompile, and would require lots of regression testing... All our test harnesses would have to change everywhere that a 32-bit integer got promoted... Oh the humanity! :o -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Monday, May 23, 2011 1:13 PM To: U2 Users List Subject: [U2] 64 bit odbc/oledb drivers Has anyone got ODBC / OLEDB drivers to help link SQL2008 running on 64 bit to Unidata? Jeffrey Lettau ERP Systems Manager polkaudio Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [AD] RE: Accessing Pervasive SQL database from Universe
Richard, We have products that work for both Universe and PI Open. You may wish to look at some of the products here: http://www.fwic.net/Products/MultiValueProducts.aspx Thank you, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard A. Wilson Sent: Friday, April 08, 2011 1:15 PM To: u2-users@listserver.u2ug.org Subject: [U2] Accessing Pervasive SQL database from Universe One of my clients who has been on Prime Information/Universe since the mid 80's is moving to a new package called Timberline (job costing etc) I would like to continue using some of the reports/rules/etc that reside in Universe. Mapping of the data might be much quicker that reworking the rules in a new environment The question is, what would be the best, most efficient way to access that sql data. I have searched the web for a couple of hours and most all related articles are connecting to Universe. thanks, Rich -- Richard A Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 ___ 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] Databasic conversion
It doesn't. You have to convert. If you have F or A correlatives, you may wish to consider something other than Unidata as the target to convert to. Universe supports them just fine. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ed Clark Sent: Friday, April 08, 2011 1:30 PM To: U2 Users List Subject: Re: [U2] Databasic conversion I might be missing something simple and obvious but don't see unidata supporting a-type dict entries: :ECLTYPE P :AE DICT DICTTEST ATEST Top of ATEST in DICT DICTTEST, 10 lines, 16 characters. *--: P 001: A 002: 1 003: A1 004: 005: 006: 007: 008: 009: L 010: 10 Bottom. *--: EX Quit ATEST in file DICT DICTTEST unchanged. : :LIST DICTTEST ATEST Illegal attribute name: ATEST What am I missing? How would you run unidata in case insensitive mode so that ABC=abc? On Apr 7, 2011, at 5:24 PM, Mecki Foerthmann wrote: Ed, Unidata has always supported A-types and still does, so no conversion to I-types is necessary. I am pretty sure S-types also work - it has been a while, though :-) . AFAIK UD can be run in case insensitive mode as well. I always turned case-insensitivity off in D3 because I think it's a real pain in the neck. Sounded great to start with but when you see the first printouts (i.e. invoices) you curse yourself if you didn't turn it off.:-( On 07/04/2011 15:44, Ed Clark wrote: I'm guessing that you are converting from d3 to unidata because you are most familiar with unidata? (and less so with d3). Or is there some other benefit of moving the application to unidata specifically? If you aren't tied to unidata, consider Intersystems Cache. D3 migrations to Cache go pretty quickly. Things to be aware of (from d3 to any other system): 1: D3 is case-insensitive by default. In D3 ANYTHING=anyThing. This can be a deal-breaker. 2: D3 applications (especially older ones) are used to having a lot of control of the machine via D3 commands. On unidata and other systems you need to use OS commands. 3: D3 has a rich spooler. Controlling printing on unidata or universe will be very different. 4: In dictionaries, D3 only supports A-types. Unidata (as far as I know) only supports D and V/I types. So every dict item would need to be converted. This in itself could be a couple of months work depending on how the app uses queries. Cache and universe support both types, so would make for a much easier conversion. On Apr 6, 2011, at 5:14 PM, Symeon Breen wrote: Hi I am looking at a little side project to convert an entire system written in databasic on D3 to run on unidata. The guy i work with says it is a couple of hours work - I am not so sure myself. Anyone done this and know what the 'gotchyas' are ? Cheers Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] SOAP Services and Host Question
Open a command shell on AIX and type: ping wsCatalog If that works (and returns a correct IP address), then use telnet and go to: telnet wsCatalog 80 If it connects it will appear to hang there. Carefully type in the following (you may not see it echo - return means press return): GET /return return You should see a bunch of HTML data (possibly page not found html) or even an error response. If the telnet command returns an error saying host not found or anything like that, then you have a network issue to resolve. If this works, then Unidata has implemented its own equivalent of the hosts file (that would be an incredibly poor design decision). That said, these things are usually due to DNS settings, firewall settings, or bad hosts file settings. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Friday, April 01, 2011 7:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] SOAP Services and Host Question Hi all - I have been working with accessing web services via the SOAP functionality in Unidata. We had been hitting the services via IP addresses instead of host names, and all has worked great. Recently, one of my clients has moved their web services to a load balancing cluster, so we now need to hit the web service using a DNS name, and it is failing. I turned on Protocol Logging and get this info: 04/01/2011 10:45:26 [ 16973890 9568286 ] HTTP_START: timeout=75000 04/01/2011 10:45:26 [ 16973890 9568286 ] HTTP_CONNECT 04/01/2011 10:45:26 [ 16973890 9568286 ] new host 10515dd0:wsCatalog:80 allocated (proxy:no) 04/01/2011 10:45:26 [ 16973890 9568286 ] host wsCatalog:80 not found in host List I thought this had to do with the /etc/hosts file (this is an AIX system), so we added an entry resolving the host name, but we still get the same error. Anyone know what Host List it's referring to if its not /etc/hosts? Thanks in advance, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SOAP Services and Host Question
The 400 bad request is a response from the server that wsCatalog resolved to, so you are connecting to something. It may not accept regular GET requests, if it's only supposed to serve up web services. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Friday, April 01, 2011 8:47 AM To: U2 Users List Subject: Re: [U2] SOAP Services and Host Question Thx for the input. I did the GET / as described and I get a 400 bad request so it looks like it's a network issue. Thanks, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Friday, April 01, 2011 8:28 AM To: U2 Users List Subject: Re: [U2] SOAP Services and Host Question Open a command shell on AIX and type: ping wsCatalog If that works (and returns a correct IP address), then use telnet and go to: telnet wsCatalog 80 If it connects it will appear to hang there. Carefully type in the following (you may not see it echo - return means press return): GET /return return You should see a bunch of HTML data (possibly page not found html) or even an error response. If the telnet command returns an error saying host not found or anything like that, then you have a network issue to resolve. If this works, then Unidata has implemented its own equivalent of the hosts file (that would be an incredibly poor design decision). That said, these things are usually due to DNS settings, firewall settings, or bad hosts file settings. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Friday, April 01, 2011 7:57 AM To: u2-users@listserver.u2ug.org Subject: [U2] SOAP Services and Host Question Hi all - I have been working with accessing web services via the SOAP functionality in Unidata. We had been hitting the services via IP addresses instead of host names, and all has worked great. Recently, one of my clients has moved their web services to a load balancing cluster, so we now need to hit the web service using a DNS name, and it is failing. I turned on Protocol Logging and get this info: 04/01/2011 10:45:26 [ 16973890 9568286 ] HTTP_START: timeout=75000 04/01/2011 10:45:26 [ 16973890 9568286 ] HTTP_CONNECT 04/01/2011 10:45:26 [ 16973890 9568286 ] new host 10515dd0:wsCatalog:80 allocated (proxy:no) 04/01/2011 10:45:26 [ 16973890 9568286 ] host wsCatalog:80 not found in host List I thought this had to do with the /etc/hosts file (this is an AIX system), so we added an entry resolving the host name, but we still get the same error. Anyone know what Host List it's referring to if its not /etc/hosts? Thanks in advance, Steve Long Spyderweb Technical Services, Inc. (360) 687-8797 Washington (503) 406-8797 Oregon (866) 354-5913 Fax ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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] U2UG Elections 2010 - Request For Comment - The I-Beam
Oh yeah! Right! But not commonly considered when thinking of second person pronouns. It's more of a person-irrelevant pronoun (it can be used to include ones-self - there it is, again!) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brett Callacher Sent: Tuesday, March 22, 2011 4:35 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam Actually Robert, I think English does have this word. You just used it - the rather unfashionable 'one'. Brett Robert Houben robert.hou...@fwic.net wrote in message news:9c300472e764f645b1bab4571ac8d12601d461579...@bc-comm.fusionware.net... Good point, Bill, I think one sometimes uses you when one means someone other than themselves, without intending to pin the reader with the crime being mentioned. The English language does not differentiate plural, general you from singular, specific you (unless you're from the deep south, in which case you have the unique y'all, which oddly enough I've always heard used as the singular, specific form.) For instance, I might have written: I think you sometimes use you when you mean someone other than yourself... :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, March 18, 2011 5:14 PM To: U2 Users List Subject: Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam I learned about the I-Beam of Interpersonal Communications at a ToastMasters meeting. The idea is to stop using the word you altogether. Easier said than done. The beauty of the I-Beam is that it removes blaming others. Thus... I wish that Rocket would see that 123 and then did ABC along the lines of XYZ... I am in favor of... I am not in favor of... are decent I-Beam constructs. On the other hand... YOU are a dirty rotten bungling oaf and it is all YOUR fault. This of course not I-Beam. It uses the inflamatory blame word (YOU). The word YOU is toxic. --Bill ___ 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 This message contains information that may be privileged or confidential and is the property of GPM Development Ltd. It is intended only for the person to whom it is addressed. If you are not the intended recipient ,you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. This e-mail was sent to you by GPM Development Ltd. We are incorporated under the laws of England and Wales (company no. 2292156 and VAT registration no. 523 5622 63). Our registered office is 6th Floor, AMP House, Croydon, Surrey CR0 2LX. ___ 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] U2UG Elections 2010 - Request For Comment - The I-Beam
Good point, Bill, I think one sometimes uses you when one means someone other than themselves, without intending to pin the reader with the crime being mentioned. The English language does not differentiate plural, general you from singular, specific you (unless you're from the deep south, in which case you have the unique y'all, which oddly enough I've always heard used as the singular, specific form.) For instance, I might have written: I think you sometimes use you when you mean someone other than yourself... :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Friday, March 18, 2011 5:14 PM To: U2 Users List Subject: Re: [U2] U2UG Elections 2010 - Request For Comment - The I-Beam I learned about the I-Beam of Interpersonal Communications at a ToastMasters meeting. The idea is to stop using the word you altogether. Easier said than done. The beauty of the I-Beam is that it removes blaming others. Thus... I wish that Rocket would see that 123 and then did ABC along the lines of XYZ... I am in favor of... I am not in favor of... are decent I-Beam constructs. On the other hand... YOU are a dirty rotten bungling oaf and it is all YOUR fault. This of course not I-Beam. It uses the inflamatory blame word (YOU). The word YOU is toxic. --Bill ___ 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] [SPAM?] PROC language documentation
That's the Reality New PROC variant. Check with Northgate for their Reality user guides. They have online versions. http://www.northgate-reality.com/products.php?pageId=77 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Tuesday, March 15, 2011 8:57 AM To: 'U2 Users List' Subject: [SPAM?][U2] PROC language documentation Group, I know I'm dredging up long ago memories but the company I'm working for now still has many PROCs running. I haven't used PROC for 20+ years now and I've forgotten most of what I did know. Never did like that cryptic language. That being said can someone on this list point me to some documentation on the PQN version? Thanks, Gordon Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. ___ 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] PROC language documentation
Hopefully, Unidata's implementation of the Reality New PROC variant is fairly accurate. I would still go with the Reality guides. Your mileage may vary... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Tuesday, March 15, 2011 9:03 AM To: 'U2 Users List' Subject: Re: [U2] PROC language documentation P.S. We are a Unidata shop. If that makes any difference. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Glorfield, Gordon Sent: Tuesday, March 15, 2011 11:57 AM To: 'U2 Users List' Subject: [U2] PROC language documentation Group, I know I'm dredging up long ago memories but the company I'm working for now still has many PROCs running. I haven't used PROC for 20+ years now and I've forgotten most of what I did know. Never did like that cryptic language. That being said can someone on this list point me to some documentation on the PQN version? Thanks, Gordon Gordon J Glorfield | Software Application Developer | Vertis Communications 250 W. Pratt Street, Suite 1800 | Baltimore, MD, 21201 T 410-361-8664 | M 443-280-7093 gglorfi...@vertisinc.com | http://www.vertisinc.com Vertis Communications is a results-driven marketing communications company that delivers inventive advertising, direct marketing and interactive solutions to prominent brands across North America. Our deep industry knowledge and extensive range of offerings-including integrated data solutions, digital program management systems, creative services, world-class print and mail production, logistics, out-of-home and business process outsourcing-are used to deliver superior program performance that drives bottom line results for our clients. With 100 strategically positioned locations and more than 5,000 dedicated professionals, we deliver impeccable quality and fast turn-around to any market. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Is this worth rewriting?
That *is* cool! I still remember helping my dad with his tube tester. He'd repair radios and TVs for his friends from work. In return he got their rejects for parts. We never had to buy a TV... There's something about the sound from an old tube radio that you can't beat! Sometimes when I think about what's actually going on, physically, in a computer I'm amazed they work as well as they do! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen E. Elwood Sent: Wednesday, March 02, 2011 10:05 PM To: 'U2 Users List' Subject: Re: [U2] Is this worth rewriting? Ok, just to be clear, there is a difference between an interpreted instruction and a hard wired machine code instruction. An actual BRANCH ON NOTEQUAL operand ANALOG *circuit* must be etched in silicon at the flip-flop level before it's a machine code instruction. So like, not impossible. But here's the cool point. Digital devices, are implemented with capacitors, transistors, resistors. Analog devices. I dunno, just makes me laugh every time I think about the fact that at the lowest level there is really no such thing as digital because electricity is analog lol Speaking of analog (how's that for a segue?), all guitar pros still use tube amps. I make tube amps! It's so different to work with 500 volt tubes and transformers than programming. [shameless brag] Here's an upcoming starlet using one of the Hiwatt DR504 clone amps I built by hand for her playing with Earl Slick (David Bowie's guitarist after Stevie Ray got himself fired) http://www.youtube.com/watch?v=wTx1Pi1_o4c [/shameless brag] -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, March 02, 2011 9:10 PM To: U2 Users List Subject: Re: [U2] Is this worth rewriting? Yes, in the real instruction that gets send down those long multi-stage pipe lines in our multi-core CPUs :) They take the same amount of clock cycles to compare if a 32bit/64 bit value is equal, or not equal. When values are compared it merely sets one of the many flags in the CPU. This binary flag is used to determine if it was equal or not, the only difference in the machine code is whether you perform an action if the flag is true or perform an action if the flag is false. This is as true in RISC processors as it is in CISC. But yes, this sort of optimisation is rarely needed. In fact, if you were to ever write the code in C/C++ the compiler would automatically optimise the machine code far better than most mere mortals could :) For some reason, you mentioning your teacher made me think of The Story of Mel: http://www.catb.org/jargon/html/story-of-mel.html snip ___ 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] U2 soap server on startup
Look at this source-forge project: http://sourceforge.net/project/shownotes.php?release_id=60527 It allows you to wrap any java server provided the server does not try to get interactive (the usual caveats). Also, be aware that this will then run in the context of the machine user, so you don't have mapped drives (unless you set them up) and you may have permissions issues (integrated security to SQL Server won't work). HTH, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Thursday, February 24, 2011 6:08 AM To: U2 Users List Subject: Re: [U2] U2 soap server on startup Sorry, Windows I saw the commands in the manual for runsoapserver and stopsoapserver. This does allow for starting and stopping without using the tools. The link does help explain where things are operating from, thanks. I guess the question is, can I make the runsoapserver a service? Or would it be starting the instance of javaw as a service? Or am I stuck having to login and manually start the soapserver? If I have to just run it manually to insure it is up, then it's not a big issue, there are other things I need to do this with. Thanks for the feedback and info. Every little bit helps. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, February 24, 2011 2:41 AM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] U2 soap server on startup See the Webservices.pdf in the U2 Documentation. Specifically Deploying Web Services...If in Windows create your own scheduled task or UNIX - a crontab job. Also, from the archivesthis may help if you like to know what's going on behind the scenes (this pre-dates the above chapter being published in that PDF guide): http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg24130.html -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lettau, Jeff Sent: Thursday, 24 February 2011 8:29 AM To: u2-users@listserver.u2ug.org Subject: [U2] U2 soap server on startup I just noticed a potentially bad thing. The soap service will only run if you run it manually after logging into the server. If I log off of the server the soap service stops running. I'm guessing the problem is that it is not actually running as a service, but I don't see how to make it run as a service. Does anyone have any suggestions on how to enable a soap server to run on startup? Jeffrey Lettau ERP Systems Manager polkaudio ** 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 http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [SPAM?]Re: silly company names
Then what about biff? Named after the writer's dog. Anyone remember Seattle Lab? It was named for the owner's black lab. My first computer company that I worked for was called Toga Computer Services. Named after the owners, Tony and Gary. We actually got calls from people who thought we did dry cleaning... Later on, they changed the name to Datasense... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Saturday, February 19, 2011 3:11 PM To: u2-users@listserver.u2ug.org Subject: [SPAM?]Re: [U2] silly company names On 19/02/11 02:24, Tony Gravagno wrote: From Charlie Noah: Totally OT, and I'm just musing here - Rocket, Raining Data then TigerLogic. Does anyone besides me see a trend here? Tony Gravagno wrote: Uh, I don't get it. How are those related? What trend? From: Charlie Noah Silly company names. Oh, well, Raining Data was an amazingly stupid name for a database company. As to the others, is anything really silly anymore considering the names we see every day? Yahoo!, Google, Bing, Twitter, Facebook, Digg, Drupal, Joomla, Mambo, Samba, (or more obscure) Vyatta, Wibiya, Stupeflix, Granicus, Zimbra, Xen (or how about Linux distros) Mandriva (formerly Mandrake), Ubuntu, Debian, Sabayon, (or just Linux release names) Etch, Lenny, Squeeze, Wheezy, Gutsy, Zoot, Shrike... I stopped thinking anything was silly in IT after grep, awk, and sed. The trend started decades ago when names like Johnson Software Co were all taken. This is just the world we live in. To follow Jeff's post ... Samba - SMB (Simple Message Block) server Debian - Debbie and Ian's linux Debian release names, Etch, Lenny, Squeeze, Wheezy, Sarge, Sid - all come from Toy Story (one of the Debian guys worked on Toy Story, you can see his name in the credits). Then what about biff? Named after the writer's dog. Typical for a lot of unix utilities :-) Cheers, Wol ___ 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] Pick Dinosaurs
The first machine I worked on was a Microdata 1600 with 4 50 MB Winchester washtub drives. It ran 16 users on 64K of core memory. That was back in 1981. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Monday, February 07, 2011 8:30 AM To: U2 Users List Subject: Re: [U2] Pick Dinosaurs I started in 1988, as a technical support representative for a subsidiary of the Ultimate Corp. We had a computer room with several big old machines with reel tapesBack in the days of GFEs and all of those good things. Wow, those were the days. I also started in 1988 on an Ultimate system. In fact, I just came across a RECALL manual from that system. Copyright 07 Feb 1983 out of Hanover, NJ. Anybody need one? Charles Shaffer Senior Analyst NTN-Bower Corporation ___ 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] What do you do with CallHTTP? [AD]
We use CallHTTP with some of our customers to push/pull data between Universe BASIC and SQL Server, Oracle, etc..., through a connection-pooled HTTP(s) server. We provide an API of subroutines to manage the interface. It's part of our mvLynx Connect API product. We have customers doing a very high volume of transactions through this interface and we find it extremely stable. It has been stress tested by real-world Universe applications running on both AIX and Linux. HTH, -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, January 28, 2011 10:51 AM To: 'U2 Users List' Subject: [U2] What do you do with CallHTTP? What uses have you found for CallHTTP for in your applications? Are you 'eating' someone else's data with it - like doing lookups against a web service call? Or are you using it to 'serve' data to others? Rocket says you can do this, but I can't see how it would work offhand and would like to know the scenario. How complex have you found it and how stable? Thanks for your thoughts! ___ 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] Refresh UV user permissions without restarting UV Service ?
It's one thing if you change the permissions for a resource that the user is trying to access, but when you change the rights that a user is assigned, any session that is already active for that user already has all its access tokens and won't reflect your change. You will have to log that session off and back on. For instance, if I am logged on, and someone adds another group to the list that my user belongs to, my already active session does not *know* that I now belong to that group. It checks that once, when I log on. I'm pretty sure there's no way to bypass that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Friday, January 28, 2011 11:21 AM To: U2 Users List Subject: Re: [U2] Refresh UV user permissions without restarting UV Service ? Arnold: I'm not sure about UV but in UD, when I change windows permissions, they immediately work through UD. This is because UD uses Windows permissions and doesn't have their own security (well, limited anyway). I didn't realize UV was different. Bill Arnold Bosch said the following on 1/28/2011 4:25 AM: Hi everyone. Is it possible to force Universe to refresh it's internal permissions list without restarting the UV service? I have a user that I added to the Windows Administrators group after the user was created on Windows and in Universe. It does not appear that UV picks up that this user is now allowed administrative privileges - and I really don't want to restart the UV service at this point in time on the server to get this going. For info: UV 10.2.1 on Windows Server 2003. Any suggestions would be most welcome. Kind regards, Arnold Bosch IT Administrator Taeuber Corssen SWA (Pty) Ltd Tel +264 (0)61 293 2106 Cell +264 (0)81 124 8625 ___ 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] What do you do with CallHTTP?
Somewhere embedded in those 20 lines are the two special instructions: RMM (read my mind) DWIM (do what I meant) :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Friday, January 28, 2011 3:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] What do you do with CallHTTP? Which twenty? -Original Message- From: Symeon Breen syme...@gmail.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Jan 28, 2011 2:18 pm Subject: Re: [U2] What do you do with CallHTTP? CallHTTP is used to call someone else's http service like a webservice or an actual web page, we use it to communicate with web services, rss feeds, and also html documents that we analyse. In order to serve data to others you would not use callhttp - you should use the sockets interface - or preferably write a webservice in say .net and use uniobjects.net - it really is 20 lines of code. From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: 28 January 2011 18:50 To: 'U2 Users List' Subject: [U2] What do you do with CallHTTP? What uses have you found for CallHTTP for in your applications? Are you 'eating' someone else's data with it - like doing lookups against a web service call? Or are you using it to 'serve' data to others? Rocket says you can do this, but I can't see how it would work offhand and would like to know the scenario. How complex have you found it and how stable? Thanks for your thoughts! ___ 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.1204 / Virus Database: 1435/3408 - Release Date: 01/28/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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Data in Dict
In Java, you have the same problem. The UID is only unique for the machine, so the common trick is to take the IP address of the local machine and use it as a prefix (should be unique within your network anyways). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, January 26, 2011 6:55 AM To: 'U2 Users List' Subject: Re: [U2] Data in Dict I'm curious what your logic is to generate the Unique ID -- can you share that without giving away a trade secret?? It's too bad it's not a database function call in UniData/UniVerse - we can do that in D3/Pick - it's a derivation of system Date/Time with AlphaSequencing if more than 1 hit in a given clock cycle - but it would only be unique on the 'machine' since another system could generate the same ID. So I am interested in the idea of generating a TRULY unique ID. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Steve Romanow Sent: Tuesday, January 25, 2011 7:24 PM To: U2 Users List Subject: Re: [U2] Data in Dict In some cases I am becoming a fan of UUIDs for db table keys. A UUID type one uses the mac address of the host along with the current time as salt so you don't have to worry about key collisions between accounts (I.e. TEST and PROD). Generating the next key is fast because there is no readu, update, write. They should hash pretty well since they are long and random. On 1/25/11, Bill Haskett wphask...@advantos.net wrote: Jeff: I have a single file named (CTRLNOS) with the item ID equal to the file name using the sequence#. Field#1 is the last seq# used while field# 2 is the maximum seq# allowed before the seq# is reset to 0. Each item has documentation in it to describe what it's for and any unusual pieces of data allowed (e.g. maximum length of data allowed in a text box). The get-next-sequence code looks like: READ{U} SEQREC FROM SEQFILE, FILENAME ELSE SEQREC = 0:@AM:9:@AM:@AM:@AM SEQREC := ** Item created on :TIMEDATE():. END SEQ = SEQREC1 + 0 MAX.SEQ = SEQREC2 + 0 OSW = 0 LOOP SEQ += 1 IF SEQ MAX.SEQ THEN IF NOT(OSW) THEN OSW = 1 ; SEQ = 1 END READV{U} DoesExist FROM FILENAME.FV, SEQ, 0 ELSE DoesExist = 0 UNTIL NOT(DoesExist) DO REPEAT If a file goes bad then I know which item to fiddle with. Just a thought. Bill -- -- Jeff Schasny said the following on 1/25/2011 8:37 AM: My preference is to have a data file specifically for next key records with the item id being the filename and field 1 being the next available key. As far as restoring it should it become corrupted a fairly simple Uvbasic program which is fed a list of filenames, selects each file BY.DSND @ID, readnext, add 1 to the first key, write that as the next key for the file, next filename should be able to restore your next key file in a couple minutes if not less. George Gallen wrote: The one down side I can think of to not keeping 'next' values in the DICT and in a separate file, is if you have to restore the file, you will also have to restore the NEXT-FILE as well. It's not one neat package. But I have to admit, when I was setting up a MySQL structure and needed to implement a 'next' value, I went with a separate file and each row had two values, key and value, where the key was the filename and the value being the next value, and used this one file for all my 'next' placeholders, instead of writing it to the DICT, I used the filename as the key. Although, keeping all your nexts in one basket could be a problem if that file ever was corrupted, it would be difficult to reset them all to the correct values. Other than that, seems a bit of overhead to have a separate next file for each file you want to keep one on to avoid losing all your keys with one file issue. What other methods are people using to track next ID? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Monday, January 24, 2011 7:55 PM To: U2 Users List Subject: Re: [U2] Data in Dict Kate: It seems to me that this is very tidy! :-) Bill --- - Kate Stanton said the following on 1/24/2011 1:27 PM: Hi David, The reason we use dictionaries for data entry, reports, queries and forms is so we can use the same dictionary item for all activities, thus using the dictionary as designed with a little more. So, if part ID is changed at a site to be 6 numbers, then changing the dict item in a file once means the same change applies to all other activities. We think this is very tidy, and the unused portion of dictionaries have been used like this for a long, long
Re: [U2] CoRelating Two Arrays
Nothing is resetting Where.We.Left.Off to 1. The code that you are providing below sets it to 1 at the beginning and NEVER CHANGES IT! The only place you reference it in your code is the for Receiver.Count... loop, and there it is only used to set the initial value of Receiver.Count. Its value is never set inside the two for loops. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Wednesday, January 26, 2011 9:26 AM To: U2 Users List Subject: [U2] CoRelating Two Arrays When I try do something like the following, inside the loop, UV keeps resetting Where.We.Left.Off to 1. To solve this, I am expecting to invoke brute force. I am surprised that UV-Basic behaves this way. An explanation would be appreciated. --Bill Where.We.Left.Off = 1 for Blanket.PO.Count = 1 to Total.Nbr.PO.Releases read R.POD from F.POD... PO.Qty = R.POD, Blanket.PO.Count for Receiver.Count = Where.We.Left.Off to Total.Nbr.Receivers read R.Rcvr from F.Rcvr... Received.Qty = R.RcvrReceiver.Count Received.Running.Total += Received.Qty begin case case Received.Running.Total PO.Line.Item.Qty ; crt PO.Qty : ' ' : Received.Qty Receeived.Running.Total = 0 exit end case next Receiver.Count next Blanket.PO.Count ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64
It is possible that this is a permissions problem. Try the following: - Disable UAC and rerun the app. - Disable UAC and run the app as Administrator. If that still doesn't work, then I'm out of rabbits, or need a closer look at the hat. If either one works, then you have hit a UAC problem. Note that a normal user cannot write to the Program Files directory (plus other places) under Windows 7/2008 server environment. Lots of older apps required you to do this, and will break when ported, unless you run with elevated privileges. You may wish to check if UPS has an updated version of their app for Windows 7/x64. I have a number of things I do on my Win7/x64 system that require me to run as Administrator with UAC turned off. It simply won't work otherwise. Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, January 26, 2011 9:50 AM To: U2 Users List Subject: [U2] Unidata 6.1 connecting to UPS Worldship on Win7/64 I have a customer setting up a Win7/64 box for UPS Worldship. Previously they had a XP/32 box in that same place running an earlier version of the WS solution. They've installed the Unidata ODBC driver (which is 32-bit) and have configured it, and have tested it successfully using Excel. (By tested successfully they've proven they can read information from Unidata into Excel via ODBC.) In the UPS Worldship application, when they try to setup the ODBC connection to read from Unidata, WS shows the configured connector for Unidata in the ODBC data sources. That's positive. When they select that source and enter user ID and password, the little Windows blue circle (waiting indicator) hangs out for a half second, and then ... it disappears as if nothing has happened. At this point we would expect it to go to the screen where the specifics of the ODBC connection can be configured, but it never goes there. We've checked a couple of user IDs and passwords, so there's very little chance that the wrong user ID and/or password has been entered. As the Unidata connector seems to work under Excel, I'm thinking the problem is a bug in the Worldship application, but I figured that maybe someone here might have seen this and have some ideas other than call UPS? -Kevin http://www.PrecisOnline.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] [AD] New product mvLynx 2SQL is FusionWare's upgrade path for mv2SQL
[AD] New product mvLynx 2SQL is our upgrade path for mv2SQL. http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynx2SQL.aspx?s=lrd=20110118c=1 Robert Houben CTO FusionWare Integration Corp. p: 604-777-4254 x158 m:604-219-8394 f: 604-608-5544 http://www.fwic.net LinkedIn http://www.linkedin.com/company/fusionware-integration-corp.?trk=fc_badge Twitter http://www.twitter.com/fusionwareint FaceBookhttp://www.facebook.com/#!/pages/New-Westminster-BC/FusionWare-Integration-Corp/115116258510923 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migration
[AD] If I don't put this here, someone might complain... Our tools for going MV to SQL do exactly that. We have a mapping wizard that analyzes the dictionaries and the data. Depending on how good the dictionaries are, we get close to 80% right first try. Then you get to test and tweak, all in a graphical environment, until you have it 100% right. The tool lets you even decide what %age of bad data you'll ignore. It's not uncommon to have a handful of bad records in a big file. Set the tolerance to 1% and if you have a dictionary that says attribute 2 is a date, provided less than 1 in 100 items have something that's not a valid date (you can set the range of values that work for your system, too) we'll call it a date and use that dictionary for the field name. We also have tools that let you identify bad records so you can actually find and fix them. The map is ultimately stored in the file's dictionary. I think we've gotten off-topic, again, though. The original question was about going the other way. Going SQL to MV, Item-id selection is likely to be the biggest hurdle. You do not need to set a primary key in SQL Server. Even if you do, you may have a unique index in SQL which would make a better candidate for the item-id. A tool to migrate can make a best first guess, but it will sometimes get it wrong. At some point, someone familiar with the application, with an architectural mindset, is going to have to look at the output and probably tweak the results. I just don't see a substitute for this. On the other hand, if you just get the data over, someone can convert it locally to whatever format they ultimately want. Our tools typically exist to help get the data to where the application programmers are, and they take it from there. Then the application guys figure out what to do with it from there. If you have to repeat this from time to time, you use a staging approach; you pass the raw converted data to a temporary file, then the application people process this file and convert it to their ultimate format. So, you get to choose between doing it all on the first pass, or getting the data over and letting someone at the target end (in this case, MV) complete the transformation. You are choosing between E - TL and ET - L. Where T happens is often driven by where the programming muscle in the project resides. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Marc Harbeson Sent: Tuesday, December 28, 2010 8:13 AM To: 'U2 Users List' Subject: Re: [U2] Migration LOL In my mind - there would be a operator map tool here - I don't think the tool could be self aware enough to figure out every possible combination of everything. It could certainly guess 80% correctly and be corrected on the remaining 20% on suggesting maps. I see this with data going from MV to SQL - sometimes the dictionaries are just wrong... it's easier to adjust using the map... (in particular if they're not your dictionaries to adjust) I would imagine an adjustment could be made to the maps to increase MV performance - just like you would in SQL when porting MV data there. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Friday, December 24, 2010 1:41 AM To: U2 Users List Subject: Re: [U2] Migration Oh, one more point. What if your SQL environment had NOT defined a primary key for APPOINTMENTS, but had multiple indexes, one of which happened to have CUSTOMERNO, APPTDATE, APPTTIME and APPTTYPE. How would you figure out what to use as the item-id of the PICK file? What if you had a SQL table that actually did not have a set of fields that guaranteed a unique value? Then you have NOTHING to create an item-id from! I have to stop this, it will consume me! :o But the list goes on. Oh the humanity! ___ 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] Migration
Should have clarified when you sort *multiple* fields that are indexed. I still haven't heard anyone tell me that either UV or UD now support more than one indexed field. Let me know if this has changed... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Sunday, December 26, 2010 4:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration On 24/12/10 15:50, Robert Houben wrote: SQL will beat MV every time when you sort fields that are indexed. Huh? Ime (UniVerse), that's wrong. Indexes are b-trees, which you can walk, and the contents of the index are sorted. afaik you would have been right about PI, but that's long dead. Dunno about UniData, but UV is a lot of sites where MV will equal SQL ... :-) For direct reads, MV seems to have a slight advantage. Inserts and updates that affect indexed fields are slower in SQL (inserts are painfully slow if you fail to size your SQL table well, but try inserting millions of records into a file with a modulo of 1...) Been there, done that. But that's why most places use dynamic files nowadays. :-) Cheers, Wol ___ 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] Migration
I should also clarify that we have a lot of customers we support on mvBase, mvEnterprise, D3 and lots of other platforms, and yes, we do have PI Open customers... I recognize that the topic here is U2, but even there, we have customers who use our products running on Universe 5 (don't ask, we just do...) So, I find that I often have to assume a lowest common denominator when building a reusable solution. I may not always be aware of the current state of a particular platform. I'd love to be corrected if my understanding of limitations is out-of-date! Last I knew, if you wanted to sort an MV file by more than one field, regardless of how many indexes you had, you got to pick one of them, and you would settle for brute force for the others. This was true, last I knew, of EVERY MV platform I knew of that had indexes. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Sunday, December 26, 2010 4:42 PM To: U2 Users List Subject: Re: [U2] Migration Should have clarified when you sort *multiple* fields that are indexed. I still haven't heard anyone tell me that either UV or UD now support more than one indexed field. Let me know if this has changed... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Sunday, December 26, 2010 4:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration On 24/12/10 15:50, Robert Houben wrote: SQL will beat MV every time when you sort fields that are indexed. Huh? Ime (UniVerse), that's wrong. Indexes are b-trees, which you can walk, and the contents of the index are sorted. afaik you would have been right about PI, but that's long dead. Dunno about UniData, but UV is a lot of sites where MV will equal SQL ... :-) For direct reads, MV seems to have a slight advantage. Inserts and updates that affect indexed fields are slower in SQL (inserts are painfully slow if you fail to size your SQL table well, but try inserting millions of records into a file with a modulo of 1...) Been there, done that. But that's why most places use dynamic files nowadays. :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migration
I was answering while uploading family videos to YouTube! :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Sunday, December 26, 2010 7:02 PM To: U2 Users List Subject: Re: [U2] Migration I've been lurking, following this thread, and I guess I have to stick my 2 cents in. I've worked with MV for 33 years, from Reality to jBASE, and one of the best features ever added was secondary indexes. Choices depend on the platform, the iron involved, size and structure of the database and how often you need a particular select, but this is an approach I have used with success. I like to use an index to cull the file down as much as possible, then use that select to drive the next index select, etc. (if the platform allows it and it's appropriate). Then, when the final list is culled down to the records I need, I use another index select to put the list in the sequence I want. The key can be constructed of multiple fields to get just the desired sequence. No brute force required. One advantage of multi-field keys is small nodes, which means more efficient index updating and selects. Now, you can't go crazy and index everything in sight, but you can design indexes to give you the maximum bang for your buck. At least, this approach has worked well for me. Like it, hate it, throw rocks at it, it's all OK by me. BTW, it's Sunday after Christmas - what are we doing thinking about work today? Merry Christmas and Happy New Year to all, Charlie Noah Charles W. Noah Associates cwn...@comcast.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-26-2010 6:50 PM, Robert Houben wrote: I should also clarify that we have a lot of customers we support on mvBase, mvEnterprise, D3 and lots of other platforms, and yes, we do have PI Open customers... I recognize that the topic here is U2, but even there, we have customers who use our products running on Universe 5 (don't ask, we just do...) So, I find that I often have to assume a lowest common denominator when building a reusable solution. I may not always be aware of the current state of a particular platform. I'd love to be corrected if my understanding of limitations is out-of-date! Last I knew, if you wanted to sort an MV file by more than one field, regardless of how many indexes you had, you got to pick one of them, and you would settle for brute force for the others. This was true, last I knew, of EVERY MV platform I knew of that had indexes. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Sunday, December 26, 2010 4:42 PM To: U2 Users List Subject: Re: [U2] Migration Should have clarified when you sort *multiple* fields that are indexed. I still haven't heard anyone tell me that either UV or UD now support more than one indexed field. Let me know if this has changed... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Sunday, December 26, 2010 4:33 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration On 24/12/10 15:50, Robert Houben wrote: SQL will beat MV every time when you sort fields that are indexed. Huh? Ime (UniVerse), that's wrong. Indexes are b-trees, which you can walk, and the contents of the index are sorted. afaik you would have been right about PI, but that's long dead. Dunno about UniData, but UV is a lot of sites where MV will equal SQL ... :-) For direct reads, MV seems to have a slight advantage. Inserts and updates that affect indexed fields are slower in SQL (inserts are painfully slow if you fail to size your SQL table well, but try inserting millions of records into a file with a modulo of 1...) Been there, done that. But that's why most places use dynamic files nowadays. :-) Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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
Re: [U2] Migration
A read on a primary key is about as efficient as an MV hashed read. Each has their trade-offs. Get the modulo wrong and your MV read can be nasty. You can get a SQL table in trouble, too. You really can't beat getting all your data in one disk head movement, but we were talking about just creating a single PICK file for each table, to keep the migration simple. There are some excellent articles on how indexes work in SQL Server that you may wish to read. Your understanding below is partially correct in places, but indexes do NOT copy all the data. Just the indexed fields. Note that a PICK index has to copy all the item-ids and all the indexed fields, but you don't get anything pre-sorted, just hashed. Note that the primary key sorts the actual table. All subsequent indexes are actually sorted copies of the indexed columns with keys or some other references to the real records. If your query only uses fields in the index, you won't ever read the real table's data. SQL will beat MV every time when you sort fields that are indexed. For direct reads, MV seems to have a slight advantage. Inserts and updates that affect indexed fields are slower in SQL (inserts are painfully slow if you fail to size your SQL table well, but try inserting millions of records into a file with a modulo of 1...) Here's one short article with some diagrams that show what goes on in clustered and non-clustered indexes: http://technet.microsoft.com/en-us/library/aa964133(SQL.90).aspx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, December 24, 2010 5:56 AM To: U2 Users List Subject: Re: [U2] Migration I was under the impression that when a relational table is being indexed the DBMS creates and maintains a sorted copy of the original table for every indexed field. That means for clustered indices tables sorted by every conceivable combination need to be maintained, having a huge impact on space requirements and performance. So when you are looking for a row or rows that match the indexed key, in a RDBMS an algorithm can be used to locate the row(s) instead of reading in the whole table and comparing every single row. So you could for instance go to the middle of the (already pre-sorted) table (if you have 100 Million rows in your table you read row 50) and check if the key is greater equal or smaller than the value you are looking for and carry on that way until you have a match. That way you eliminate half the number of rows you need to compare with every read. Of course they probably use much more sophisticated algorithms these days. But regardless what algorithm they may use it has to be slower than the hashing algorithm used by mv as long as you have well sized files using sensible item ids. To save space some RDBMS may also have implemented reduced datasets so they may just hold the indexed keys in the row instead of duplicating the whole data; in which case the primary index somehow needs to be used to retrieve the data in the row afterwards. So as you can see even in a RDBMS there is calculation going on when indices are used. I would actually go so far to say that relational databases don't use real indices at all. They just duplicate the dataset sorted in different ways. But that of course is a matter of how you define what a real index is supposed to be. Well, and when you want to sort then you just read the already sorted table into memory instead of the original - so it can be a lot faster than reading a list of item ids from an index file and then reading the items one by one from the data file using the hashing algorithm as it is done in the mv-world. That is also the reason why mv can only use one index at a time and why we don't need joins. On 24/12/2010 04:45, fft2...@aol.com wrote: In a message dated 12/23/2010 4:28:38 PM Pacific Standard Time, antli...@youngman.org.uk writes: SQL uses indexes. MV uses cross references to item-ids (MV sometimes supports indexes, but they don't always work as well as in the relational world.) I don't know as that is true ... or are you using the word index to mean something completely different to me? I'll agree the implementation of indices can be buggy, but surely that's true of relational engines too? I'm not quite sure I'm confortable with the idea (expressed in the prior-prior posting of which I here quote and enquote the reponse) that MV uses cross-references to item-ids. To me a hash table, isn't the same thing as a cross-reference which sounds a lot like a secondary key. Hashing calculates an exact jump point at which a group of related records are kept. They are related by having the same hash value. But the hash value itself isn't looked up, it's a calculation. I wonder if you can setup a first normal form table in such a way, that it maintains a constant sorted order ?
Re: [U2] Migration (OT)
AM To: U2 Users List Subject: Re: [U2] Migration (OT) So I was more or less right then. ;-) Afaik mv-indexing uses a b-tree structure for better performance. Therefore your statement that you don't get anything pre-sorted might not be quite right. And which one of your statements shall we believe when you claim that a read on a primary key is about as efficient as a MV hashed read and for direct reads, MV seems to have a slight advantage? It's either one or the other. And talking about inserting millions of records into a file with a modulo of 1 isn't really helpful now, or is it? I use relational for data warehousing, analytics and reporting myself. Relational can be fast but once you start using joins... Nevertheless, in a well designed mv database you will need a lot less indexing than in a similar relational one. And as you admit yourself, when it comes to writing (inserting) mv can't be beat. So for operational data, mv would be my choice of db anytime. And no, we are not talking about just creating a relational model using a mv-database. That defies the purpose and is what this tread imho was about. After all first normal form is just a sub-set of mv, while in sql-land it's the only one you have! MV only excels when you convert dependant sub-tables into mv fields. And that's where any attempts to fully automate this process has to fail. On 24/12/2010 15:50, Robert Houben wrote: A read on a primary key is about as efficient as an MV hashed read. Each has their trade-offs. Get the modulo wrong and your MV read can be nasty. You can get a SQL table in trouble, too. You really can't beat getting all your data in one disk head movement, but we were talking about just creating a single PICK file for each table, to keep the migration simple. There are some excellent articles on how indexes work in SQL Server that you may wish to read. Your understanding below is partially correct in places, but indexes do NOT copy all the data. Just the indexed fields. Note that a PICK index has to copy all the item-ids and all the indexed fields, but you don't get anything pre-sorted, just hashed. Note that the primary key sorts the actual table. All subsequent indexes are actually sorted copies of the indexed columns with keys or some other references to the real records. If your query only uses fields in the index, you won't ever read the real table's data. SQL will beat MV every time when you sort fields that are indexed. For direct reads, MV seems to have a slight advantage. Inserts and updates that affect indexed fields are slower in SQL (inserts are painfully slow if you fail to size your SQL table well, but try inserting millions of records into a file with a modulo of 1...) Here's one short article with some diagrams that show what goes on in clustered and non-clustered indexes: http://technet.microsoft.com/en-us/library/aa964133(SQL.90).aspx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Friday, December 24, 2010 5:56 AM To: U2 Users List Subject: Re: [U2] Migration I was under the impression that when a relational table is being indexed the DBMS creates and maintains a sorted copy of the original table for every indexed field. That means for clustered indices tables sorted by every conceivable combination need to be maintained, having a huge impact on space requirements and performance. So when you are looking for a row or rows that match the indexed key, in a RDBMS an algorithm can be used to locate the row(s) instead of reading in the whole table and comparing every single row. So you could for instance go to the middle of the (already pre-sorted) table (if you have 100 Million rows in your table you read row 50) and check if the key is greater equal or smaller than the value you are looking for and carry on that way until you have a match. That way you eliminate half the number of rows you need to compare with every read. Of course they probably use much more sophisticated algorithms these days. But regardless what algorithm they may use it has to be slower than the hashing algorithm used by mv as long as you have well sized files using sensible item ids. To save space some RDBMS may also have implemented reduced datasets so they may just hold the indexed keys in the row instead of duplicating the whole data; in which case the primary index somehow needs to be used to retrieve the data in the row afterwards. So as you can see even in a RDBMS there is calculation going on when indices are used. I would actually go so far to say that relational databases don't use real indices at all. They just duplicate the dataset sorted in different ways. But that of course is a matter of how you define what a real index is supposed to be. Well, and when you want to sort then you just read the already
Re: [U2] Migration [AD]
I've been watching this thread with some interest. Because I'm going to reference our product, I'm putting th [AD] marker on this. One of our best-selling products assists our customers in rapid migration/data warehousing of Multivalued and Subvalued data to either SQL Server, Oracle, DB2, Progress, MySQL and other relational databases. We actually have a whole suite of tools to assist our customers in solving these issues. With our most popular product, you start by identifying (and mapping) the data that you want to retrieve. We provide graphical mapping tools that make this relatively painless. We also provide tools for data cleansing and analysis, so you can ensure that you have mapped the data right, can fix the worst problems in your data, and can skip-and-log when you hit errors, rather than crash-and-burn when you hit these situations. In some cases the mapping step can be skipped, and we even have a way to let you use dictionaries to get your output data. Once you have sourced the output data, we will then optionally create the required tables, columns and primary keys in the Relational database, to create the tables that are required to support the equivalent structure to your MultiValued data. Note that going from MultiValue to Relational is the easy direction, but even so, it is fraught with some nasty issues, the worst ones being that PICK is very forgiving of garbage in situations. SQL is not. If you decide that the field is supposed to have a date, then TOMORROW, BEFORE 1PM is not going to work! (this was a real scenario for one of our customers.) In order to go the other direction, there are some inescapable questions that have to be answered: MV can only support 2 levels of nesting. If you have 3 or more 1-to-many relationships, you have to decide at some point to keep a set of keys (item-ids) in a multivalued or subvalued cross-reference and use another file. Deciding where and when to do this becomes the tricky thing. SQL uses indexes. MV uses cross references to item-ids (MV sometimes supports indexes, but they don't always work as well as in the relational world.) There are other issues, but that's a good starting point. If you really want to explore the concept there is no substitute for playing with it, and you'll discover there are more issues lurking there... Enjoy! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, December 23, 2010 3:09 PM To: U2 Users List Subject: Re: [U2] Migration There is the problem of atomicity... one of the important hallmarks of good database design. MV files of records with attribute marks can be directly ported to SQL tables. The problem is what to do about data with value marks and subvalue marks. These blobs can be crammed into SQL cells but then the data is no longer atomic. --Bill Actually, I'd disagree with you. Applications are all about the METAdata, which a relational database throws away. ALL relational APPS contain an awful lot of logic to manage stuff that SHOULD be managed in the database - except an RDBMS has no way of managing that information so it can't be managed in an RDBMS. I talked about adjectives out there in the real world. Adjectives describe nouns. What's the database equivalent of a noun? That's right, in an RDBMS there is NO SUCH EQUIVALENT. Can you give those of use who are more dense, a concrete, specific example of what you're talking about? I've seen several messages like this, and still don't comprehend it. Do not first-normal form databases have column headings? Aren't those headings the names of the attributes (nouns if you will)? Or the table names the names of the nouns. I'm still not seeing why you can't simply create an MV file for each Table, a record for each row, and an attibute for each column. Where's the problem? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migration
I left the discussion alone until some people started talking about both directions, although we do help people go both ways. I actually had a customer at one time who had migrated off a mainframe. They had so much data that when you looked at the disk-head movement, average access time, and volume of data that they had to process, they were able to prove mathematically that they could not, with the technology that was then available (and I think still not) get away with a FNF relational setup. They had to use a MV approach, and decided on Unidata. I recall having to do indexed SELECT statements against 30 GB files and doing intersect merges to combine indexes because LIST/SORT/SELECT/SSELECT would use the first indexed field you referenced, and then ignore all other indexes, brute forcing the rest of the selection criteria. With a 30 GB file, that was never an option. And yes, if you throw enough joins at SQL Server it gives up optimizing, but lately, you have to really make it complex before it gives up. I haven't tried it recently, so maybe Unidata handles indexes better these days. Maybe Universe does. But the last time I tried doing anything significant using indexes on large U2 files, it got tricky. My point is that an application using SQL Server, Oracle or some other relational engine, often uses indexes in a way that may not port easily to MV. They also work differently. One designs Relational data differently than one designs MV data. So maybe instead of saying of indexes on MV that they don't work as well, I should have said they solve different problems in different ways. I agree with your assessment of the Relational approach having issues with reality. They intentionally abstract out reality, and the programmer gets to reconstitute it. One of the things that I've noticed is that when the data that describes an object is in multiple tables, as with a FNF relational setup, as soon as you want to work with it in an application, you effectively have to create internal structures to work with the whole item anyways. But now you're making a programmer do it, using variables, instead of allowing the database to do it for you. On the flip side, doing data mining is much easier when the data is fully normalized and duplicates are eliminated... Having worked on both sides of the house, there are decidedly times when each one excels, and tasks for which each model is best. I will, in the same day, program PICK/BASIC, Java, C#, C++ and JavaScript and probably at least one other language. The power of MV for rapidly working with data is amazing. The fact that I can create a file and start to use it (it's my problem to make sure I use it consistently) without having to jump through hurdles to configure everything I need in it is both inspiring and a bit scary. Two programmers can decide to grab the same next field and start using it and if they don't happen to compare notes, they'll get away with it, with devastating results when they deploy their changes. This doesn't happen in the relational world, but then, the hurdles you go through to work with data are considerably more daunting. In the end, where databases are concerned, there is no substitute for good architecture, design and planning. And while you're at it, design for flexibility: You'll almost certainly get some things *wrong* the first time around! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Thursday, December 23, 2010 4:28 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration On 24/12/10 00:07, Robert Houben wrote: I've been watching this thread with some interest. Because I'm going to reference our product, I'm putting th [AD] marker on this. One of our best-selling products assists our customers in rapid migration/data warehousing of Multivalued and Subvalued data to either SQL Server, Oracle, DB2, Progress, MySQL and other relational databases. We actually have a whole suite of tools to assist our customers in solving these issues. Except that's not the issue that the OP posed :-) He wanted to migrate AWAY from SQL server etc :-) In order to go the other direction, there are some inescapable questions that have to be answered: MV can only support 2 levels of nesting. If you have 3 or more 1-to-many relationships, you have to decide at some point to keep a set of keys (item-ids) in a multivalued or subvalued cross-reference and use another file. Deciding where and when to do this becomes the tricky thing. This, imho, is where the relational guys have a problem with reality. Yes I know that decision is HARD. So the relational guys abstract it away. The cost is that relational databases are not deterministic. It becomes a case of yes there is definitely a solution, and I will definitely find it, but it may take longer than
Re: [U2] Migration
I may have been unclear in my earlier post, so I'll clarify. Consider a CUSTOMER file and an APPOINTMENTS file. The item-id of the CUSTOMER file is the customer number. The item-id of the APPOINTMENTS file is CUSTOMERNO*APPTDATE*APPTTIME*APPTTYPE. When you have a parent/child relationship in multiple files in MV, except in those cases where the key to a child file is the item-id of the parent file with a sequential ordinal, the common way to indicate a parent-child relationship involving more than one file in MV is to embed, in the parent item a multivalued set of either all the entire item-ids of the child table, or the portion that needs to be concatenated to the parent's item-id. That is what I call a cross reference field. If you don't have this, you are faced with trying to scan the whole APPOINTMENTS file to find all item-ids that start with your CUSTOMERNO value. What you might actually have in the CUSTOMER file is a set of 3 correlated multivalued attributes that have APPTDATE, APPTTIME, and APPTTYPE values for all the APPOINTMENTS items that pertain to the CUSTOMER item. In a SQL environment, the primary key to the child table would consist of at least two fields, one or more of which would be the full primary key of the parent table. In SQL Server a true primary key forces the file to actually be sorted by those key fields (it forces a clustered index). You can also have secondary indexes that are also pre-sorted by their indexed columns. They are effectively complete copies of the indexed fields and a copy of the primary key so it can directly read the data once you've found the index entries that match your query. In our example above, you'd have CUSTOMERNO as a primary key to the CUSTOMER table, and 4 separate fields (no * delimiter) that make up the primary key of the APPOINTMENTS table. I'm not exactly sure how you'd accomplish the same thing in a MultiValued environment if you just copied all the tables as flat MV files. You'd lose the ability to access the child records without doing a complete table scan. Unless of course you analyzed the data, and created some special linking files, but the objective seems to be to avoid human intervention. You might actually be able to do something with an MV index on a dictionary record that references just the portion of the child file's item-id that makes up the parent file's item-id (in our example, the CUSTOMERNO). But you'd have to add that, at the very least, and that would mean creating a dictionary record as part of what you create. And that's NOT how you'd do it in SQL Server, for instance. You might have defined foreign key references in the child table, but that's not a given, so how you'd even know there was a parent-child relationship in place is not clear. In some cases the naming of the keys in the files can give you a hint, (that's how MS Access always tried to figure it out and it worked a surprising amount of the time), but you are not guaranteed that this will work in all cases. I've seen plenty of cases where this did not work. So, you could, in theory get all the data over, but you'd still be faced with making it usable in a truly performant way. Here's another gotcha to consider: In many SQL tables, including our above example, the primary key will consist of several fields. What do you do in PICK where you have one, and only one, item-id attribute? Do you concatenate and assume fixed length, or do you concatenate, choose a separator character and pray it's not contained in the data? What if the concatenation of these fields exceeds the length limit of an MV item-id? I know of real world applications where this is the case... There are workarounds, but they are NOT automatic! You will have to choose some rules to work around issues. You will hit exceptions that you'll actually have to think about, and you may have to redesign some structures, to make them practical. In short, there are things that you would do in a relational environment that don't really have an exact analog that works in the MV world, and vice versa. There, that's a bit more encompassing. I'm out of time, but I hope this has been helpful. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, December 23, 2010 8:46 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Migration In a message dated 12/23/2010 4:28:38 PM Pacific Standard Time, antli...@youngman.org.uk writes: SQL uses indexes. MV uses cross references to item-ids (MV sometimes supports indexes, but they don't always work as well as in the relational world.) I don't know as that is true ... or are you using the word index to mean something completely different to me? I'll agree the implementation of indices can be buggy, but surely that's true of relational engines too? I'm not quite sure I'm
Re: [U2] Migration
Oh, one more point. What if your SQL environment had NOT defined a primary key for APPOINTMENTS, but had multiple indexes, one of which happened to have CUSTOMERNO, APPTDATE, APPTTIME and APPTTYPE. How would you figure out what to use as the item-id of the PICK file? What if you had a SQL table that actually did not have a set of fields that guaranteed a unique value? Then you have NOTHING to create an item-id from! I have to stop this, it will consume me! :o But the list goes on. Oh the humanity! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Thursday, December 23, 2010 10:36 PM To: U2 Users List Subject: Re: [U2] Migration I may have been unclear in my earlier post, so I'll clarify. Consider a CUSTOMER file and an APPOINTMENTS file. The item-id of the CUSTOMER file is the customer number. The item-id of the APPOINTMENTS file is CUSTOMERNO*APPTDATE*APPTTIME*APPTTYPE. When you have a parent/child relationship in multiple files in MV, except in those cases where the key to a child file is the item-id of the parent file with a sequential ordinal, the common way to indicate a parent-child relationship involving more than one file in MV is to embed, in the parent item a multivalued set of either all the entire item-ids of the child table, or the portion that needs to be concatenated to the parent's item-id. That is what I call a cross reference field. If you don't have this, you are faced with trying to scan the whole APPOINTMENTS file to find all item-ids that start with your CUSTOMERNO value. What you might actually have in the CUSTOMER file is a set of 3 correlated multivalued attributes that have APPTDATE, APPTTIME, and APPTTYPE values for all the APPOINTMENTS items that pertain to the CUSTOMER item. In a SQL environment, the primary key to the child table would consist of at least two fields, one or more of which would be the full primary key of the parent table. In SQL Server a true primary key forces the file to actually be sorted by those key fields (it forces a clustered index). You can also have secondary indexes that are also pre-sorted by their indexed columns. They are effectively complete copies of the indexed fields and a copy of the primary key so it can directly read the data once you've found the index entries that match your query. In our example above, you'd have CUSTOMERNO as a primary key to the CUSTOMER table, and 4 separate fields (no * delimiter) that make up the primary key of the APPOINTMENTS table. I'm not exactly sure how you'd accomplish the same thing in a MultiValued environment if you just copied all the tables as flat MV files. You'd lose the ability to access the child records without doing a complete table scan. Unless of course you analyzed the data, and created some special linking files, but the objective seems to be to avoid human intervention. You might actually be able to do something with an MV index on a dictionary record that references just the portion of the child file's item-id that makes up the parent file's item-id (in our example, the CUSTOMERNO). But you'd have to add that, at the very least, and that would mean creating a dictionary record as part of what you create. And that's NOT how you'd do it in SQL Server, for instance. You might have defined foreign key references in the child table, but that's not a given, so how you'd even know there was a parent-child relationship in place is not clear. In some cases the naming of the keys in the files can give you a hint, (that's how MS Access always tried to figure it out and it worked a surprising amount of the time), but you are not guaranteed that this will work in all cases. I've seen plenty of cases where this did not work. So, you could, in theory get all the data over, but you'd still be faced with making it usable in a truly performant way. Here's another gotcha to consider: In many SQL tables, including our above example, the primary key will consist of several fields. What do you do in PICK where you have one, and only one, item-id attribute? Do you concatenate and assume fixed length, or do you concatenate, choose a separator character and pray it's not contained in the data? What if the concatenation of these fields exceeds the length limit of an MV item-id? I know of real world applications where this is the case... There are workarounds, but they are NOT automatic! You will have to choose some rules to work around issues. You will hit exceptions that you'll actually have to think about, and you may have to redesign some structures, to make them practical. In short, there are things that you would do in a relational environment that don't really have an exact analog that works in the MV world, and vice versa. There, that's a bit more encompassing. I'm out of time, but I hope this has been helpful
Re: [U2] Upgrading and Migrating from Unix to Windows
Hi Richard, We have both a Relational Data Access Server and a Direct Data Access Server that are written in fairly generic PICK/BASIC but with specific subroutines to do platform-specific stuff. We run on pretty well all MV platforms including Unidata, Universe, PI/Open and even some very old Universe versions, both on Windows and *nix (Unidata on Dec Vax, even.) We do this with a single code base for all platforms. Until you decide that you want to know a specific process number, work with pipes and O/S files and other things like that, the BASIC code is not only interoperable, but if the version is even remotely close, you don't normally have to even compile. That said, I'd compile just to be safe. Check your code for any place where you run a command shell program or call an O/S specific function. Also check for any pattern in a string that contains forward slashes. Your peripherals are a different matter altogether... Good luck! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Conway Sent: Tuesday, November 09, 2010 3:15 PM To: 'U2 Users List' Subject: Re: [U2] Upgrading and Migrating from Unix to Windows Thanks for that, I hadn't actually downloaded it at that point and I didn't see it elsewhere on their web site. My main concern is how the existing data and programs written in Unibasic actually handle the move from a Unix environment to a Windows one. I know there is at least one call to a Unix function that will fail, but I'm not sure about generally how interoperable the two environments are. Has anyone tried anything like this? If so, what are the most likely/obvious pitfalls? Richard - Original Message - From: Glorfield, Gordon gglorfi...@vertisinc.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Monday Monday 08 November 2010 19:23:21 Subject: [U2] Upgrading and Migrating from Unix to Windows Along with being limited to two users, the UniData and UniVerse Personal Editions also have an eight-process limit and a limitation of modulo 10007 assigned to a file. Also, the following add-ons do not function: Connection Pooling, EDA, NFA, RFS, UV/Net. Right off of Rocket's U2 downloads page. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Monday, November 08, 2010 2:08 PM To: Richard Conway; U2 Users List Subject: Re: [U2] Upgrading and Migrating from Unix to Windows I think the size limit is something like a modulo of 10009 or there abouts, if memory serves me right. It's been a long time. You should be able to get the limitations from Rocket. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Conway Sent: Monday, November 08, 2010 10:30 AM To: U2 Users List Subject: Re: [U2] Upgrading and Migrating from Unix to Windows What are the file size restrictions with PE? Is there a comprehensive list of the restrictions present in PE anywhere that I can read/download? Richard - Original Message - From: Bob Woodward bob_woodw...@k2sports.com To: Richard Conway rich...@rlcnet.co.uk, U2 Users List u2-users@listserver.u2ug.org Sent: Monday Monday 08 November 2010 18:20:24 Subject: [U2] Upgrading and Migrating from Unix to Windows I think, at the very least, you're probably going to have an issue with the PE version limiting your file sizes. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Conway Sent: Monday, November 08, 2010 5:00 AM To: u2-users@listserver.u2ug.org Subject: [U2] Upgrading and Migrating from Unix to Windows I am about to try to upgrade an old Unidata server running Unidata 3.x on SGI Irix, to another machine running Windows Server 2003. I am going to set up the Windows box with Unidata 7.2.7 PE initially. Has anyone tried such a drastic move? What is the best upgrade path to try? Unidata 3.x on Irix to Unidata 7 on Linux, then on to Unidata 7 on Windows? Or would a single jump upgrade actually work, with the help of vocupgrade and PATHSUB? Richard ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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
Re: [U2] UniVerse DOS Command - Batch File Error
If your batch file is named myfile.bat, then try executing the DOS command cmd.exe /c myfile.bat. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 12:35 PM To: 'U2 Users List' Subject: [U2] UniVerse DOS Command - Batch File Error I have a batch file on a server running UniVerse. This file can be executed from Windows Explorer with no problems. If I attempt to run the same batch file using the UniVerse DOS command, the batch file will not process. The DOS command line is displayed, there is a slight delay (2 sec or so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ 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] EMailing from Universe
You'll have to install the SMTP service on your system and configure it to connect to your mail server. That server may have to be configured to allow you to allow mail from your SMTP service on your system. SMTP service is an optional component. I'm not sure that it's available on XP Home but it's definitely there on XP Pro. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Sunday, September 12, 2010 9:27 AM To: U2 Users List Subject: Re: [U2] EMailing from Universe Hi Bill, I'm running XP Home, and I don't have that directory. Is it an XP Pro thing, or do I just need to create the directory? Is there any software I need to run? I would like to be able to send email from Jbase, and if this is a Windows function, it shouldn't matter where the file comes from, right? Of course, I could be all wet here. Thanks, Charlie Noah The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 09-12-2010 10:27 AM, Bill Haskett wrote: Mark: This is extremely simple in Windows. Add a basic email header to the statement you wish to send, e.g... x-sender: myser...@mydomain.com x-receiver: targetn...@targetdomain.com From: billingd...@mydomain.com To: targetn...@targetdomain.com Subject: Your monthly billing for September 2010 ...then copy the item to the C:\Inetpub\mailroot\Pickup folder. Windows SMTP service will automatically send it out. As Jeff says, however, you'll have to configure the SMTP server to properly forward to an authorized email server. If you need attachments, which most billings don't, then Jeff's method, although not as simple, will work fine. Also, if you want html you'll have to build a program to do that. Normally I just create an html template then, at runtime, substitute data into this template and write it to the aforementioned SMTP folder. HTH, Bill Mark Warner said the following on 9/11/2010 8:31 PM: We're started a project where a client wants to email statements to their customers. Has anyone done this with success, and if so, can you point me in a direction? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sequential Files Question
Use echo . to get just a carriage return into the file. Note that you don't have permissions to write the file, therefore any attempt to create it from BASIC will also fail. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Allen Elwood RR Sent: Thursday, September 09, 2010 10:08 AM To: U2 Users List Subject: Re: [U2] Sequential Files Question How does this create a file? I've always code similar to the method David Green showed, since that works on all pick flavors instead of having to change my code every time I move to a different system. C:\Users\AllenElwoodhelp echo Displays messages, or turns command-echoing on or off. ECHO [ON | OFF] ECHO [message] Type ECHO without parameters to display the current echo setting. C:\echoc:\buddy.txt Access is denied. On 9/9/2010 9:47 AM, Rex Gozar wrote: OPENSEQ PATH TO SEQFILE THEN WEOFSEQ SEQFILE ON ERROR ABORTM WEOFSEQ FAILED! END END ELSE * instead of CREATE statement (on Windows) PCPERFORM echo:PATH OPENSEQ PATH TO SEQFILE ELSE ABORTM OPENSEQ FAILED! END END ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users