Thanks for the replies.
I didn't really think I would be able to do the join, but was hoping.
I will start researching how to setup a linked server.
Mike
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Gad Miron
Sent: Wednesday, November 13, 2019 11:05 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: [EXTERNAL] Re: linked server and appserver4rpg
My 2 cents
Joining (external) files residing on a Linked server IS possible in SQL Server but it is slow as D*B indicated
calling a program on the i from the SQL Server may be done by using EXEC opcode like Exec ('CALL SHAKMLCL2.BO2AKM') AT AS400_PROD_ODBC
( AS400_PROD_ODBC is a linked i server)
in our scenario we upload data from SQL Server to the i and then calls a program to ingest the data.
and vice versa, Calling a program on the i to prepare a table with some data and then run a select against that table
HTH
Gad
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of D*B
Sent: Wednesday, November 13, 2019 9:34 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: linked server and appserver4rpg
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
<Mike>
For years I have been using Scott's JDBCR4 package and it has worked great and still does.
However as we are putting more and more data to SQL Server for GIS, I'm finding that I might need some different approaches.
A couple of things that have popped up recently is a needing a join on a file that now resides in sql server and a db2 file.
I don't know if I can do this at all, but I don't believe I can do this with JDBCR4. Can I accomplish this with APPSERVER4RPG? Linked Server?
Also, I'm see the possible need to somehow kick off a job on the IBM I from Sql Server. Can I do this based on a trigger with a linked Server?
Any other suggestions?
Thanks
Mike
</Mike>
Ardgate is using normal DB2 connect to other systems. DB2 can't join tables from diffrent servers and so ArdGate can't. JDBC can't join tables from diffrent servers and so JDBCE4 can't.
Linked Server has this capabilities for access from the MS SQL Server, but this produces heavy workload, has some limtations and might be slow.
DB2 Federation Server costs lots of money, needs an additional server and might be slow too.
Kicking off a job via a database connect shouldn't be a problem. Easy solution would be to write a record (via linked server) to a table on as400.
This table has a trigger doing whatever needed.
For the join I would think about replicating one of the tables with a local trigger to the remote database to have the data to join all in one database.
This should be possible in both directions.
The interesting diffrence between Ardgate and JDBCR4 is: ArdGate has one prestarted JVM for all Jobs. It does its work in a multithreaded environment and scales much better.
D*B
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.midrange.com%2fmailman%2flistinfo%2fmidrange-l&c=E,1,7xqXv7uI74geL-X93MzyaWPwlryqlWsN_qcW1D-HQ0gMM2rvQSme-5oIT8a5n5NACyXaGKPA1LkP9cJHrVg6D_1tXftbx3AqNKsdvTRlm0ByoDZDNKdIx7cZ&typo=1
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2farchive.midrange.com%2fmidrange-l.&c=E,1,-TEbXW8YNdHsAehp1OL-QH7iSQqvcbr4jC4Hi19VAfeV-DOFYwzC2GCqf2cLzVJt08fcTu7C8vRcJTkn5YK25Nx1ggeb7NP81FFv6IMBwJIXfaR0isR2jg,,&typo=1
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2fmidrange.com&c=E,1,WDjtrhZVXC8DdqJcsnuYP8y6kwgmMChIZwuDxnNSx0GyJt8rO-PnuZWqfQE85Kuwlghr7Btg-YzdI0wcXqvMyimnm4LDcS_7tyHsVt9vq9DC3QoLpjbc--x08mjJ&typo=1 by shopping at amazon.com with our affiliate link:
https://linkprotect.cudasvc.com/url?a=https%3a%2f%2famazon.midrange.com&c=E,1,FgXxppXCfR5IQXxaUembA0nYIkGpmf2nWNstPI6deTHe5j1o63nuc-RYSyqSdUm2wGWn-4iCQ_coCfzivlWolpzjM0vp8GgfGo5Cbh7z28cSc2NaHiuoN9thEw,,&typo=1
NOTICE: This message, including any attachment, is intended as a confidential and privileged communication. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this message.
midrange.com
