We're trying to create our first RPG service program UDF. We've created many SQL UDFs without a problem.
When we run the CREATE FUNCTION statement it runs successfully and the job log indicates the object was created in the library specified, AND the function is listed in the DB2 system tables, BUT .... the object doesn't exist anywhere ! ???? So when we try to run it we get a "function not found", of course.
We are on 7.1 TR11 and here is the source code:
CREATE or replace FUNCTION zzsteveb/NXTAVLDT_F(@comp char(2),@locn numeric(2,0),@SKU char(7), @ret_date numeric(8,0))
external name 'MOD2000/NXTAVLDTS(NXT_AVL_DT)'
PARAMETER STYLE general
program type sub ;
Did we do something wrong or is this a bug?