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

Hi Matt,

Now that's interesting.  The SQL Concepts manual says:

"A DECIMAL value is a packed-decimal or zoned-decimal number with an
implicit decimal point. The position of the decimal point is determined by
the precision and the scale of the number. The scale, which is the number of
digits in the fractional part of the number, cannot be negative or greater
than the precision. The maximum precision is 31 digits."

And just as an aside, it also says

"For portability of functions across platforms that are not DB2 UDB for
iSeries, do not use the following data types, which might have different
representations on different platforms:
    FLOAT. Use DOUBLE or REAL instead.
    NUMERIC. Use DECIMAL instead."

But as you point out, the parameter passing section says DECIMAL is passed
as packed-decimal, and NUMERIC is passed as zoned-decimal.

So what you say makes sense.

However, the SELECT statement has no problem using the UDF, so if DEC is
only packed-decimal, then either SQL is handling the conversion for me, or
the CONST on the UDF parameters is kicking in.

And the RPGLE program has no problem passing zoned-decimal numbers to the
UDF; only the SQLRPGLE program does.

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>
To: <rpg400-l@midrange.com>
Sent: Friday, September 20, 2002 7:48 AM
Subject: RE: Using SQL UDF in SQLRPGLE program gets decimal data error


> Peter,
> 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.