RE: Creating a SQL UDF

Thanks Scott.

I tried the "disallow parallel", but still got the same error.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Friday, September 27, 2013 3:21 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: Creating a SQL UDF

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?

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.