Re: SAVLIB/RSTLIB and external stored procedures

[DrFranken <midrange@xxxxxxxxxxxx>]

We ran into the same thing with a migration recently. It does not 
restore them as desired. In our case it was one time and the developer 
said: There are three, I'll recreate them.  We did not investigate further.

        - Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 1/4/2017 6:08 AM, Paul Bailey wrote:
> Hi,
>
> Does SAVLIB save external stored procedures? And does RSTLIB restore them
> to a different library?
>
> I have a procedure created with:
>
>
>
> CREATE PROCEDURE LIVEFIL/GETNEWCLAIMNUMBER(OUT REFERENCE INTEGER )
>
> LANGUAGE RPGLE NOT DETERMINISTIC NO SQL EXTERNAL NAME
>
> LIVEPGM/TR1406 PARAMETER STYLE GENERAL
>
> Every night I save library LIVEFIL out to a tape. Much later in the night I
> also restore LIVEFIL from that tape into library CLAIMFIL (after completely
> removing the older CLAIMFIL). Every morning the above procedure does not
> exist in CLAIMFIL. LIVEFIL and CLAIMFIL are not "schema", just plain
> libraries.
>
> With backup procedures of other DBMSs (e.g. MariaDB) all procedure and
> table definitions are saved with the data backups, and on restore to a new
> database anything missing is recreated automatically.
>
>
> -Paul.