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: 30
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: 3055
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: 30
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 How to get a stack trace on a looping... ABENDS & Debugging 5
No new posts Calling Java method from batch COBOL ... COBOL Programming 5
No new posts Help in Automating Batch JCL jobs mon... JCL & VSAM 3
No new posts Batch install term/printer CICS 2
No new posts File Aid Batch IBM Tools 7
Search our Forums:

Back to Top