Re: Copying SQL UDF's to new system

Lucky for me!  There were only 10 or so but the sav/rst was much easier than recreating.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

 
 




From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Charles Wilt <charles.wilt@xxxxxxxxx>
Sent: Wednesday, April 4, 2018 6:24 AM
To: Midrange Systems Technical Discussion
Subject: Re: Copying SQL UDF's to new system
 

Yeah, there's been enhancements to 7.2...

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_72/sqlp/rbafyroutinemgmt.htm


Db2 for i: Managing SQL and external routine objects - IBM
www.ibm.com
SQL and external functions and procedures are implemented using system programs and service programs. When managed correctly, these objects can regenerate the routine registration in the QSYS2/SYSROUTINES, QSYS2/SYSPARMS, and QSYS2/SYSROUTINEDEP system catalogs.


Save/Restore (SAVOBJ/RSTOBJ and SAVLIB/RSTLIB)
A row is inserted into the SYSROUTINES catalog for each routine. The
EXTERNAL_NAME column contains the name of the newly restored executable
object.

Charles

On Tue, Apr 3, 2018 at 8:05 PM, Roger Harman <roger.harman@xxxxxxxxxxx>
wrote:

I tried save/restore and it appears to work.  Agreed, creating again would
be a PITA - well, just cumbersome since I did these outside of change
management.

V7R2


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Mike Jones
Sent: Tuesday, April 03, 2018 3:15 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Copying SQL UDF's to new system

Hi Roger,

Unless something has been enhanced recently in V7R2 or later, "external"
SQL functions and procedures don't get recreated via simple save / restore
operations.

Either recompile them from the source code, or harvest the source from
QSYS2.SYSFUNCS and recompile.

Hopefully this has been enhanced to work through save / restore, or I've
simply missed something on how to do it, because it is a PITA.

Mike

date: Tue, 3 Apr 2018 20:38:59 +0000

from: Roger Harman <roger.harman@xxxxxxxxxxx>
subject: Copying SQL UDF's to new system

I have a number of SQL UDF's created on one of our machines.? I'd like to
copy them to another.

Is there some trick, or is just a SAV/RST of the service programs all

that

is needed?

Thanks.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://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
--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://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