Running DB2 SP thru REXX

divakaran · Posted: Mon Mar 11, 2013 2:04 pm

Hi,

Can anyone help me to execute a DB2/COBOL SP thru rexx in mainframe(TSO/Zos).

I tried getting the information in google but thru most of ways I tried I am getting syntax errors.

List of ways I tried so far.
1. I tried to populate the call string in prepare statement and tried to execute it.
"EXECSQL PREPARE S100 INTO :SQLDA FROM :S1Z"
"EXECSQL EXECUTE IMMEDIATE S100"

2. Tried to call a SP directly
"EXECSQL CALL IPZWTBT.IPXSP5XX('INSIFS',' ',' ') ",
"USING DESCRIPTOR SQLDA END-EXEC"

enrico-sorichetti · Posted: Mon Mar 11, 2013 2:14 pm

syntax error ???
pretty generic, not much to work on

did You try to run with a REXX Trace ?

divakaran · Posted: Mon Mar 11, 2013 5:01 pm

Bill Woodger · Posted: Mon Mar 11, 2013 5:27 pm

Look in your manual. Search the forum here. You'll find examples.

enrico-sorichetti · Posted: Mon Mar 11, 2013 5:33 pm

not the latest ones but more than enough for such a basic need

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/Shelves/IKJ4BK90

Bill Woodger · Posted: Mon Mar 11, 2013 5:51 pm

It is not good etiquette to delete a post which has already received replies. Your post has been re-instated.

Anuj Dhawan · Posted: Mon Mar 11, 2013 8:21 pm

You might need to spend quite a good time with manuals. Apart from what Enrico has talked about, this might be of interest: my.safaribooksonline.com/book/databases/db2/0738498181/rexx-programming/ida129

divakaran · Posted: Tue Mar 12, 2013 2:54 pm

Thanks Anuj and enrico

www.tek-tips.com/viewthread.cfm?qid=1204086

This link was helpful.
Found a tailor made solution

INPT - INPUT VARIABLE
OUTT - OUTPUT VARIABLE
IOT - INPUT OUTPUT VARIABLE

I was able to execute the below code without issues thru DSNREXX

"EXECSQL CALL PWTWTBT.PWTSPXXX(:INPT,:OUTT,:IOT)"