Re: How do I create a UDF?

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Interesting, never realized the LANGUAGE SQL had to be in a certain spot.

Charles

On Tue, Aug 18, 2009 at 1:57 PM, sjl<sjl_abc@xxxxxxxxxxx> wrote:
> Michael -
>
> You need to rearrange some of the code.
> The 'Language SQL' statement is in the wrong place.
>
> See below.  This worked for me!
>
> - Steve
>
>
> Create Function myLib/IsNumeric(@TestData VarChar(64))
> Returns Char(1)
> Language SQL
> Deterministic
> Not Fenced
> Set Option Commit=*None, UsrPrf=*Owner
> Begin
>  Declare @Double Double Not Null Default 0;
>  Declare Exit Handler For SQLException
>  Return 'N';
>  If @TestData Is Null Then
>  Return 'N';
>  End If;
>  Set @Double=Cast(@TestData As Double);
>  Return 'Y';
> End
>
>
>
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.