Unconfigured Ad Widget

Collapse

Announcement

Collapse
No announcement yet.

SQL function restore

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL function restore

    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
Working...
X