Re: Creating a SQL UDF

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Robert,

I haven't run across this error before, but I suspect it's because 
you've coded "allow parallel".   This would mean that it's trying to 
call your UDF in multiple threads at once.   I suspect that your RPG 
program is not coded to handle multi-threaded calls.

Try changing it to "disallow parallel" and see if that solves the problem.

-SK


On 9/27/2013 7:29 AM, Robert Mullis wrote:
> Function error X'0306' in machine instruction. Internal dump identifier
> (ID) 0100A758.
>
> There is nothing else in my joblog, but this message.  This is how I
> defined my UDF:
>
> Create Function RMULLIS/RmvNonAlph(VarChar(1000),VarChar(1))
>    Returns VarChar(1000)
>    Language RPGLE
>    External Name 'RMULLIS/SYSRVUTL(REMOVE_NON_ALPHANUMERIC)'
>    Deterministic
>    No SQL
>    Parameter Style General
>    Allow Parallel
>    No External Action
>
> Any ideas on what might cause this error?