× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. March 2013

SQL Functions "disappeared"

Within the last week, after PTFs were applied including
some of these:
 
SF99710          13037 <= Cum
SF99709             78 <= Hiper
SF99708             26 <= Security
SF99707              6 <= tech refresh
SF99701             21 <= db2
 
We have "lost" several User Defined Functions.
The error is FUNCTION in LIBRARY type *SRVPGM not found.
 
User-defined function DEC3 cannot be invoked.
DEC3 in V84FILES# type *SRVPGM not found.
 
Retrieving them using System i Navigator and recreating
(yes we have to DROP the non-existent function!) without any changes fixes the
problem. So far, the ones we had to recreate are straight sql types.
 
Anyone else seeing this? Maybe I missed a note when we
put the PTFs on.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.