Hi Tony,
I agree with you totally. Web services are the way to go. The web service that you've developed for us using VS and MV.NET absolutely screams!!! We blew the service that my as400 counterparts developed out of the water. Thanks a ton for helping us look so good to the corporate folks. I'm really impressed with mv.net!!! I don't really have any control over what happens on the as400 side and I know their resources are limited at this point. I was hoping for a way of connecting to the 400 and issuing sql commands directly from universe. Any thoughts on that? The only other thing I can think of is to ftp flat files to them and let them take care of loading the data. The sql idea would save people alot of work. Thanks, Scott ----- Original Message ----- From: "Tony G" <[email protected]> To: [email protected] Sent: Wednesday, July 1, 2009 3:04:09 PM GMT -06:00 US/Canada Central Subject: Re: [U2] Updating AS400 Data from Universe > Anyone out there have any experience updating data on an > AS400 directly from a Universe basic program running on unix. > If so, I'd sure like to hear what steps were involved. > Thanks much, > Scott Greetings, my friend: I personally don't think it's a good idea in any X/Y data transfer for X to be aware of the details of Y. It restricts the Y people from making changes and forces the X people to be aware of such details. I prefer to use familiar interfaces to transfer data to a middle-tier proxy which then brokers transmission and protocol-specific details. In other words, use web services or other standards that don't require a new research effort for every project. Don't hardcode into every platform Y that you encounter. Transaction turnaround time can be slower but long-term maintenance is vastly simplified. If you absolutely need the fastest transactions possible then you'll need to get closer to the metal. I happen to know that you already have the tools onsite to do exactly what you want functionally, just not in exactly the way you suggest. Let's see what our colleagues here have to say and I'll be happy to talk with you about options. HTH T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
