Re: Mimixing pure SQL stored procedures.

[CRPence <crp@xxxxxxxxxxxxxxxxxxxx>]

  Save/Restore can replicate a SQL stored procedure, so what the 
specifics of the concern are, do not seem intuitive.  Additionally the 
procedure definition is stored as a DBCLOB column ROUTINEDEF in the 
SYSROUTINES TABLE journaled to QSQJRN in QSYS2.  Personally, given the 
choice between replaying a CREATE and save/restore, I would choose the 
latter.

Regards, Chuck
-- All comments provided "as is" with no warranties of any kind 
whatsoever and may not represent positions, strategies, nor views of my 
employer

Kruse, Kat wrote:
> If you get a way to do this, pass it on.  We opened a ticket on this
> over a year ago and they haven't been able to do this automatically.  I
> have checked with the other replication/HA vendors (iTera/Vision -before
> the merger-, Data Mirror, NoMax) and they couldn't do it either.
>
> According to everyone I spoke to, this has to do with the way IBM stores
> and defines these objects.
>
> Anyway, if you get a solution, please pass it on.