Re: UDFx error 42884

[Charles Wilt <charles.wilt@xxxxxxxxx>]

TIL..

I've never actually seen that error.

Honestly, ACTGRP(*NEW) is always a red flag that should be questioned and
justified.  And it is 100% never valid in anything called repeatedly. I
just never realized Db2 wouldn't allow it in a UDTF. Glad to hear it though.

If you don't want to learn how to actually use ILE, then using
ACTGRP('MYCOMPANY') everywhere is a safe starting point.

Best practice is to use ACTGRP(*CALLER) for service programs.  It's also
usually ok for programs that are never called from the command line, such
as your UDTF.  But ACTGRP(*CALLER) everywhere can lead to ILE programs
activated into the default activation group (DAG).  This is the first of
the "Seven Deadly Sins of ILE" by Jon Paris and Susan Gantner (
https://authory.com/JonParisAndSusanGantner/a/a0f4e66fe37a745c8bdf7cbc95f0b365f
)

For that matter, "Third deadly sin: Using *NEW by default rather than by
design."  Which is exactly why I called ACTGRP(*NEW) a red flag.

HTH,
Charles


On Tue, Apr 7, 2026 at 4:23 AM gio.cot via RPG400-L <
rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:

> Hi all
> The problem was in  RPGLE ctl-opt "ACTGRP(*NEW) "
> Run   dspjob from 5250 i have found :
>
> "Message ID . . . . . : CPF426A
> Sent Date . . . . . . : 07/04/26 Sent Time . . . . . . : 12:16:36 PM
> Message . . . : The user-defined function ZGIACART_Z cannot be called.
> Cause . . . . : An external program or a ZGIACART service program in the
> mylib library associated with the user-defined function
>  ZGIACART_Z in the mylib library cannot be called due to reason code 5.
> The reason codes and their meanings follow:
> ....
> 5 -- The program or service program specifies ACTGRP(*NEW)."
>
> From ACS SQL console, id there anyway to see all job message that i see in
> 5250 ??
>
> Thanks all
> Gio
>
>
>
>
>
> --
> 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.