MVSFORUMS.com

Prasam · Posted: Fri May 28, 2004 1:48 am Post subject: Submitting REXX in Batch

Hi All,

I wrote one rexx routine which will access DB2 tables and give me the output in one dataset according.But running it daily will take about 30 minutes.As a result my session is getting wasted for this routine for 30 minutes.So i thought of running a JCL which will take REXX routine as input with IRXJCL as PGM.

Here is the JCL

kolusu · Posted: Fri May 28, 2004 4:59 am Post subject:

You need to execuete the rexx routine with IKJEFT01. Try the following JCL

Prasam · Posted: Fri May 28, 2004 6:50 am Post subject:

Thanks very much for your Reply Kolusu,

But still iam not able to logon to DB2 thru my REXX routine.Iam getting RC =8
when iam trying to logon to DB2 thru REXX by giving 'ADDRESS DB2 "LOGON" DB2U'

Please could you help...

Thanks,
Prasanth.
_________________
The struggle alone pleases us, not the victory. -Pascal,Blaise- 1623-1662, French Scientist

kolusu · Posted: Fri May 28, 2004 8:40 am Post subject:

Prasam,

Look at the examples in the following link. The examples can be found from page 39.

http://ew.share.org/callpapers/attach/Washington_DC/s8312.pdf

Hope this helps...

Cheers

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

Cogito-Ergo-Sum · Posted: Fri May 28, 2004 1:25 pm Post subject:

Just one question, Kolusu. Why the STEPLIB in the code you posted? Isn't it an overkill?
_________________
ALL opinions are welcome.

Debugging tip:
When you have eliminated all which is impossible, then whatever remains, however improbable, must be the truth.
-- Sherlock Holmes.

Prasam · Posted: Sun May 30, 2004 11:44 pm Post subject:

Thanks Kolusu,

I have gone thru the link you suggested.

But my problem is iam able to execute my REXX routine ok by typing TSO DEMPRINT.But problem is while i submit my REXX thru batch iam not getting the
desired result..(Logging to DB2 is failing here.).

Thanks,
Prasanth.
_________________
The struggle alone pleases us, not the victory. -Pascal,Blaise- 1623-1662, French Scientist

Maton_Man · Beginner Joined: 30 Jan 2004 Posts: 123 Topics: 0

It would really help us if you were to provide some error logs or screen prints. As it stands we would have to be psychic to work out what your problem is.
_________________
My opinions are exactly that.

Prasam · Posted: Tue Jun 01, 2004 2:51 am Post subject:

First of all,Sorry for not giving you the clearer picture of my doubt.
[code:1:904ca67c31]
Here is my code...
/*******************************REXX*******************************/
/*****************************DEMPRINT****************************/
Trace On
Main_Control:
Call Initproc
Call Process_A
Call PrepareSols
Call Closeproc
Return
Trace Off

Initproc:
SUBCOM 'DB2' /* Check environment isn't */
/* already set up */
IF RC > 0 THEN DO
ADDRESS TSO "REXXCOMM ADD DB2 REXXDB2 REXX-DB2 I-FACE'"
END

/*------------------------ CONNECT TO DB2 ----------------------------*/

SSID = "DB2P" /* setup DB2 Subsystem */
ADDRESS DB2 "LOGON" SSID /* Connect to subsystem */
IF RC = 0 THEN
NOP
ELSE DO
SAY "Unable to logon..."
EXIT
END

Process_A:
OUTDS = "PDS.OUTDS.OUPUT"
OUTDS = "'" || OUTDS || "'"
"ALLOC DSN("OUTDS") DDN(OUTPT) SHR REUSE"
If RC
_________________
The struggle alone pleases us, not the victory. -Pascal,Blaise- 1623-1662, French Scientist

Bill Dennis · Posted: Tue Jun 01, 2004 3:47 pm Post subject:

I would have you examine the STEPLIB differences between your TSO proc and your batch TSO JCL. Maybe you're missing some DB2 libraries?

Regards,
Bill Dennis

Maton_Man · Beginner Joined: 30 Jan 2004 Posts: 123 Topics: 0

...after you've checked Bill's suggestion perhaps you could tell me what version of DB2 you have?
_________________
My opinions are exactly that.

Maton_Man · Beginner Joined: 30 Jan 2004 Posts: 123 Topics: 0

I don't really do this sort of stuff much but the manual (surprise, surprise) appears to give the answer. Under 6.2.6.8 Calling a stored procedure from a REXX Procedure in the DB2 Application Programming Guide there is the following information:

Maton_Man · Beginner Joined: 30 Jan 2004 Posts: 123 Topics: 0

Sorry folks. Ignore that last response. I posted this in the WRONG forum.
_________________
My opinions are exactly that.