Re: How does a SQL result set return pack fields to the caller

On Mon, Jul 3, 2017 at 6:53 AM, a4g atl <a4ginatl2@xxxxxxxxx> wrote:

My practice has always been to define the fields in a data
structure for a result set as character.

​That is a bad practice....

The SQL standard includes DECIMAL and NUMERIC fixed decimal types. On the
i, those correspond to PACKED or ZONED. But that's just how they are
stored on the i, not necessarily how they are returned externally.

It doesn't really matter how those are sent on the wire, the point being
the DB and the driver support SQL fixed decimal types and that the calling
language support some sort of fix decimal type that maps to the SQL types.

​Charles​