Re: UDFx error 42884

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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