Re: UDFx error 42884

This:
CREATE OR REPLACE FUNCTION mylib.ZGIACART_Z (
  CODART CHAR(17) ,
  DATARIF decimal(8, 0)
)
Should be
CREATE OR REPLACE FUNCTION mylib.ZGIACART_Z (
  CODART VARCHAR(17) ,
  DATARIF decimal(8, 0)
)


And I think Db2 may be looking for DATARIF as an integer, giving the
literal you are using.  So instead, call it like this:
mylib.ZGIACART_Z('020146'   ,  20261231. ))

Note the trailing decimal point on 20261231.

Charles

On Mon, Apr 6, 2026 at 2:44 PM gio.cot via RPG400-L <
[email protected]> wrote:

> 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.