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 <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of gio.cot via RPG400-L
Sent: Monday, 6 April 2026 16:55
To: 'RPG programming on IBM i' <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: gio.cot <gio.cot@xxxxxxxxxxx>
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: 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.
midrange.com
