Re: SQL Functions

[Alan Campin <alan0307d@xxxxxxxxx>]

Sharon, don't know if you are interested but if you go to
http://www.think400.dk/downloads.htm and look for iDate you will find a
complete user defined function that converts AS/400 type dates (numbers,
char, etc) into true date data types (iDate) and a User Defined function
that converts a date data type into an integer. (ConvertToiDate).

SELECT ConvertToiDate(iDate(ORDATE)) FROM "ORDER"

This statement converts a 8 digit date as/400 type date to a date data type
and then back to an integer.

iDate supports all kinds of dates formats. Complete documentation is
included.

*MDY
*CCYYMDD
*YMD
etc

You will find all you need to do User Defined Functions. Hope this helps.
Let me know if you have questions.

On Fri, Jan 16, 2009 at 11:17 AM, Wintermute, Sharon <
Sharon.Wintermute@xxxxxxxxxxxxxxxx> wrote:

> I am finally diving into SQL functions.  I created my first function.
> CURDATE80 which returns the current date as an INT type.  (Had to try
> something simple first).
>
> When I look on Ops Nav, I can see the function in the schema. (Its in
> QGPL for now.)
>
> If I try to use it, it doesn't find it.
>
> What step did I miss?  Oh, V5R4M0.
>
>
> TIA,
>
> Sharon Wintermute
>
> --
> 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.