RE: Create Function Called On Null Input

[Mark Adkins <adkinsm@xxxxxxxxxx>]

Matt,

"No SQL" is one option.  "Called On Null Input" is another option (which
should force the function call regardless of null input(s)...).

Thanks for the response,

Mark

-----Original Message-----
Subject: RE: Create Function Called On Null Input
From: "Haas, Matt" <Matt.Haas@xxxxxxxxxxxxxxxxxxx>
Date: Mon, 30 Jun 2003 09:16:41 -0400
List-archive: <http://archive.midrange.com/rpg400-l>

Mark,

I'm looking at the phrase "NO SQL CALLED ON NULL INPUT" and it seems to me
that
this is your problem.

Matt
-----Original Message-----
From: Mark Adkins [mailto:adkinsm@xxxxxxxxxx]
Sent: Friday, June 27, 2003 6:07 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Create Function Called On Null Input

I have created a function using:

CREATE FUNCTION MINOF (SMALLINT, SMALLINT, SMALLINT,
                       SMALLINT, SMALLINT, SMALLINT)
RETURNS SMALLINT
LANGUAGE RPGLE
PARAMETER STYLE GENERAL WITH NULLS
SPECIFIC MINOF NOT DETERMINISTIC
NO SQL CALLED ON NULL INPUT
EXTERNAL ACTION
FENCED
EXTERNAL NAME 'MAALIB/MINOF(MINOF)'
<snip>