| 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...
|
| 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 |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|