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

[rob@xxxxxxxxx]

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I right clicked on one function:

First tab:  General
Contains the following:
Description
Data returned to invoking statement, type, length, CCSID
And numerous other stuff like 'reads sql data'.

Second tab:  Parameters
Guess what this tells you.

Third tab:  External program
Here's your service program, module, subprocedure, or java method.

Thus this stuff has to be in those tables somewhere.

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)
Sent by: rpg400-l-admin@midrange.com
09/23/2002 12:12 PM
Please respond to rpg400-l


        To:     rpg400-l@midrange.com
        cc:
        Fax to:
        Subject:        Re: Using SQL UDF in SQLRPGLE program gets decimal data 
error


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