|
View previous topic :: View next topic
|
| Author |
Message |
chillmo
New User
Joined: 31 Aug 2017
Posts: 36
Location: USA
|
|
|
|
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 |
|
 |
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3075
Location: NYC,USA
|
|
|
|
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 |
|
|
chillmo
New User
Joined: 31 Aug 2017
Posts: 36
Location: USA
|
|
|
|
No, I haven't but let me search how to do this and report my findings.
Thanks for the assist! |
|
| Back to top |
|
|
|
|
