Re: Can you suggest how I can connect to another database in SQL reading the remote file and updating a local file

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Ever the naysayer, Dieter!

I do not believe anyone is saying this is something could not be done 
using several steps. Chuck gave us a set of steps using things like 
QMQRY, etc. What the 3-part naming does is let us skip the CONNECT TO - 
it does an explicit connection, according to the documentation.

So it is, IMO, a significant addition to our arsenal of tools. Scott 
Forstie has some articles out that give good examples of the use here - 
and benefits. Anyone interested can simply google for three-part naming 
iseries sql - the article I looked at is on iprodeveloper.com

Regards
Vern

On 10/18/2014 1:09 AM, D*B wrote:
> Rab,
>
> three part alias is nothing great or new (it's only another mode of 
> writing for a feature, existing from the beginning of DB2/400). You 
> could redirect the output of a select statement to a local outfile 
> with interactive SQL and QMQRY and this is working for local files and 
> remote files in the RDBDIR.
-snip-