DSNREXX interface gives 'not connected' message
A 'not connected' message while using the DSNREXX interface may indicate a problem with one of these IBM commands and jobs.
Hi Jim, I'm trying to use DSNREXX interface for DB2 version 7 and my code looks like this:
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Address ISPEXEC
sdsnexit = "'DB2.DRH1.DSNEXIT'"
sdsnload = "'DB2.DRH1.DSNLOAD'"
"LIBDEF ISPLLIB DATASET ID("sdsnexit", "sdsnload")"
ADDRESS TSO "SUBCOM DSNREXX"
IF RC THEN
S_RC = RXSUBCOM('ADD','DSNREXX','DSNREXX')
ADDRESS DSNREXX "CONNECT" ssid
IF SQLCODE ?= 0 THEN say 'not connected '
With above code, I am getting a "not connected" message. What could be the reason? Is there any other way to use DSNREXX for DB2? Regards, Srinivas
To answer this, we need more information.
What were values in SQLCODE, S_RC and RC? Are you running under TSO? Batch TSO? Other? To answer these follow-up questions, please send an email to editor@techtarget.com.
Jim Keohane, Software Developer/Consultant, Multi-Platforms, Inc.
Dig Deeper on IBM system z and mainframe systems
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Data Center experts
View all Data Center questions and answers
Start the conversation
0 comments