Can Stored Procedure Call Another Stored Procedure

Main Menu Computer Tips Software Downloads Menu

Main Question - Posted From Guest:
Is there any problems with a mainframe stored procedure calling another mainframe stored procedure, or possibly many procs within one job stream? It's possible i could be calling as many as 7 or 8 in the future but all in the same job stream

Moderator Says:
This is fine, we do this stuff all the time. Stored procedures can call other stored procs, which can call other stored procs, the chain can continue very deep on this without a problem. Where you might have a problem though is the commit levels that occur within calls, even if your stored proc is doing read only processing, there are still commit levels. You need to make sure your DBA has this set properly and what this level is, normally it might be 20 thousand for example. So if you are processing 50 thousands rows and calling 5 stored procedures during the sequence, obviously you would his this call threshold and abend. So always double check this level on the mainframe or make sure your are committing even if your calls are read only, as they don't have to be updating for this stored procedure threshhold to be hit. (Although normally by default this is set high, but on the mainframe its common to be processing millions of rows.... so it can be reached easily.)

Add your reply below ...

This site allows you to ask questions and get answers from various posters, you may also answer any posts if you feel like you have input to give. Feel free to ask for help with any new question you wish, but most of the questions here are tech related. You will find many questions and answers related to your Ipod or Ipod Nano, Itunes, audio and video converting, spyware or adware cleanup, pc or other computer questions, and even mainframe questions. Although these are the tech questions most often asked, you will find help on almost any computer or software related subject. Feel free to go to the main menu and review the posts already present, or feel free to ask your own question. (Some questions will be closed once the moderator feels they are sufficiently answered and that no other input is needed).