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

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).

    Alexei Pytel
always speaking only for myself




                      "Peter Dow"
                      <maillist@dowsoft        To:       <rpg400-l@midrange.com>
                      ware.com>                cc:
                      Sent by:                 Subject:  Re: Using SQL UDF in 
SQLRPGLE program gets decimal
                      rpg400-l-admin@mi         data error
                      drange.com


                      09/20/2002 01:17
                      PM
                      Please respond to
                      rpg400-l





Hi Matt,

I tried changing the CREATE FUNCTION to use NUMERIC instead of DEC, and it
fails with a decimal data error when I try the SELECT interactively.  I
would've thought it would work since it's zoned to zoned.  This is really
getting interesting!

Peter Dow
Dow Software Services, Inc.
909 793-9050 voice
909 522-3214 cellular
909 793-4480 fax

----- Original Message -----
From: "Tyler, Matt" <mattt@wincofoods.com>
Sent: Friday, September 20, 2002 7:48 AM
Subject: RE: Using SQL UDF in SQLRPGLE program gets decimal data error


> I also noticed that the UDF definition specifies that the input
> parameters are of DEC() type which equates to a PACKED in RPG.  Try using
> NUM() (NUMERIC=ZONED) instead since you are only using fields that are
> zoned.



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