MVSFORUMS.com

[vsr100481]

Hi,

Can any one help me by sending/finding Run JCL for both COBOL Stored Procedures and DB2 Stored Procedures?

Help Required.

WIth Regards
Sundar

[Manas Biswal]

vsr100481,

What do you mean by run JCLs for stored procedures. Stored procedures are called by other programs. Do you mean the WLM or SPAS jobs for the stored procedures.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

[vsr100481]

Manas,

Yes, Basically Stored Procedures are being called from Front end (Java program, etc..) or a Batch Program, or CICS.

But here if i want to test a COBOL/DB2 SP directly thru a JCL (run). i mean i dont want to test thru front end or batch or CICS. I want to test or Trigger the program through a JCL. (like run JCL for batch COBOL DB2 program). Please tell me ist possible. If your answer is yes. Can you provide me the JCL which run the SP in WLM.

Please advice.

Thanks in advance
Sundar

[SureshKumar]

vsr100481,
If you are not familiar with the Mainframe it will be hard to follow the instructions. Anyways, when you mention "thru JCL", well its Batch. You may have to have a Host program to Invoke your SP, this host program may have to execute thru a RRS stub to manage resources. The host has to be compiled shuch that it's RRS compatiable. You need to note that SP's execute in their own address space, spawned by WLM. Overall, it depends on what and how you want to test. A simple solution would be to test it as a normal cobol program(call it from a host program just as any other cobol call and test the business logic).
Providing just the JCL will not help much unless all the other requirement's are not satisfied. Thanks

[vsr100481]

Suresh,

First f all thanks for your kind reply.

i am a developer working under Mainframe Platform. Sorry, i am quite confused with your explantion.

here we were testing the DB2 SPs thru Stored Procedure Builder or thru a Host program (which calls the DB2 SP). Simillarly COBOL Stored Procedures are also being tested thrugh a COBOL or COBOL DB2 program (a simple cobol call).

But my doubt here is, can a cobol SP is tested thru a JCL . I mean do we have any run JCL to test a cobol sp.

For ex. a cobol db2 programs are tested thru a run JCL. Basically we will call a COBOL SP thru a COBOL DB2 Program or COBOL Program using a simple call with IN/OUT parameters. So when we run the COBOL or COBOL DB2 program, it will run the SP. Here this COBOL program is ran thru a run JCL.

Now is it possibile to run that sp thru a JCL by passing those inputs in that JCL?

Please guide me.

Sorry.. if my question s silly.. am in learning stage..

Please advice..

thanks
Sundar

[SureshKumar]

vsr100481,
I am not sure about your requirement. If you need to run the program as a stored procedure call, then you need to have a host program that can issue an EXEC SQL CALL to the SP program, without which the WLM/address space & SP execution would not happen. this is to my knowledge, however ther may be other methods. Thanks

[srini_igsi]

Hi,

Once the Call is issued, the control will be pased to the SP and if it returns any result set by issuing the 'GOBACK', the control will be passed back to the calling pgm, so how to work with the rows returned in the result set..whats the next step??

EXEC SQL
CALL SPNAME(arguments to be passed/received to/from the SP)
END-EXEC.
_________________
Thanks,
-Srini

[SureshKumar]

srini_iqsi,
Are you suggesting a solution or is it a question? I am assuming you are asking a quetion regarding how to proceed after the call...refer to this topic. Thanks

[url]
http://www.mvsforums.com/helpboards/viewtopic.php?t=5985&highlight=allocate+cursor
[/url]