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 <rpg400-l@xxxxxxxxxxxxxxxxxx>:

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: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.