Replicate Stored Procedures
Is anyone aware of a tool to automate the replication of the Strored Procedures from one iSeries to another?
Software/Hardware used:
Software/Hardware used:
ASKED:
July 31, 2008 12:50 PM
UPDATED:
August 1, 2008 2:58 PM
RELATED QUESTIONS
- What is the best way to replicate SQL 2008 DBs to a failover site?
- What are the points to be taken care of when designing a database on Linux?
- Passing a database name as a stored procedure parameter
- Failing to migrate public folders from Exchange 2000 to Exchange 2007
- passing parameters via a datastructure to and from a procedure
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.