Re: Using SQL UDF in SQLRPGLE program gets decimal data error

Hi Matt,

You're making sense, in fact there's an APAR about getting an MCH1202 when
the UDF returns NULL and the receiving variable has not been initialized,
e.g.

    c            eval    x = TestUDF(parm1:parm2)

if TestUDF returns NULL, and x is an uninitialized numeric field, you'll get
a decimal data error.  However, in my case, the receiving variable has been
initialized.

Thanks for the reply!

Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 522-3214 cellular
909 793-4480 fax


----- Original Message -----
From: "Tyler, Matt" <mattt@wincofoods.com>
Sent: Thursday, September 19, 2002 3:44 PM
Subject: RE: Using SQL UDF in SQLRPGLE program gets decimal data error


> How about removing the statement "RETURNS NULL ON NULL INPUT".
>
> Maybe ELAPSEDHOURS() is returning a nulled result which in RPGIV actually
> has data (unpredictable data but data none the less).  All null capable DB
> columns do actually contain data and you can reference that data but you
> might get a data decimal error.  You can only test the null status of a DB
> column.  Any program created field will not have the null indicator.
>
> I hope I made sense here.