Re: Using SQL UDF in SQLRPGLE program gets decimal data error

[qsrvbas@xxxxxxxxxxxx (Tom Liotta)]

Rob:

Hmmm... guess I should've been more explicit. True enough that the definition 
of a UDF itself can be found as you describe, but I was wondering about the 
definitions within the UDF, the field/object definition table, if you will.

In the case of this thread, the field definitions listed by the compiler do not 
seem to match the behavior of the UDF.

Or were you saying that the field definitions are also available there and I 
just haven't looked for them correctly?

Tom Liotta

rpg400-l-request@midrange.com wrote:

>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
>
>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 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/