[U2] DIR-type files
I'm sure others have come across this before, but with directory type files, you can specify relative paths as part of the record name to access files stored elsewhere: For example, say you have an account in /account There is a VOC entry for: <1> DIR <2> BP ... At ECL, if you type ED BP ../../etc/host You get the /etc/host file in ED! Obviously, that example required access to ECL and was quite contrived, but it does not take much imagination to think of scenarios where not being able to guarantee the file/directory data is being read from/writing to can cause security headaches. I didn't find anything when I searched the manuals about a Unidata setting and we cannot deal with all the scenarios we have programmatically in Unibasic... Aside from usual UNIX permissions, etc, how have people dealt with this? Kind Regards, Dan M ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Updating AS400 Data from Universe
Thanks much Craig, I'll give that a look. - Original Message - From: "Craig Bennett" To: "U2 Users List" Sent: Wednesday, July 1, 2009 6:42:46 PM GMT -06:00 US/Canada Central Subject: Re: [U2] Updating AS400 Data from Universe Hi Scott, have you considered an ODBC link and using BCI (the UV calling interface to ODBC)? A quick google suggests that ODBC interfaces are available for AS400. regards, Craig ___ 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] Updating AS400 Data from Universe
Hi Scott, have you considered an ODBC link and using BCI (the UV calling interface to ODBC)? A quick google suggests that ODBC interfaces are available for AS400. regards, Craig ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Updating AS400 Data from Universe
(I swear folks, I don't pay for testomonials from happy clients. LOL) Scott - your check is in the mail. Err, I mean... the following information may be overkill for this specific situation but some of the info may help others who need to exchange data bi-directionally between MV and non-MV environments. The easiest answer to your question is not to go direct from Universe per-se, but to create an OS-level macro that does what you want, and then call that from Universe. So if you can write a Windows BAT file or a Unix shell script that does what you want, you're golden - jus pass that routine some dynamic input. Sometimes you can't go direct. To use your existing tools, AS400 has a .NET interface just like your Universe system via mv.NET. We've written interfaces from MV to SQL Server, MySQL, and Oracle using the principle described: MV <> MiddleTier <> Other That MiddleTier has variations but it essentially does this: 1) Accept inbound transaction from source. 2) Reformat data to suit application-specific requirements. 3) Pass data to target. Step 2 might be as simple as this: Server target = new Server(TargetID); target.Update(InboundData); And the Update method for MV server class might include this: account.CallProg("FROM.AS400",ref InboundData.ToString()); While for a relational server, the Update method just calls a stored procedure. Note that I'm calling a BASIC program and an AS400 stored proc. This is "declarative" where you don't put the details in your code, you tell the server to do it and the server people on each side figure out what to do with the data. I try to avoid file opening and direct reference to attributes and field names in a middle tier. This is more secure anyway. Similarly, someone could provide you with SQL queries but a stored procedure is better. You don't need to change your code if they change the way they're manipulating their relational files. That's not the case if you hardcode queries into BASIC and try to update a relational environment direct from U2. The point here is that you don't need to know anything about AS400 or any other environment in order to update a remote system. Again, this isn't a lightning fast exchange mechanism, but if you can wait a second or two (hardly unreasonable) it's not bad at all. If you do need to go direct from Universe into another environment, I still recommend you make use of stored procedures rather than hardcoding relational queries into BASIC. And now that I've just given away our development secrets, feel free to do this on your own - or contact me for assistance if required. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula R&D sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! > From: Scott > 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. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Updating AS400 Data from Universe
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" <1tlx6h...@sneakemail.com> To: u2-users@listserver.u2ug.org 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 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] 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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Updating AS400 Data from Universe
Hi all, 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] How do you do EDI?
Whoa! Can't believe I made THAT error! "Mark Eastwood" Sent by: u2-users-boun...@listserver.u2ug.org 06/20/2009 02:44 PM Please respond to U2 Users List To "U2 Users List" cc Subject Re: [U2] How do you do EDI? BTW, I think the web site is www.softshare.com (not softsearch). -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Debster Sent: Saturday, June 20, 2009 8:33 AM To: U2 Users List Subject: Re: [U2] How do you do EDI? BTW.at www.Softsearch.com they have a free download of their EDI Notepad that is a great little desktop tool for anyone doing EDI. It enables you to view any EDI and will alert you to any structural errors, including improper codes utilized in segments (i.e. 128, 235) It also has a complete X12 doc behind it allowing you to view all possible qualifiers ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- This communication (including any attachments) is intended only for use by the addressee(s) named herein and may contain legally privileged or confidential information. If you are not the intended recipient or an authorized representative of the intended recipient on this communication, you are hereby notified that any dissemination or distribution of this communication (or attachments) is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and permanently delete the communication and any attachments from your system. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users