IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
 

about DB2-REXX error

THIS IS AN ARCHIVE FORUM: CLICK HERE TO GO TO THE ORIGINAL TOPIC

 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
View previous topic :: View next topic  
Author Message
sathish1760



Joined: 02 May 2008
Posts: 25
Location: chennai

Posted: Tue Jul 08, 2008 5:32 pm    Post subject: about DB2-REXX error  

Hi,

I want to use a DB2 table in a rexx program. For DB2-REXX connection I am using the below code.


/* Rexx */

'SUBCOM DSNREXX'

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

ADDRESS DSNREXX "CONNECT" DSNZ

EXIT

For this I am getting RC(-1) in the fourth line..help me regarding this error.

Thanks in advance.
Back to top  
ofer71



Joined: 27 Dec 2005
Posts: 1930
Location: Israel

Posted: Tue Jul 08, 2008 5:57 pm    Post subject:  

Are you sure your REXX modules for DB2 were installed (hint: Ask your DBA)?

O.
Back to top  
PeD



Joined: 26 Nov 2005
Posts: 308
Location: Belgium

Posted: Tue Jul 08, 2008 6:06 pm    Post subject:  

is DSNZ a valid SSID ??? maybe not
Back to top  
sathish1760



Joined: 02 May 2008
Posts: 25
Location: chennai

Posted: Tue Jul 08, 2008 6:09 pm    Post subject: Reply to: about DB2-REXX error  

Hi PeD,

DSNZ is a valid SSID.
Back to top  
PeD



Joined: 26 Nov 2005
Posts: 308
Location: Belgium

Posted: Tue Jul 08, 2008 6:31 pm    Post subject:  

Are the lines you show the whole code?

I explain : if you code somewhere before DSNZ = 'DDDD'
then you pass the command CONNECT, the result will be wrong.
Back to top  
 
       IBMMAINFRAMES.com - IBM Mainframe Support Forums Index -> DB2
Page 1 of 1
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM