Replicate Stored Procedures

15 pts.
Tags:
IBM iSeries
Stored Procedures
Is anyone aware of a tool to automate the replication of the Strored Procedures from one iSeries to another?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jma1800
    We have hundreds of procedures that we would like replicated. Like you said, we could create something from scratch, just wanted to see if something was currently available. We would have as stated, have the create procedures written to a source file, then replicate this source to a secondary box, the perform a drop procedure, then run the create procedure on the secondary box. If there was a tool that had already been developed, it would same us some time. Thanks for the reply.
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following