RE: Help with UDFs or stored procedures

Dan,    
        You can create a User Defined Function (UDF) out of an RPG
program. So if you already have a program that does what you want you
just need to define the UDF through Iseries Navigator. 
        Open navigator and drill into databases | Your connection |
Schemas | Your Lib. Right click on Functions and select New | External.

From there you define the parms and the result passed back. 

        Then you can use the function in SQL statements. 
For example I have a UDF that converts JDEdwards dates to real date
types. My SQL can look like this: Select CVTFROMJDE(JdeDate) as Realdate
from JDEFile. CVTFROMJDE is my UDF that actually calls a procedure I
have in a service program. 

Steve...
     

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan
Sent: Friday, December 15, 2006 4:39 PM
To: Midrange Systems Technical Discussion; RPG400-L@xxxxxxxxxxxx
Subject: Help with UDFs or stored procedures

(Cross-posted to midrange-l and rpg400-l)

Our legacy database files are littered with dates defined as four
numeric
fields, with a 2-digit century, 2-digit year, month, and day.  I must
work
with these dates in SQL and WrkQry, sometimes in RPG.  I would like to
define either a UDF or stored procedure or *something* that would
convert
four input parameters into a date result.  It would be nice if I could
use
the same function in an SQL statement and in RPG code, but not a
requirement.

So, I need to read up on how to do this, and how to choose UDF vs.
stored
procedure.  I searched the archives, saw a few examples of code, but did
not
see any reference on how to call the UDF or stored procedure.

Can anyone suggest good online references?

TIA,
Dan