Re: SAVLIB/RSTLIB and external stored procedures -- MIDRANGE-L

Does SAVLIB/RSTLIB save and restore other dependent objects that exist in another library than the one you are saving/restoring? The only thing CREATE PROCEDURE LIVEFIL/... stores in LIVEFIL is a record in an SQL CATALOG. The stored procedure is in LIVEPGM. I tend to store my database objects all together whether they are program objects or file objects or something else. External stored procedures are a different animal though. Those are a weird hybrid. May want to include LIVEPGM in your SAVLIB/RSTLIB.

Mark Murphy
Atlas Data Systems
mmurphy@xxxxxxxxxxxxxxx

-----Paul Bailey <PabloMotte+Midrange@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Paul Bailey <PabloMotte+Midrange@xxxxxxxxx>
Date: 01/04/2017 08:42AM
Subject: Re: SAVLIB/RSTLIB and external stored procedures

We're just starting with using stored procedures and are getting worried
that we'd have to maintain a list of stored procedures that need to be
manually re-created in a Disaster Recovery situation. Surely SAVLIB/RSTLIB
should be able to handle this by itself?.

On 4 January 2017 at 11:35, DrFranken <midrange@xxxxxxxxxxxx> wrote:

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.

--

This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD