MVSFORUMS.com

pradeepg · Posted: Thu Dec 09, 2004 9:24 am Post subject: What is DSNREXX?

Hello List,

What is DSNREXX and before I code ADDRESS DSNERXX do I need to allocate any datasets which has the DSNREXX loadlib. And in which library I can find the DSNREXX load.

Basically I am trying to execute a REXX which I got from somebody it connects to DB2 and displays catalog information for a given table space.
It is failing when it encounters the DSNREXX command.

Please help me. Thanks in advance.

- Pradeep

kolusu · Posted: Thu Dec 09, 2004 10:40 am Post subject:

pradeepg,

DSNREXX is the REXX DB2 interface which allows of execueting sql queries via Rexx. It is available since DB2 Version 5. If you are getting an error running the procedure then you need to check if your shop has installed the interface. Check HLQ.SDSNLOAD library in your system where it normally resides.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

pradeepg · Posted: Thu Dec 09, 2004 11:28 am Post subject:

Hi Kolusu,

Thanks for the info. I found the loadlib. But still I couldn't connect to DB2.
When it comes to following code it is failing with RC(-3).

ADDRESS DSNREXX "CONNECT SDB20A'.

I couldn't figure out what is the issue here. Any help. Thank you.

- Pradeep

pradeepg · Posted: Thu Dec 09, 2004 4:05 pm Post subject:

There was typo in my earlier posting.

ADDRESS DSNREXX "CONNECT SDB20A".

SDB20A is our DB2 Sub system name.

Thanks,
Pradeep

kolusu · Posted: Thu Dec 09, 2004 4:19 pm Post subject:

pradeepg,

The code should be as follows.

[code:1:47a7fff7dd]
Address TSO "SUBCOM DSNREXX" /* HOST CMD ENV AVAILABLE? */
IF RC THEN /* NO, LET
_________________
Kolusu
www.linkedin.com/in/kolusu