DSNREXX question

DB2 DBA

DSNREXX question

When I execute a DSNREXX exec in FOREGROUND I get error at

S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')

it says DSNREXX module not found as the load library is not known. I could run the REXX exec successfully in BATCH by STEPLIBing the load library. How can I make the REXX exec work in FOREGROUND?. Please advise. Thanks.



--
Technoville Consulting
A Leader in strategic resourcing
Direct:774-279-1151
www.TechnovilleUSA.com


---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

laura miller

Re: DSNREXX question
(in response to DB2 DBA)
I will be out of the office until Friday December 10. I will respond
to your message as soon as possible when I return. If you need
immediate assistance, please contact either Bill Boyd or the Help Desk.



>>> DB2-L 12/08/04 22:43 >>>


When I execute a DSNREXX exec in FOREGROUND I get error at

S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')

it says DSNREXX module not found as the load library is not known. I
could run the REXX exec successfully in BATCH by STEPLIBing the load
library. How can I make the REXX exec work in FOREGROUND?. Please
advise. Thanks.



--
Technoville Consulting
A Leader in strategic resourcing
Direct:774-279-1151
www.TechnovilleUSA.com


---------------------------------
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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: DSNREXX question
(in response to laura miller)
Use TSOLIB - which is a standard TSO command. This must be run at the
READY prompt or in a CLIST being run at the READY prompt - ie not in ISPF
or REXX. If you want to run it from a REXX program being executed at the
READY prompt you have to
- clear the data stacks ("dropbuf" and "delstack" until there's nothing
left).
- queue "TSOLIB <whatever>"
- queue "exec <the rexx you're executing with its parameters>"
- exit

After the exit, TSO will execute the queued TSOLIB - putting the SDSNLOAD
and SDSNEXIT (I presume) into the load path, then rexecute the REXX. This
time SDSNLOAD and SDSNEXIT will be found.

Some people just put this (or similar code) into their startup REXX, so
SDSNLOAD and SDSNEXIT are always there.

The cbt tape (www.cbttape.org) has several similar programs - some of which
can be run under ISPF.

James Campbell

On Wed, 8 Dec 2004 19:43:41 -0800, DB2 Database Solutions Port
<[login to unmask email]> wrote:

>
>When I execute a DSNREXX exec in FOREGROUND I get error at
>
>S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
>
>it says DSNREXX module not found as the load library is not known. I could
run the REXX exec successfully in BATCH by STEPLIBing the load library. How
can I make the REXX exec work in FOREGROUND?. Please advise. Thanks.
>
>
>
>--
>Technoville Consulting
>A Leader in strategic resourcing
>Direct:774-279-1151
>www.TechnovilleUSA.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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

Mr K S

Re: DSNREXX question
(in response to James Campbell)
Hi,

The loadlib containing DSNREXX should normally be in the linklist.
Obviously it is not, in your case.

Try

/*rexx*/
"Alloc f(DD1) da(load library) shr"
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX',' ','DD1')

Note : DD1 can be any ddname.

For further info, please refer help on RXSUBCOM.

Regards,
Kals

On Wed, 8 Dec 2004 19:43:41 -0800, DB2 Database Solutions Port
<[login to unmask email]> wrote:

>
>When I execute a DSNREXX exec in FOREGROUND I get error at
>
>S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
>
>it says DSNREXX module not found as the load library is not known. I
could run the REXX exec successfully in BATCH by STEPLIBing the load
library. How can I make the REXX exec work in FOREGROUND?. Please advise.
Thanks.
>
>

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

laura miller

Re: DSNREXX question
(in response to Mr K S)
I will be out of the office until Friday December 10. I will respond
to your message as soon as possible when I return. If you need
immediate assistance, please contact either Bill Boyd or the Help Desk.



>>> DB2-L 12/09/04 05:25 >>>

Hi,

The loadlib containing DSNREXX should normally be in the linklist.
Obviously it is not, in your case.

Try

/*rexx*/
"Alloc f(DD1) da(load library) shr"
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX',' ','DD1')

Note : DD1 can be any ddname.

For further info, please refer help on RXSUBCOM.

Regards,
Kals

On Wed, 8 Dec 2004 19:43:41 -0800, DB2 Database Solutions Port
<[login to unmask email]> wrote:

>
>When I execute a DSNREXX exec in FOREGROUND I get error at
>
>S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
>
>it says DSNREXX module not found as the load library is not known. I
could run the REXX exec successfully in BATCH by STEPLIBing the load
library. How can I make the REXX exec work in FOREGROUND?. Please
advise.
Thanks.
>
>

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. 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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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

DB2 DBA

Re: DSNREXX question
(in response to laura miller)
Thank you for the prompt assistance. I tried this way. But still same issue.

Kals <[login to unmask email]> wrote:Hi,

The loadlib containing DSNREXX should normally be in the linklist.
Obviously it is not, in your case.

Try

/*rexx*/
"Alloc f(DD1) da(load library) shr"
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX',' ','DD1')

Note : DD1 can be any ddname.

For further info, please refer help on RXSUBCOM.

Regards,
Kals

On Wed, 8 Dec 2004 19:43:41 -0800, DB2 Database Solutions Port
wrote:

>
>When I execute a DSNREXX exec in FOREGROUND I get error at
>
>S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
>
>it says DSNREXX module not found as the load library is not known. I
could run the REXX exec successfully in BATCH by STEPLIBing the load
library. How can I make the REXX exec work in FOREGROUND?. Please advise.
Thanks.
>
>

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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



--Database Solutions Port.



---------------------------------
Do you Yahoo!?
Send holiday email and support a worthy cause. Do good.

---------------------------------------------------------------------------------
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". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. 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