Re: Help with UDFs or stored procedures

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Dan - you are now in the world of using the SQL or the GENERAL WITH 
NULLS parameter style - that means you have to add indicators for 
NULL. This means you cannot use an existing service program as is. 
Check the redbook for what the parameters need to be. Basically you 
set an extra parameter to indicate a NULL.

HTH
Vern

At 05:34 PM 12/18/2006, you wrote:

> On 12/15/06, Gene Burns <burns.gene@xxxxxxxxx> wrote:
> >
> > Here is an example of a service program and SQL Function that converts 3
> > fields to a date.  This could be easily changed to use 4 fields.
> >
> > http://code.midrange.com/index.php?id=4e7318f239
> >
>
> Thanks for the link.  It works great, EXCEPT <g> I was hoping to return a
> null value if the numeric input fields did not form a valid date.  I tried:
>     Return *NULL ;
> but the compiler spit it out because it wasn't a date data type.
>
> For now, invalid dates return 0001-01-01, but I'd rather return a null
> value.  Any ideas?
>
> TIA,
> Dan
> --
> This is the RPG programming on the AS400 / 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.