IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Invoke stored procedure via batch JCL.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
chillmo

New User


Joined: 31 Aug 2017
Posts: 25
Location: USA

PostPosted: Mon Aug 22, 2022 2:45 am
Reply with quote

Hello IBMers!

I was give a requirement to create a report with multiple fields to simply the validation process and the business sent a screen print of all fields.

The screen print was created by a Java program invoking a stored procedure (STP), which resides on the MF, so rather than reinvent the wheel, I was wondering is it possible to query the table, as a driver to get input, and invoke the STP via JCL (DSNTEP2) using the parms it expects? The STP returns a result set, which I'll write to a CSV and pass to the business for review. The input file can contain up to 100,000 rows/records.

If NOT, I'll attempt to download the table into a flat file and use this to call the STP via COBOL.

Any assistance would be greatly appreciated.

Thanks!
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2945
Location: NYC,USA

PostPosted: Mon Aug 22, 2022 4:37 pm
Reply with quote

Did you call STP before in a batch ?

Simply query the table in a batch module as same as STP and prep the CSV.
Back to top
View user's profile Send private message
chillmo

New User


Joined: 31 Aug 2017
Posts: 25
Location: USA

PostPosted: Mon Aug 22, 2022 10:22 pm
Reply with quote

No, I haven't but let me search how to do this and report my findings.

Thanks for the assist!
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts pass data as symbolic parameter from ... CLIST & REXX 2
No new posts Calling COBOL DB2 program from a COBO... COBOL Programming 2
No new posts Easy way to delete selected members f... IBM Tools 12
No new posts Intertest Batch issue with called ass... COBOL Programming 4
No new posts Cond parameter and Rc code of a proce... JCL & VSAM 5
Search our Forums:

Back to Top