I have a library containing SQL functions calling sub-procedures in a RPG Service program - see raw code below) : I can see them in the SYSFUNCS table. I first save this library (SAVLIB) and then delete it (DLTLIB). Sql functions are removed from SYSFUNCS table. If I want to restore the library, Sql functions are not created in SYSFUNCS table ; I have to run SQL scripts to create them again. The same thing happens when I use CPYLIB command to duplicate this library. In both cases the result is that some "objects" are missing if I run my software programs using these Sql functions. Is there a way to restore or copy libraries without executing scripts to re-create Sql functions. Thanks.
Code
Code