On 20-Apr-2011 16:56 , James Lampert wrote:
Try this modification to direct to the external procedure in the
EXTERNAL NAME 'WTDEVELOP/CENSORACCT(Procedure_Name)'
That unscrewed me. After fixing a few other things, it
Once the UDF was working and registered, I had to tear down and
recreate the VIEW that uses it to censor the data.
Question: Now that the UDF is registered on this ILE RPG SRVPGM,
what happens if I have to modify the SRVPGM? Do I have to DROP and
reCREATE the UDF and the VIEW?
Since v6r1 the ALTER FUNCTION statement is available; I do not recall
ever using that statement. This UDF was "external scalar" and the
syntax for that is found at the following link; separate links are
available for SQL scalar, and both external and SQL TABLE functions:
To get the SQL information associated with [i.e. added to or replaced
in] the *SRVPGM, re-register the UDF either by DROP FUNCTION and then
CREATE FUNCTION or by ALTER FUNCTION which presumably should suffice
[when available]. Otherwise the "function resolution" for the reference
in the VIEW should work just as before the changes; I do not recall ever
having to recreate a VIEW unless the UDF would no longer function such
as with interface changes. Both the DROP and ALTER are enabled by
default, though can be prevented if the RESTRICT clause is specified and
the UDF is still referenced in the VIEW [or wherever usage of the UDF is
tracked]; use the RESTRICT option to be sure deprecated references are
removed before the DROP or ALTER.
This mailing list archive is Copyright 1997-2019 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