Re: UDFx error 42884

Charles is right with the CHAR in SQL and VARCHAR in RPG discrepancy - you should use the same type, because SQL doesn't know that it should convert the data type. 

But DECIMAL = PACKED if I recall correctly - NUMERIC = ZONED - so that should be OK. 

I can't see any other problems with your source, so probably there is another function of the same name, which is somehow interfering. 

Whenever I end in such problems, I search SYSFUNCS for duplicates - and then drop all previous / duplicate definitions, before defining the function again. Also using a specific name is often good - especially if I have polymorphic functions, I add parameter data types to the end of the function name, to make it unique. 

HTH
Daniel


> Am 06.04.2026 um 22:44 schrieb gio.cot via RPG400-L <[email protected]>:
> 
> Hi Charles
> Sorry but i didn't understand what you mean .. could you please show me some sql examples how to run the UDF ?   (with decimal point for Db2 or with cast)
> 
> Be patient ...
> Thanks
> 
> 
> 
> 
> 
> 
> 
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
> 
> Please contact [email protected] for any subscription related questions.
> 
-- 
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact [email protected] for any subscription related questions.