RE: sql, Using a variable or column name on a 'connect to'

Thank you. I may use that when my workaround doesn't work. Like for things like functions which may not be supported by an alias.

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bryan Dietz
Sent: Friday, February 1, 2019 10:10 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: sql, Using a variable or column name on a 'connect to'

This is on a similar track, but I found this Twitter from Scott F.
that is along similar lines as the "connect to"


Hey, #SQL #Db2fori users...
If you code a table based 3-part name in your WHERE clause, your UDTF invocation will execute on the target RDB.
-- Example:
select current_server, h.* from table(qsys2.history_log_info()) h where exists (select 1 from rmtdb.sysibm.sysdummy1);


maybe it helps or spurs additional thought.

Bryan