Execute BINDs from a PL/I-program

Rolf Drees

Execute BINDs from a PL/I-program
Hello List,

how can I execute a REBIND from a PL/I-program? DB2-Commands can be done
via DSNWLI but I remember that it is not possible to run a BIND or REBIND
on this way. Any ideas?

Many thanks in advance and kind regards
Rolf Drees

Entwicklung / Datenbankmanagement
http://gxdba1.gadeg.de
Tel.: 0251 7133 - 2238 - Fax.: 0251 7133 - 92238
eMail: [login to unmask email]

GAD eG
Weseler Straße 500 - 48163 Münster
http://www.gad.de


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Sorensen Henrik (KAFC 21)

Re: Execute BINDs from a PL/I-program
(in response to Rolf Drees)
Hi Rolf,

On the mainframe, you could submit a job from the pl/1 program, that does the bind.
Mail me if you need some details.


Henrik



-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, December 03, 2003 12:33 PM
To: [login to unmask email]
Subject: Execute BINDs from a PL/I-program


Hello List,

how can I execute a REBIND from a PL/I-program? DB2-Commands can be done
via DSNWLI but I remember that it is not possible to run a BIND or REBIND
on this way. Any ideas?

Many thanks in advance and kind regards
Rolf Drees

Entwicklung / Datenbankmanagement
http://gxdba1.gadeg.de
Tel.: 0251 7133 - 2238 - Fax.: 0251 7133 - 92238
eMail: [login to unmask email]

GAD eG
Weseler Straße 500 - 48163 Münster
http://www.gad.de


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Rolf Drees

Re: Execute BINDs from a PL/I-program
(in response to Sorensen Henrik (KAFC 21))
Hello Henrik,

subitting a job via internal reader is not a solution for me because I have
to know in the program when the rebinds are done. After the rebinds the
program executes additional queries. I'm looking for something like an API
or an STP (like DSNUTILS).

Kind regards
Rolf Drees

Entwicklung / Datenbankmanagement
http://gxdba1.gadeg.de
Tel.: 0251 7133 - 2238 - Fax.: 0251 7133 - 92238
eMail: [login to unmask email]

GAD eG
Weseler Straße 500 - 48163 Münster
http://www.gad.de


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Roger Miller

Re: Execute BINDs from a PL/I-program
(in response to Rolf Drees)
There are a couple of possibilities for invoking the DB2 commands, but
PL/I is not an easy language. Calling a CLIST or Rexx exec would let you
invoke the DSN and BIND commands. There are also TSO command interfaces
that could be used.

Roger Miller

On Wed, 3 Dec 2003 14:09:16 +0100, [login to unmask email] wrote:

>Hello Henrik,
>
>subitting a job via internal reader is not a solution for me because I
have
>to know in the program when the rebinds are done. After the rebinds the
>program executes additional queries. I'm looking for something like an API
>or an STP (like DSNUTILS).
>
>Kind regards
>Rolf Drees
>
>Entwicklung / Datenbankmanagement
>http://gxdba1.gadeg.de
>Tel.: 0251 7133 - 2238 - Fax.: 0251 7133 - 92238
>eMail: [login to unmask email]
>
>GAD eG
>Weseler Straße 500 - 48163 Münster
>http://www.gad.de
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: Execute BINDs from a PL/I-program
(in response to Roger Miller)
One method that has occurred to me is to write a stored procedure to do the
bind. DSNTPSMP (the Stored Procedure Builder REXX code) has code which
invokes a bind. Borrow the code from and you could have a SP do the bind.

Be aware that this is not a supported interface - at some time IBM might
change things in such a way as to kill this.

James Campbell


On Wed, 3 Dec 2003 12:32:58 +0100, [login to unmask email] wrote:

>Hello List,
>
>how can I execute a REBIND from a PL/I-program? DB2-Commands can be done
>via DSNWLI but I remember that it is not possible to run a BIND or REBIND
>on this way. Any ideas?
>
>Many thanks in advance and kind regards
>Rolf Drees
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cristian Molaro

Re: Execute BINDs from a PL/I-program
(in response to James Campbell)
Hello,

I use ISPLINK inside a PL/I program in order to create and submit JCLs for
bind/rebind.
The program in running in TSO, I don't know if it works in batch...

Regards, Cristian




James Campbell
<[login to unmask email] To: [login to unmask email]
NK.NET.AU> cc:
Sent by: DB2 Data Subject: Re: Execute BINDs from a PL/I-program
Base Discussion
List
<[login to unmask email]
ORG>


12/16/2003 08:34
AM
Please respond to
DB2 Database
Discussion list
at IDUG






One method that has occurred to me is to write a stored procedure to do the
bind. DSNTPSMP (the Stored Procedure Builder REXX code) has code which
invokes a bind. Borrow the code from and you could have a SP do the bind.

Be aware that this is not a supported interface - at some time IBM might
change things in such a way as to kill this.

James Campbell


On Wed, 3 Dec 2003 12:32:58 +0100, [login to unmask email] wrote:

>Hello List,
>
>how can I execute a REBIND from a PL/I-program? DB2-Commands can be done
>via DSNWLI but I remember that it is not possible to run a BIND or REBIND
>on this way. Any ideas?
>
>Many thanks in advance and kind regards
>Rolf Drees
>

---------------------------------------------------------------------------------

Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm




This e-mail message, including any attachments transmitted with it, is
CONFIDENTIAL and may contain legally privileged information. This message
is intended solely for the use of the individual or entity to whom it is
addressed. If you are not the intended recipient you should not read, copy,
distribute, disclose or otherwise use this information. If you have
received this message in error, please notify us immediately and delete it
from your system. The integrity and security of this message cannot be
guaranteed and it may be subject to data corruption, interception and
unauthorised amendment, for which we accept no liability. Euroclear is the
marketing name for the Euroclear System, Euroclear plc, Euroclear Bank and
their affiliates. http://www.euroclear.com

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm