×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Any idea on how to get this to work when the library in question is in the IASP.
Locally, I would specify the IASP name: 'select * from myIASP.myLibrary.myFile' and it works.
When I try to do the select from the remote system: 'select * from myRemoteSystem.myLibrary.myFile' results in table not found.
This led me to think I could do: 'select * from myRemoteSystem.myIASP.myLibrary.myFile' but that results in Token . was not valid.
Thanks,
Mitch Gallman
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Wednesday, August 24, 2016 12:42 PM
To: Midrange Systems Technical Discussion
Subject: Re: Using SQL between 2 machines
For some more light reading on three part naming
http://www.ibm.com/developerworks/ibmi/library/i-improved-database-interoperability-sql-rdb/
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Rob Berendt <rob@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 08/24/2016 12:37 PM
Subject: Re: Using SQL between 2 machines
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
I believe that three part naming came out with 7.1 TR4
http://www.itjungle.com/fhg/fhg072512-story02.html
For that little tidbit may I be allowed my usual encouragement to upgrade?
Rob Berendt
midrange.com
