Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DSNREXX Connect

26 views
Skip to first unread message

Albert Klimek

unread,
Oct 15, 2009, 11:59:24 AM10/15/09
to
Hi list
DSNREXX: a second connect to an alternativ DB2 environment run with
sqlcode=0, but is not done.
My workaround is always try a disconnect.

How can i find out an existing connect ?
Thanks Albert

VERLAGSGRUPPE WELTBILD GMBH
Sitz der Gesellschaft: Augsburg
Handelsregister Augsburg HRB 6035
Ust-ID-Nr: DE 127501299

Geschäftsführung:
Carel Halff (Vorsitzender), Dr. Martin Beer, Dr. Klaus Driever

Vorsitzender des Aufsichtsrates:
Dr. Klaus Donaubauer

James Campbell

unread,
Oct 17, 2009, 7:48:48 AM10/17/09
to
1) EXEC DSNREXX "CONNECT "ssid
or
2) EXEC DSNREXX "EXECSQL CONNECT "db2_location
?

3) EXEC DSNREXX "EXECSQL CONNECT"
will return some basic information about the DB2 you are currently
connected to - which might, if you have used 2), not be the same that 1)
connected to.

You can return to your "home" DB2 (that is, the one 1) originally connected
to ) by
4) EXEC DSNREXX "EXECSQL CONNECT RESET"
and then find what it is by
5) EXEC DSNREXX "EXECSQL SET :HV = CURRENT SERVER"
or, if it is a data sharing group
6) EXEC DSNREXX "EXECSQL SET :HV = CURRENT MEMBER "

James Campbell

On 15 Oct 2009 at 16:01, Albert Klimek wrote:

> Hi list
> DSNREXX: a second connect to an alternativ DB2 environment run with
> sqlcode=0, but is not done.
> My workaround is always try a disconnect.
>
> How can i find out an existing connect ?
> Thanks Albert
>
> VERLAGSGRUPPE WELTBILD GMBH
> Sitz der Gesellschaft: Augsburg
> Handelsregister Augsburg HRB 6035
> Ust-ID-Nr: DE 127501299
>

> Gesch�ftsf�hrung:


> Carel Halff (Vorsitzender), Dr. Martin Beer, Dr. Klaus Driever
>
> Vorsitzender des Aufsichtsrates:
> Dr. Klaus Donaubauer

----------------------------------------------------------------------
For TSO-REXX subscribe / signoff / archive access instructions,
send email to LIST...@VM.MARIST.EDU with the message: INFO TSO-REXX

Albert Klimek

unread,
Oct 19, 2009, 8:18:13 AM10/19/09
to
Cool, that's what I'm looking for

sqlstmt = 'EXECSQL SET :CURRENT_SERVER = CURRENT SERVER'
address DSNREXX sqlstmt
msg ='Connected to DB2subsys 'current_server
say msg

Many Thanks Albert

James Campbell <jacam...@ACSLINK.NET.AU>
Gesendet von: TSO REXX Discussion List <TSO-...@VM.MARIST.EDU>
17.10.2009 13:48
Bitte antworten an
TSO REXX Discussion List <TSO-...@VM.MARIST.EDU>


An
TSO-...@VM.MARIST.EDU
Kopie

Thema
Re: [TSO-REXX] DSNREXX Connect

0 new messages