(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
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users
