How many stored procedures do you have? Although I am not aware of a tool to do this, it seems it would be simple to create one. You could have a CL program that runs your source members in which you have the SQL statements that created the stored procedure. If they’re all in one source file, then you could just loop through each member and then run that source member via the RUNSQLSTM command. If that source file also contains non stored procedure members, perhaps you could also look at the subtype of the source member, if it could reliably be used to identify whether it’s one that you’d want to run.
I know there is at least one system file in which the stored procedure references are located, but I don’t recommend going that way, because there may be other files that have to be set as well. It’s better to go through the SQL interface.
Discuss This Question: 1  Reply