RE: SQL "SET CONNECTION" and DB2

I'm looking to swap between connections and I'm afraid a CONNECT RESET will close one of my connections.

-----Original Message-----
From: D*B [mailto:dieter.bender@xxxxxxxxxxxx]
Sent: Wednesday, September 13, 2017 2:00 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: SQL "SET CONNECTION" and DB2

<Justin>
Is there a keyword or special value for the local DB2 when using a "SET CONNECTION"? I'd rather not use a literal, since I've seen the DB name change before (with hardware changes).
</Justin>

connect reset is your friend.

D*B

PS: one of the problems is, that you can't check to wich srever you are connected to, as every server has its own method (e.g.: select current_server from sysibm.sysdummy1 for DB2 on AS/400 and all compatible systems, regardless it's named today. I recommedn to have the same tabel on all systems of your distributed database to get the name of the current system beeing connected to.