RE: UDFx error 42884

A hardcoded character parameter is always interpreted as VARCHAR.
A hardcoded numeric parameter without decimal positions is always interpreted as integer.

Since SQL functions can be overloaded, i.e. the same function with the same name can coexist within the same library but with different parameter definitions.
If you do not pass the parameters in the expected format, the function may not be found.
For testing you should explicitly cast the parameters into the expected format.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect  
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)


-----Original Message-----
From: RPG400-L <[email protected]> On Behalf Of gio.cot via RPG400-L
Sent: Monday, 6 April 2026 16:55
To: 'RPG programming on IBM i' <[email protected]>
Cc: gio.cot <[email protected]>
Subject: R: UDFx error 42884

Hi Charles

I tryed this " select * from table(mylib.ZGIACART_Z( cast('020146' as
varchar)   ,  cast(20261231 as decimal) )) as t;" but i receive SQL: 42611



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.