Re: Using SQL UDF in SQLRPGLE program gets decimal data error (Alexei Pytel)

[rob@xxxxxxxxx]

We all know that a UDF is not an object right?  Well, iSeries Navigator
will show you udf's as if they were an object.  Open up your system, then
databases, then the library you think the UDF is in.  The udf will show up
as a type of function.  Stored procedures will show up that way.
Prior to V5R2 you would look in the library QSYS2 for the tables SYSPROCS
for stored procedures and SYSFUNCS for udf's.  However at V5R2 IBM
recommends you use the library SYSIBM.  And I don't know the name of the
new tables right off the top of my head.  The point of the library SYSIBM
is compatibility with other versions of DB2.

Rob Berendt
--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety."
Benjamin Franklin



                      qsrvbas@netscape.
                      net (Tom Liotta)         To:       rpg400-l@midrange.com
                      Sent by:                 cc:
                      rpg400-l-admin@mi        Fax to:
                      drange.com               Subject:  Re: Using SQL UDF in 
SQLRPGLE program gets decimal data error (Alexei Pytel)


                      09/20/2002 02:39
                      PM
                      Please respond to
                      rpg400-l






rpg400-l-request@midrange.com wrote:

>It looks like it confirms my guess that UDF expects packed decimal data.
>This is consistent with debugger showing only 5 bytes for data (vs 8).

So... where is the debugger getting the byte-length of <5> from? The
portions of compiler listings sure didn't seem to indicate <5> anywhere.

Is there anywhere that the UDF definitions can be seen?


Tom

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone  253-872-7788 x313
Fax    253-872-7904
http://www.powertechgroup.com


__________________________________________________________________
The NEW Netscape 7.0 browser is now available. Upgrade now!
http://channels.netscape.com/ns/browsers/download.jsp

Get your own FREE, personal Netscape Mail account today at
http://webmail.netscape.com/
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.